Solved

How to manage linked reports in Reporting Service

Posted on 2009-06-29
4
190 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

How our DevOps Teams Maximize Uptime

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

Question has a verified solution.

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

840 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