Multiple drill through options

  • 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.

  • 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.

  • As to your status of newbie, may I suggest WiseOwl training videos? VERY good and FREE (I like free!!)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply