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


Add to briefcase

Where does Reporting Services store reports? Expand / Collapse
Author
Message
Posted Thursday, January 30, 2014 7:59 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 2,335, Visits: 2,668
Hello experts,

I'm trying to document the storage part of my Reporting Services and I don't have a clear sense of where the files end up being stored. For example, when someone opens Report Builder and saves a report, is it saved locally on their computer or on the server? Also, are report definitions stored straight to the ReportServer database or as external files? I figure there must be documentation on these items somewhere, but my Googling has been ineffective. Before I hunt through Books Online I'm wondering there is a central place where this information is described.

Thanks for any help,
webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1536361
Posted Friday, January 31, 2014 4:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 6:23 AM
Points: 237, Visits: 2,663
The reports XML is saved in the ReportServer database (unless you named it otherwise). The funny thing is I am unsure where in the documentation it specifies this, however this link may help. http://www.sqlservercentral.com/blogs/juggling_with_sql/2013/08/07/ssrs-download-all-rdl-files-from-report-server-in-one-go/


As for the configurations, technet has the best writeup....http://technet.microsoft.com/en-us/library/ms155866.aspx
Post #1536708
Posted Friday, January 31, 2014 11:13 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:08 AM
Points: 2,335, Visits: 2,668
Thanks for this information!

- webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1536910
Posted Friday, January 31, 2014 2:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 26, 2014 8:45 AM
Points: 25, Visits: 269
If you ever have the need to transfer the report files in bulk, then there is a great tool available that will do the work for you. I found it interesting that there was not a native GUI for moving report files in bulk.

Here is the link: ReportSync


Blog: http://sqlexchange.wordpress.com
Post #1536991
Posted Thursday, February 20, 2014 1:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 8:41 AM
Points: 14, Visits: 398
--Try this query

;WITH XMLNAMESPACES (
DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition',
'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner' AS rd
)
SELECT
name,
path,
x.value('CommandType[1]', 'VARCHAR(50)') AS CommandType,
x.value('CommandText[1]','VARCHAR(MAX)') AS CommandText,
x.value('DataSourceName[1]','VARCHAR(50)') AS DataSource
FROM (
select name, path,
CAST(CAST(content AS VARBINARY(MAX)) AS XML) AS reportXML
from ReportServer$EVAL.dbo.Catalog --Put your report database name here instead of "ReportServer$EVAL"
where content is not null
and type != 3
) a
CROSS APPLY reportXML.nodes('/Report/DataSets/DataSet/Query') r(x)
ORDER BY name
Post #1543719
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse