Skip to main content

Suppress Row if Value is Zero (0) using RDLC Report


Do have a report and want to hide some rows based on the value of a certain column in your RDLC report? This can be done easily using the Row Visibility of your Tablix control.

Take note that you can suppress row based on any value that you want. For the sake of this tutorial we will assume that the value of the column is zero and you want to suppress the whole row.

Follow the steps below to suppress the row.

Open your RDLC report.

Right click on the row and click Row Visibility

Select Show or hide based on an expression.

Click fx button.

Type the express on the text box labeled "Set expression: Hidden".

Note: Just change the field name based on your report.

Then click OK.

Tags

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Submitted byAnonymous (not verified)on Fri, 03/22/2013 - 19:49

Well..Thanks for sharing this concept with the above screenshots..But I can't get the output

Submitted byGofran (not verified)on Thu, 04/07/2016 - 16:53

Thanks you so much

Add new comment

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.