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
Comments
Post a Comment