reporting services - Open subreport depending on column value in SSRS -


i have 6 possible subreports , 6 possible values in 1 column. want click on column , open subreport associated value. found couple places recommending

=iif(fields!datatype.value = "xxx","<path>", iif(fields!datatype.value = "yyy","<path>",nothing) 

with format, won't anything, no clicking option on column

my path on server it's /homefolder/reports/subreports/report returns item containing invalid char , doesn't show report

this expression have not work. returns databox invalid error.

iif(fields!datatype.value = "ple",/reports/subreports/plereport,nothing) 

right click on column field>text box properties

enter image description here


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -