locked
SSRS Drill down Chart RRS feed

  • Question

  • Is it possible drill down report on chart in sql server reporting service?
    Tuesday, September 6, 2011 9:26 AM

Answers

  • Yes.  Place an Action on the element of the chart you wish to drill down on. 

    For example, if you are using a Column chart, you click on the series properties, go to Action, and enter the name of the new report or url you wish to drill to.  You may assign context relevant parameters to the drilldown report.  The user will then be able to click on the bar as if it were a hyperlink and go to the new report.

    I also suggest that you add a tool-tip to the linked element.  It is not often clear to the user that elements of charts have drilldown capabilities.

    Good luck.


    DJAnsc
    Tuesday, September 6, 2011 12:39 PM
  • Thank you..
    • Marked as answer by Nikhildas.P.C Wednesday, September 14, 2011 12:23 PM
    Wednesday, September 14, 2011 12:23 PM

All replies

  • Yes.  Place an Action on the element of the chart you wish to drill down on. 

    For example, if you are using a Column chart, you click on the series properties, go to Action, and enter the name of the new report or url you wish to drill to.  You may assign context relevant parameters to the drilldown report.  The user will then be able to click on the bar as if it were a hyperlink and go to the new report.

    I also suggest that you add a tool-tip to the linked element.  It is not often clear to the user that elements of charts have drilldown capabilities.

    Good luck.


    DJAnsc
    Tuesday, September 6, 2011 12:39 PM
  • Thank you..
    • Marked as answer by Nikhildas.P.C Wednesday, September 14, 2011 12:23 PM
    Wednesday, September 14, 2011 12:23 PM