Hello Guys,
I am trying to count the number of rows that are displayed on my matrix report and display it in a textbox. What I use for the table reports doesn't really work:
="Number of records displayed: " + cstr(RowNumber("Data_Set_Name"))
This will return a number of rows returned by this data set. However, the count of rows that are actually being displayed in the matrix is very different. If anyone dealt with this before please let me know how to solve it. Thank you very much!
Try =CountRows(Fields!FieldName.Value) or =CountRows("DataSetName").
|||I actually brought in another field, and did CountDistinct on it - now it works like a charm. Thank you so much for pointing me in the right direction.
No comments:
Post a Comment