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