|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Monday, March 01, 2010 1:22 AM
Points: 155,
Visits: 143
|
|
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
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Friday, January 29, 2010 8:32 AM
Points: 171,
Visits: 106
|
|
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.
|
|
|
|
|
SSChasing Mays
      
Group: General Forum Members
Last Login: 2 days ago @ 8:43 AM
Points: 686,
Visits: 584
|
|
| 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.
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, February 04, 2010 10:23 AM
Points: 296,
Visits: 265
|
|
Use Jaspers tool to reverse engineer the reports and have it create the solution file for you...
http://sqldbatips.com/showarticle.asp?ID=62
Cheers,
Ben Sullins bensullins.com Beer is my primary key...
|
|
|
|