How to check out or edit a SQL server report (.rdl) deployed to a sharepoint site
I have used SSRS before to edit and publish reports to the SQL server reporting server, and I was able to edit these by going to the properties of the report, then saving the .rdl file locally and opening it with an SSRS project.
The sharepoint developer for our company has moved onto better things, and now I need to edit one of the .rdl files I asked him to publish.
How do I get it out of sharepoint and onto my desktop? I have clicked myself into insanity. I feel like I am in a circle looking for the corner.
Please give me step by step instructions on how to edit this (.rdl) file and check it back in so every one else uses the new .rdl file. I need to add a column to the query.
To add a slight bit of complexity, I don't think I have any of the tools like report designer, or any of the sharepoint tools. I would need to copy the .rdl file locally, the edit it with BIDS, then check it back in.
The sharepoint developer for our company has moved onto better things, and now I need to edit one of the .rdl files I asked him to publish.
How do I get it out of sharepoint and onto my desktop? I have clicked myself into insanity. I feel like I am in a circle looking for the corner.
Please give me step by step instructions on how to edit this (.rdl) file and check it back in so every one else uses the new .rdl file. I need to add a column to the query.
To add a slight bit of complexity, I don't think I have any of the tools like report designer, or any of the sharepoint tools. I would need to copy the .rdl file locally, the edit it with BIDS, then check it back in.
Scott McDaniel (EE MVE )
You'd have to locate that document on the Sharepoint server. It's impossible to say where that would be; can you Search the Sharepoint site for that specific file name, assuming it exists? It may be stored on the SQL Server, which means you couldn't get to it via a simple search. If that's the case, then I'm not sure what you could do ...
ASKER
I know exactly where the report is located. I am clicking around, but I can't figure out how to copy it locally.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Where do you see the "Actions" menu?
When I go to my http://localhost/reportserver, it is basically a page that opens that simply lists the rdl files (and I can click on each one of them to run the reports), but there are no menu options like 'Action'.
The screen just allows me to browse to the different reports, kind of like looking at an FTP site through Internet Explorer ...
When I go to my http://localhost/reportserver, it is basically a page that opens that simply lists the rdl files (and I can click on each one of them to run the reports), but there are no menu options like 'Action'.
The screen just allows me to browse to the different reports, kind of like looking at an FTP site through Internet Explorer ...
I found the "actions" menu by logging into sharepoint at http://localhost (vs. the /reportserver that I was going to earlier).
However, the action - menu does not have the option "view in windows explorer".
The only options are "open with report builder" (which doesn't work since SSRS is running within sharepoint), "subscribe" and "export" (which exports the report data, not the rdl).
How can I edit the rdl report?
However, the action - menu does not have the option "view in windows explorer".
The only options are "open with report builder" (which doesn't work since SSRS is running within sharepoint), "subscribe" and "export" (which exports the report data, not the rdl).
How can I edit the rdl report?
ASKER
I think you have to have "site admin" privileges. to see that option. The only way to edit the .rdl is to open it in VS or BIDS. BIDS is part of SQL server, although I don't think it installs by default.