Want to display list of (other, similar) reports IN my reports

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  reporting services   » Want to display list of (other, similar) reports IN my reports

Want to display list of (other, similar) reports IN my reports

Topic RSS Feed

Posts under the topic: Want to display list of (other, similar) reports IN my reports

Posted: 4/30/2012

Jedi Youngling 14  points  Jedi Youngling
  • Joined on: 2/2/2012
  • Posts: 7

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

a list of hyperlinked "similar" reports


Page 1 of 1 (1 items)