September 21, 2009 at 4:40 am
I have inherited a SQL Server which has around 20 handwritten reports in Visual Studio, but I can't find the project/solution for these reports on the server... what should I be looking for?
Thanks
Craig
September 21, 2009 at 10:26 am
The Reporting Services project file is a .rptproj extension. If for some reason you can't find this project file, you can always create a new Report Server Project, then add the reports to the project.
To do so, create the project, right-click on the Report folder, click Add -> Existing Item... Select the reports and click Ok.
Hope this helps!
Michael R.
September 22, 2009 at 11:02 am
If you're looking for the porject/solution files on the report server, you won't find them there unless the developer built them there. Only the RDL files (and data sources) are deployed to the server.
September 23, 2009 at 11:59 am
Use Jaspers tool to reverse engineer the reports and have it create the solution file for you...
http://sqldbatips.com/showarticle.asp?ID=62
Ben Sullins
bensullins.com
Beer is my primary key...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply