hide and show charts in ssrs report -
i have 2 charts in single report .based on parameter value want show charts .parameter @center have 4 values a,b,c,d. if select @center = or @center = b chart1 has display if select @center = c or @center = d chart2 has display in report. both charts little similar .i want write expression hide , show these charts. in advance
right click on chart , select chart properties. click on visibility tab , select show or hide based on expression. click expression icon. on screen can write expression determine when show chart. you'll notice in category menu there section parameters. can find reports parameters here , add them expression. sample expression chart 1:
=iif(parameters!center.value = or parameters!center.value = b, false, true)
Comments
Post a Comment