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?
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.
Please let us know if you have any questions.
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?
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.
Soundara Rajan S