How to edit a report in "home" follder in reporting server.

Question

How to edit a report in "home" follder in reporting server.

Joy Smith San

SSC-Insane

Points: 24877
More actions
March 6, 2012 at 6:19 am

#269576

Experts,
I may sound stupid. New to reporting services.
I connected to one of the reporting server.
In the "home" folder I am able to see many reports there.
I want to edit one of the report in that, how can I do it ?
(I know how to create a new eport and deploy the same.)
Thanks,
Smith.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113504 More actions · Answer 1

you just need to hit the drop down arrow, which appears when you hover over the report, then you can modify a number of things and edit the actual RDL in report builder which when you save it in RB it sends the updated RDL back up to the server

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 2

Thanks.

What I did was, right clicked on repot name and Edited.

It asked for the location to save and saved it.

I opened it in studio and icnluded this .RDL file file in reports.

Problem is I don't get to see what query was written to ge the data.

Reports were made by someone else. I have access to only those deployed reports.

I got to modify those reports now. That's the requirement. Can anyone help pls.

Thanks again.

Smith.

Ant-Green SSC Guru Points: 113504 More actions · Answer 3

did you open the report in report builder which is the bottom option when you use the drop down menu when you hover over the report item?

or did you save the target as an rdl file then import that into a solution in BIDS?

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 4

anthony.green (3/6/2012)
did you open the report in report builder which is the bottom option when you use the drop down menu when you hover over the report item?
or did you save the target as an rdl file then import that into a solution in BIDS?

I did exactly the second one. Saved the target as an rdl file then import that into a solution in BIDS.

Actualy I dont get to see the first option at all.

Please guide how to go ahead.

Thanks.

Ant-Green SSC Guru Points: 113504 More actions · Answer 5

easiest option would be to get your ssrs admins to give you report builder access that way you can modify them direct on the server.

if that's not an option there is a tool called rsscripter which will pull off all the reports and objects in ssrs which you can then load into bids modify then deploy

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 6

anthony.green (3/6/2012)
easiest option would be to get your ssrs admins to give you report builder access that way you can modify them direct on the server.
if that's not an option there is a tool called rsscripter which will pull off all the reports and objects in ssrs which you can then load into bids modify then deploy

I am the admin in my local machine. I dont know why but I am not seeing the report builder at all. It's SQL Server 2005 OK. Think am looking at wrong place.

Thanks.

Ant-Green SSC Guru Points: 113504 More actions · Answer 7

so SSRS is installed on your local machine where you are trying to get the reports from? or are they on a remote server?

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 8

Yes, it's on the remote server.

I downloaded the "rsscripter" you mentioned and took the project and datasource files for few reports. Copied and opened in local server. Checking now...

I found it's simple beocse we dont need to install anything.

Thanks a lot. I will check the copied file and revert.

Smith.

Ant-Green SSC Guru Points: 113504 More actions · Answer 9

do you have local admin access to the remote server?

if not ask someone who has got local admin to grant you report builder rights which will save you downloading modifying and uploading.

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 10

That's OK with me. Since I am new to this, it's better copy somewhere and play with it.

Well, I opened the project without any pbm. Now in the "Data" tab, am able to see the below code. Think it's made based on cubes. So I will have to get those cubes as well ?

SELECT NON EMPTY { [Measures].[Computer Count] } ON COLUMNS,

NON EMPTY { ([Computer].[Computer - OS Name].[Computer - OS Name].ALLMEMBERS

* [Computer].[Computer - OS Version].[Computer - OS Version].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

FROM ( SELECT ( STRTOSET(@Filter) ) ON COLUMNS

FROM ( SELECT ( STRTOSET(@OrganizationalGroup) ) ON COLUMNS

FROM [Computers]

))

Any idea ?

Thanks,

Smith.

Ant-Green SSC Guru Points: 113504 More actions · Answer 11

Yep that looks like MDX to me, not my strong point I'm afraid.

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 12

Fine. I will try to get the cubes and modify it as well.

I don't know if am on right direction. But I got to do it somehow.

Thanks again. You realy helped me.