Loading

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

Submitted by: 
Visitors have accessed this post 11548 times.


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: 

Comments

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

thank you so much it worked :)

Thank you for this, it help me a lot :)

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
To prevent automated spam submissions leave this field empty.