how to count Group value

Question

how to count Group value

meghna.bhargav

SSCrazy

Points: 2634
More actions
July 12, 2009 at 10:27 am

#208115

i have the Group in RDL on location and it has Client name in the detail section.Now the scenario is ..it prints 3 clients for location 1 on the first page and 2 clients on location 1 on the second page.
I wnt to count the the GRP Location which appears on 2 pages fo rthe same value.so the count should be 2.
In short , group count i require, can any one tell how to do that?
Regards

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

If I understand you correctly, I don't think it is possible to do what you want. My understanding is that you want to show a count of the items in a group that show on a page. So if page 1 has 2 items for group 1 then you want to show 2 there and if group 1 has 1 item on page 2 you want to show 1 in the group on page 2, is this correct?

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

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 2

No , if page 1 has 2 items for group 1 then want to show 2 there and if group 1 has 1 item on page 2

want to show 2 in the group on page 2 because the total times when the same group repeated is 2.

i want the way to count the times the group is repeated?

Ny idea of how to implement that ?

Thanks

becklery Hall of Fame Points: 3315 More actions · Answer 3

Hi, meghna.bhargav.

You can use RAQ Report. I have easily made a lot of group reports with it.

It is a free reporting tool, you can get it at http://www.raqsoft.com/[/url].

RAQ Report: Web-based Excel-like Java reporting tool[/url]

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

I've never tried to get a count of the pages a group has repeated before, so I don't know if there is a way to do it. I can't think of one off the top of my head. If I have time later I may give it a shot.

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

cfloyd Valued Member Points: 60 More actions · Answer 5

Not sure if I am sure what you are asking, but try this and see if it does what you want.

Add this to your group as an expression and it will give you this result:

=Fields!CityName.Value + " (" + CountRows() .ToString + ")"

-- Result --

Las Vegas (2)