June 22, 2010 at 9:58 am
Hey folks,
I am an SSRS newbie. I've been tasked with troubleshooting and cleaning up a report created by an employee who is no longer at the company.
I have found the only .sln file on the machine, which looks (by name) to be the solution I need. I can open it up in Visual Studio 2008 but the "Reports" and "Shared Data Sources" folders in the Solution Explorer window are empty. So my problem is I can't seem to figure out how to edit the report! VS2008 is the only Visual Studio on the box and I'm fairly certain that the report was created with VS2008 and not VS2005.
I have dabbled with SSRS on my laptop and when I open a solution there, I'm able to expand the "Reports" folder in the Solution Explorer and can then edit the .rdl with "Right-Click -> View Designer." I don't have this ability for the report in question.
What am I missing here? Any and all help is hugely appreciated. Thank you!
June 22, 2010 at 10:26 am
When I have to do something like this I always get the code from the report server even when I can find the solution. To get the files you need you can create a new packge call it whatever you would like. open the server and click show details. you then can click the edit icon under the column titled edit. Then on the edit page click edit under the title report definition. A window will open and ask you if you want to open the file or save it. Save the file to you computer. You then can add this file to you solution. you will also have to recreate the data source using the exact name as was on the report server.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 22, 2010 at 1:40 pm
Thanks for the response Dan! I've got a few questions though about it:
1. What do you mean by 'always get the code from the report server'? Is that referring to the rest of the steps in the post?
2. What is meant by 'open the server and click show details.' Are you referring to the actual instance in SSMS? or the server in the Visual Studios Server Explorer?
Sorry for the newbie questions. Thanks for your help!
June 22, 2010 at 1:56 pm
When I am editing a report that some one else desinged I make it a habit of grabbing the report directly from the production server. If you use some kind of central location for source code for example if you store all code on foundation server then that would be the best location however, as a rule I find that many developers (around here atleast) have many versions of the source code. If I open up one of there versions there is no guarentee I am opening the version that is actually published. so I go to the report server website. this is the location where you actually veiw the reports in production. It is likley some address like http://servername/reports/Pages/Folder.aspx
this is where you will see an option to veiw detials and then from there you can grab the produciton version of the report. this will create a hard file to the location you choose when saving it and then you can load it into the solution by right clicking and select add existing report.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 22, 2010 at 2:47 pm
Got it, thanks Dan!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply