I am trying to create a SSRS report, where a rectangle box contains several tables and charts based on one dataset (say ds_1), however the visibility of that the rectangle box is dependent on one specific flag (say field = visibility_flag) in other dataset (ds_2 containing columns field and value ). Case1: field = visibility_flag AND value = Y Expected o/p: the output report will have the rectangle box Case2: field = visibility_flag AND value = N OR Case3: flag is not present at all Expected o/p: For both case 2 and 3, the rectangle box will be hidden in the report. How do I achieve this?
我尝试在“Hidden”表达式中使用函数First()和Last(),但它不起作用,因为这个标志可能并不总是ds_2中的第一个/最后一个值