Sunday 15 April 2012

reporting services - Column visibility based on 2 parameters in SSRS -



reporting services - Column visibility based on 2 parameters in SSRS -

i have parameter 'section' has values a,b,c , parameter 'field' has values x,y,z. requirement need create column visibility based on both parameters,if parameter 'section' , parameter 'field' x column should shown else hidden.both multi-valued parameters. have written next look not allowing me run

=iif(instr(join(parameters!sections.label,", "),"a"),instr(join(parameters!fields.label,", "),"x", false,true),true)

error getting while running study "input string not in right format. can help me in correcting format?

try this:

=iif(instr(join(parameters!sections.label,", "),"a") , instr(join(parameters!fields.label,", "),"x"), true,false)

reporting-services ssrs-2008 ssrs-2008-r2 ssrs-tablix ssrs-grouping

No comments:

Post a Comment