July 29, 2008 at 10:07 am
Hello
I have a report which is split into groups and what I am trying yo do is to count the number of rows in each group at the group footer.
Does anybody know how I can do this? Books online is just not all that helpful!!
July 29, 2008 at 10:14 am
You want to use the CountRows function. If my report is Employees By Department and my group is named department then in the group footer I would use CountRows(Department) where Department is the name of the group (defines the scope).
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 29, 2008 at 10:25 am
It still doesnt work for me, where will type this expression in the group footer?
July 29, 2008 at 10:38 am
Attached is a report that uses ADventureWorks and shows how to use the CountRows function. You will need to unzip it and then you can open it in BIDS.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 30, 2008 at 8:45 am
It still doesn't work, even when i have used the correct expression, any other idea's?
July 30, 2008 at 9:43 am
Hi B-Boy
Jack is correct, he has given you the correct expression to use and I suspect with his experience that he has given you a fully working report based on AdventureWorks.
The most popular problem here is that you have the scope wrong within the expression.
Can you post a copy of your expression.
Can you post a jpeg of your table group names.
Regards,
Nigel West
UK
July 30, 2008 at 10:12 am
This is the expression I used: ="Orders Cancelled: " + CountRows("CancelledBy").ToString
I have also attached a screen shot of the table in BIDS.
July 30, 2008 at 10:35 am
OK, so I suspect that it is the expression, in particular the part that reads "CancelledBy" which identifies the scope of the function. This should represent the group name and I imagine this is wrong.
I attached a document to help you track down the group name, because the screen shot you sent just gives me the outline of the table but not group names.
Good luck,
Nigel West
UK
July 30, 2008 at 11:01 am
Thanks Guys
Finally got to work, my group name within the expression wasn't the same when I checked the edit group section.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply