Display Report Contents Where Column A Equal B in SSRS
UpwardD
From the image above, I want viewers of my SSRS report to see data where PaymentFound column is equal to 'N' without limiting it in my T-Sql query and without hiding any column in my report.
How do I achieve this in SSRS?
Mahesh
I am assuming you want to hide the rows for which the PaymentFound value is Y.
There are 2 ways to do that,
1) Add filter on dataset so it will filter the values out with PaymentFound= Y
You can add filter as, Dataset->RightClick-> DatasetProperties->Filter->Add-> then
Expression : PaymentFound
Operator: =
Value: 'N'
2) Right click on row set the expression for the visibility as
= IIF(Fields!PaymentFound.Value = "Y",True,False)
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
SSRS No wait display report
- 2
Display the table on click in SSRS report
- 3
SSRS Report/SQL Server: Display distinct column values even if there is no data on particular dates
- 4
Display ssrs report data vertically in columns
- 5
SSRS Report Query - BETWEEN within WHERE clause
- 6
SSRS report with column group is huge and mostly empty
- 7
Column grouping in ssrs report giving wrong results
- 8
SSRS: Subscription column order differs from Report
- 9
SSRS Report Viewer - Report chart fails to display in IE11
- 10
SSRS Report Viewer - Report chart fails to display in IE11
- 11
SSRS display a N/A if a item is NULL, else display it's contents
- 12
Excel: Make column B equal to column A sorted
- 13
Make Column A equal to Column B in height
- 14
SQL - Select where A is equal and B is variant
- 15
MS Excel: Add the contents of the column A to the cell B, if column B is empty
- 16
SSRS display label at base of column chart columns
- 17
SSRS - Display latest value in column group
- 18
How can I compute and display a date range in an SSRS report field?
- 19
How to display SSRS report in asp.net application
- 20
How can I compute and display a date range in an SSRS report field?
- 21
SQL Query to Display All Columns in SSRS Report for Comparison
- 22
SSRS reports display data in different sections of report based on conditions
- 23
Report Builder (Display Time at different time zone) in SSRS
- 24
SSRS Report - Use column for page breaks, but make invisible
- 25
How to add bar chart inside tablix column of SSRS report?
- 26
How to hide a column in SSRS Matrix report in SQL Server
- 27
Select where two column values are not equal
- 28
Get column names where dat is equal to
- 29
Entity framework where column is equal nothing
Comments