Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS 2000 Drill Through Reports

Status
Not open for further replies.

dhulbert

Technical User
Jun 26, 2003
1,136
GB

I have a large number of reports (30+) each of which need to have a dril throuhg to the same report.
1 Can I drill through to a report not in the same directory as the existing report?
2 If not how can I copy a report to multiple folders on a Reporting Serivces portal or do I have to publish the report to each folder? (30+ times [sad] )

Thanks.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)
 
1 Can I drill through to a report not in the same directory as the existing report?
Yes, you can do this by setting the folder as well as the report name, for example I specify the following relative path+report name to have many main reports call a subreport in a subfolder...

=".\uat\MovingAverageUAT"
 
as per above - use the "jump to url" option rather than jump to report

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top