Is it possible to do a drill through report with a histogram chart?

  • I have a histogram SSRS chart already built but now there is a requirement to click on any of the bars to get the list of individual rows that make up a given bar. When I tried an initial experiment by right clicking on the chart and selecting series properties, then action from the left hand menu, and finally go to report, the preview does not seem to have a clickable area (icon turning to a hand). My next experiment was to "go to URL" just to see if that would work. It doesn't either.

    I'm trying to find a way to pass the two endpoints of the histogram bins to the detail report. If a user clicks on the 1-10 bin, 1 would be passed as min parameter and 10 as max parameter to detail report with SQL query that has a where clause like :

    WHERE PercentCompletedA between @min-2 and @max-2

    I don't want the user to select values from dropdowns. I'm hoping there's a way to pass Histogram bin endpoints to detail report but I don't see how yet. Do I use Report Variables as well as Parameters? I have been trying and googling all day to no avail so far.

    Is there something about Histograms that makes this not possible? What am I doing wrong? Thanks in advance.

  • pharmkittie (11/20/2014)


    I have a histogram SSRS chart already built but now there is a requirement to click on any of the bars to get the list of individual rows that make up a given bar. When I tried an initial experiment by right clicking on the chart and selecting series properties, then action from the left hand menu, and finally go to report, the preview does not seem to have a clickable area (icon turning to a hand). My next experiment was to "go to URL" just to see if that would work. It doesn't either.

    I'm trying to find a way to pass the two endpoints of the histogram bins to the detail report. If a user clicks on the 1-10 bin, 1 would be passed as min parameter and 10 as max parameter to detail report with SQL query that has a where clause like :

    WHERE PercentCompletedA between @min-2 and @max-2

    I don't want the user to select values from dropdowns. I'm hoping there's a way to pass Histogram bin endpoints to detail report but I don't see how yet. Do I use Report Variables as well as Parameters? I have been trying and googling all day to no avail so far.

    Is there something about Histograms that makes this not possible? What am I doing wrong? Thanks in advance.

    Not sure what you are doing wrong but your experiment using the "series properties" and then action from the menu is correct. Select the report you require and then add then relevant report parameters and it should work. For me, when my mouse pointer is over a column in the chart, the pointer changes to a hand.

  • I think it works when it's a bar chart/column chart but not when it's a histogram. I have tried all day. Does anyone know if it's possible with a histogram? Thanks.

  • What is the difference between a column chart and a histogram - I reckon that they are the same thing

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

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