Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distinct count for inner group

Status
Not open for further replies.

sangisiva

Programmer
Apr 7, 2008
44
IN
Hi All,

I am working with CR10.

I have a report which is grouped by country and then by the field Detail.
Detail field contains A,B,C,D,E,F,G,H,I. So for all the countries in the group , there will be these detail groups.

Is there a way to count the number of records using distinctcount.

I mean if you need to get the count for each (country) group, you can use as

Distinctcount(Id,country)

How do we get it for the inner group(Detail)

Thanks in Advance..

 
I'm not sure if I am understanding you correctly, but it sounds like you have the count in the report footer (that will be for the total of all the groups).

If you want the count for the detail within the group you can insert another summary in the group footer. This will create the summary count for the detail section for that particular group (country).

Is that what you are looking for?

Thank you,
Ang
 
Never Mind. It's done.

Anyway, thanks for your valuable time.








 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top