English 中文(简体)
SSRS-基于单独数据集中的标志隐藏矩形
原标题:SSRS - Hide rectangle based on a flag present in separate dataset

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中的第一个/最后一个值

问题回答

暂无回答




相关问题
An error has Occurred During Report proccesing

When I m running the report I m getting that message above. The Report Works fine when I press the "Run Report" Button but I want also to avoid that annoying message that appears when the page loads. ...

Reporting services only displaying the last row

I have built a report pretty basic just a table wiht 45 rows of data. Problem is its only showing one row of data and its the last row. It displays just fine in the dataset and proc. any ...

Show Parameters for Reports In SSRS

I m developing an SSRS in Visual Studio BIDS. In it, I have a link that links to another report (report A). Report A has 4 parameters (dates). When I click on that link, it goes to report A fine, but ...

How to add group, or page field in an existing .rdl report

I have several .rdl reports designed for our client. However, they need new ones, that are relatively similar to the old ones. Differences are in the "group" and "page fields" (these can be changed ...

Report rendering using SSRS in Google Chrome

Hey, In our project, we use SSRS integrated with asp.net forms to render reports. The report looks good in IE. when it comes to google chrome, there re some issues we face such as date picker not ...

热门标签