1. Add a blank Group Footer and increase the height of it as per your requirements.
How to find the rowcount of the dataset in a report
CountRows("Dataset1"). is my solution
3. Adding count for a specific group
Scenario :
I have a table widget in reporting services where I group rows on a given id.
For each group, I display the number of rows per group, using countrows().
How can I display the average number of rows per group at the end of my report ?
What I am missing is : how to count the number of groups?
Solution
= Count(Fields!ID.Value) / CountDistinct(Fields!ID.Value)
No comments:
Post a Comment