Posted: 4/30/2012
Greetings,
I am interested in including an additional Tablix region in all of my reports that "suggests" other reports that the viewer might be interested in.
1) The first problem to solve is: Is it possible to query and display in Tablix the report name?
I can see that all of my reports are listed by name in: db=ReportSrver$DS | tbl=dbo.Catalog in my SQL Server.
The following method might get report names, but wouldn't get me the URL:
Let's say that I created reports, placed each in a different folder based on their "Category", then queried this info, wrote it to a table in my actual db used for reporting-against, along with a "Category" that it had picked up from the Path.
e.g. Path=/MyReports/Financial/Operating Margins by Hospital
Writes [ReportSrver$DS].[dbo.Catalog].[Name], "".[Path], "".[Category] to
[MyReportDB].[dbo.ReportList]
2) Here's where I'm not sure how to get the URL or other method to make entries in list "clickable" to open THAT report.
Ideas? THANKS!!!
P.S. This is for a project I posted a pic of in this post (bottom): http://bidn.com/forums/microsoft-business-intelligence/reporting-services/1557/i-want-to-create-an-ssrs-application-e-g-string-multi-reports-into-user-experience