Report of Reports

Are there any example of SSRS reports using an rdl file as the source for the report. I.e. a Report of Reports?

[111 byte] By [FreddieTripples] at [2007-12-22]

«« How to Copy SQL 2000 Databases and Logins to SQL 2005
»» overloading the standard operator New

# 1

Hi Freddie,

could you please elaborate a bit more?

thanks, 99

NinetyNine at 2007-8-30 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

# 2

One way of doing this in RS 2005 is to render a report with the xml data rendering extension as xml document. This is then used as input for the xml data extension. However, getting the query setup correctly and working is a bit tricky. A specific sample and explanation for this approach will be available in an upcoming MSDN article about the RS 2005 Xml data extension later this summer.

-- Robert

RobertBrucknerMSFT at 2007-8-30 >

# 3

Thanks Robert,

I did find an article "Integrate XML into Your Reporting Environment" by Bill Wolff at http://www.ftponline.com/special/sqlserver/bwolff/

I will be looking for the upcoming MSDN Article.

To elaborate more on my question...I would like to document my reporting service reports using reporting services. For example which property has custom code (e.g. IIF).

FreddieTripples at 2007-8-30 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech