SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Multiple drill through options


Multiple drill through options

Author
Message
tim.easley
tim.easley
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 2
I'm trying to replace existing reports from another BI tool with SSRS reports. The old tool offered an option to create multiple drill through reports. When the user clicks a link in the report they get a pop-up menu to choose which report they want to drill through to. Has anyone seen this type of functionality using Report Builder? So far it looks like I can only follow a single drill through path.

Very new to SSRS and have yet only had time for Lynda training.
Scott Murray-240410
Scott Murray-240410
SSC-Addicted
SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)

Group: General Forum Members
Points: 411 Visits: 3118
You can actually adjust the drill through text to a logically expression based on some other value including a parameter.

As an example, you may have a parameter that that has 5 different reports in the drop down....
For example..
Invoice Detail Report
Line Detail Report
Customer Report
Warehouse Report
Inventory Report

Then when the report user clicks on a specific field... say a product id, based on the parameter selected, the specific report would open. Of course you could use the product id as one of the parameters for the report to be opened.


The drill through logic could either be a multi layered "IIF" or you could use "Switch" which I find a little easier to use and comprehend.
JBrosch
JBrosch
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 41
As to your status of newbie, may I suggest WiseOwl training videos? VERY good and FREE (I like free!!)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search