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

Submitted by: 
Visitors have accessed this post 15658 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.



Thanks you so much

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

thank you so much it worked :)

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

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • 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.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.