Solved

How to manage linked reports in Reporting Service

Posted on 2009-06-29
4
189 Views
Last Modified: 2012-05-07
Hi there:
   Linked reports are great feature but it gets a bit messy when large amount of linked reports are being created...For example, is there any quick way to find out the list of people who has a specific linked report? So far, I managed all the jobs via report manager but those tedious clickings
just drove me insane, is there any convenient tools available so that I could use to manage linked reports?

 Thanks

 Hui
0
Comment
Question by:HuiShi
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
Auric1983 earned 500 total points
ID: 24739526
This tip from MS SQL Tips is great

http://www.mssqltips.com/tip.asp?tip=1306

You can query the Reporting Services DB to find out who is doing what.
0
 

Author Comment

by:HuiShi
ID: 24739552
thanks for the tips, do you know the meaning of each columns in the catalog table??
0
 
LVL 16

Expert Comment

by:Auric1983
ID: 24739588
Off hand no, but I can try to dig through it
0
 

Author Comment

by:HuiShi
ID: 24739623
thanks , I googled around but could not find the meanings of each column yet....
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Data source in SSRS 2 52
SSRS report showing old data. 5 117
SSRS Calculation of two fields not working 7 55
SSRS List box paramaters showing duplicate choices 2 27
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question