Optional series in a SSRS chart?

Question

Hi, is it possible to make a series in a chart optional (i.e. only rendered when the user clicks a checkbox, in case the corresponding query takes a while and may not be required)?

Or are there any alternative solutions where users can incrementally select the data series/charts they would like to see?

Answer 1

This can be achieved with Parameters.

You can set parameters to decide what is to be displayed on the report during runtime. You can programatically set the parameters with the help of a few controls places alongside the reportviewer control.