Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 location of the ssrs reports?

Author  Topic 

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2010-05-24 : 14:27:49
Any idea where the actual ssrs reports are stored on the ssrs server?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-24 : 15:11:47
They are stored in the ReportServer database inside SQL Server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2010-05-24 : 15:59:41
Tara,

which table. I can't find it...

Adam
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-24 : 16:08:07
They are stored in the Catalog table.

What are you trying to do? You should not be querying this data, and the fact that you want to know where they are stored leads me to believe you trying to do something that can be better done in another way.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2010-05-24 : 16:19:57
We are requested to Backup all reports

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-24 : 16:21:25
Then you just simply do the following:
1. Backup the ReportServer database
2. Store the rdl files into source control

Both should be done, and not just one of them. If you have lost an rdl file but still have it in Report Server, then you can export it from Report Server web page.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

andrewhopkinson
Yak Posting Veteran

63 Posts

Posted - 2010-05-25 : 15:25:46
Just to chime in on this, does all the stuff in the rdl file go into the "content" column of the catalog table?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-25 : 17:16:57
I'm not sure, but I don't think the format is readable to us.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

navya krishna
Starting Member

39 Posts

Posted - 2013-01-23 : 00:42:48
Dear all,

i have one problem in ssrs.i need to display sales report customer wise [sales and budget and variance and variance percentage] from different databases but in single server.it will be there detailes in multiple databases.i need to display detailes in single report.could you please anyone help me.for example we are maintaining 2010,2011 databases so i need to display customer no,sales,budget,variance,variance percentage in single report ...

year from 2012 year to 2013 date filter 01-01-12..31-12-13

Customer No. Sales -2012 Budget-2012 Variance-2012 Variance %-2012 Sales -2013 Budget-2013 Variance-2013 Variance %-2013

i need details like this in one report using multiple databases.please anyone help me.










navya krishna katta
Go to Top of Page
   

- Advertisement -