SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



SQL Server Reports project location\extension Expand / Collapse
Author
Message
Posted Monday, September 21, 2009 4:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Post #791022
Posted Monday, September 21, 2009 10:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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.
Post #791294
Posted Tuesday, September 22, 2009 11:02 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing 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.
Post #792004
Posted Wednesday, September 23, 2009 11:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC 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...
Post #792849
« Prev Topic | Next Topic »


Permissions Expand / Collapse