Report Builder 3.0 Drill Through Parameter using a chart value

  • Ihave a report that produces a bar chart. This chart lists all of the cost centers sales and the total amountbased on a date range.  I would like forthe user to be able to click on one of the bars and automatically run anotherreport to get the detail. 

     

    Ihave created a drill through report that uses all of the same parameters.  However, the drill through report has 1additional parameter.  The additionalparameter is the cost center name that is displayed at the bottom of each bar.

     

    Isthis possible?  I am trying to do thisthrough the "action" property on the data series.  The part I'm struggling with is the syntax toidentify the parameter value; which is the cost center name that is displayedat the bottom of each bar.

     

    Thanksin advance for any suggestions on how to do this..........

  • mschaper - Wednesday, July 5, 2017 11:43 AM

    Ihave a report that produces a bar chart. This chart lists all of the cost centers sales and the total amountbased on a date range.  I would like forthe user to be able to click on one of the bars and automatically run anotherreport to get the detail. 

     

    Ihave created a drill through report that uses all of the same parameters.  However, the drill through report has 1additional parameter.  The additionalparameter is the cost center name that is displayed at the bottom of each bar.

     

    Isthis possible?  I am trying to do thisthrough the "action" property on the data series.  The part I'm struggling with is the syntax toidentify the parameter value; which is the cost center name that is displayedat the bottom of each bar.

     

    Thanksin advance for any suggestions on how to do this..........

    When you go to add the parameter, look at the drop down for Value. It just lists the fields from your data set. I am guessing the cost center is in that list. Select that.
    This link has an example of doing something fairly similar:
    Drill Down Chart Report in SSRS

    Sue

  • Sue...............Thank you very much.  I read through the link and that solved my issue.  I was trying to fill the value with something like Chart1!.value.  I just wasn't sure of the values to use.  It was a lot simpler / easier than I was trying to make it...........

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

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