Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multiple drill through options Expand / Collapse
Author
Message
Posted Tuesday, November 12, 2013 9:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 13, 2013 10:32 AM
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.
Post #1513532
Posted Wednesday, November 13, 2013 4:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:27 AM
Points: 243, Visits: 2,738
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.
Post #1513803
Posted Wednesday, November 13, 2013 8:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 24, 2014 3:37 PM
Points: 23, Visits: 29
As to your status of newbie, may I suggest WiseOwl training videos? VERY good and FREE (I like free!!)
Post #1513923
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse