Dynamic Connection String and Drill-Down 'Dashboard' Charts

• dan.cordle

  Newbie

  Points: 7

  More actions

  July 7, 2016 at 1:22 pm

  #400376

  Scenario:

  Dashboard type report, one bar graph showing amount by year, and two pie charts breaking down the amount by other factors, based on the year clicked from the bar graph. (very similar to this: https://blogs.msdn.microsoft.com/mind_talks/2012/03/06/creating-a-drilldown-dashboard-with-ssrs/)

  I've got this working without issue on a single database, but I'm trying to make the database it runs against selectable via parameter. I've got this working for the initial selection and run of the report. However, when a new item (year) is clicked in the bar chart, the database selection parameter is being asked for again. Is there any way to have the initial database selection passed through without it being asked for again?

  in short:

  user runs the report, selects the database they want to run it against. Report renders correctly. When clicking a different year in the bar graph, user is asked to select the database again. Would like to avoid the secondary selection.

  Thanks in advance for any help/suggestions.