How to get the number of rows in a Tablix

[Wang Jianwei]

Hi Syncfusion team,

My report has a table which is showing some data from a dataset.

And I have another text box which I want to show the number of total rows in that table.

What expression should I put for the text box to retrieve the number of rows?

Thank you.

 

Regards,

 

Jianwei

[Anandakumar S]

Hi Jianwei,

Thanks for using Syncfusion Products.

You can display the number rows using RowNumbers / CountRows in Expression. We have prepared a report sample based on this and that can be download from the following location.

Report sample: http://www.syncfusion.com/downloads/support/directtrac/general/RowCounts-143051483.zip

Please let us know if you have any questions.

Regards,

Anandakumar S

[Wang Jianwei]

Hi Anandakumar,

Very helpful answer, Thank you.

I am trying to extend your solution to hide/show the table based on the number of rows in that table.

If there is no rows in the table, I would like to hide its row headers.

So I select the whole table, go to Tablix Properties ->Visibility -> Show or hide based on an expression, and input "=IIf(CountRows()=0, False, True)".

However, the table would be hidden even if it has data in it, so clearly something is wrong with this approach.

Do you have any suggestion of what is the correct way to achieve it?

Cheers.

Jianwei

[Soundara Rajan S]

Hi Jianwei,

 

Thanks for your patience.

 

We have prepared sample rdl file based on your requirement. Please find the rdl from following location :

 

Rdl : RowCounts.zip

 

We have achieved your scenario  as shown in below Expression,

 

=IIf(RowNumber("GetProducts")=0, true, false)

 

Please let us know, if you have any queries.

 

Regards,

Soundara Rajan S