January 30, 2014 at 7:59 am
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
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
January 31, 2014 at 4:30 am
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/[/url]
As for the configurations, technet has the best writeup....http://technet.microsoft.com/en-us/library/ms155866.aspx
January 31, 2014 at 11:13 am
Thanks for this information!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
January 31, 2014 at 2:45 pm
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.
February 20, 2014 at 1:51 pm
--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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply