Groups

[DirtyB]

I have a report that lists the group names, and then the records that belong to that group. Then the next group name, and the records that belong to that group. What is a best way to count the records that belong to a certain group.

ex.

JON
1
2
3
4
Mike

1
2

Paul

1
2
3
4


It needs to read


JON: 4
1
2
3
4
Mike: 2

1
2

Paul: 4

1
2
3
4

 

[MalcolmW]

Insert a summary field (summary type count or distinct count) - this gets place by default by CR in the group footer. Just drag it into the group header. Malcolm Wynden
Authorized Crystal Engineer

http://www.wynden.net

malcolm@wynden.net

 

[DirtyB]

Thanks Malcolm I appreciate it. I still have a problem though. The report has several parameters. If there are potentially 100 records to each group, based on the parameters, maybe only ten of those records should show in the report. The summary field is counting everything in the database for each person, not the records that are being shown. Does that make sense?

 

[Dond12]

What are you counting? If you insert a summary field in the group header, you are asked what to count. You need to specifiy something for SCR to count -- e.g., some field that appears in each record (it might be an identification number that is unique to each person). But if you have SCR count the records in each group, it will count precisely what you tell it to count.

 

[kenhamady]

If you are doing group selection or TopN with no others, your totals will show all groups even those that don't print. Running totals, however, will total correctly in both of these situations.

If you aren't using these techniques, then you have to explain why you have data 'in the report' that isn't printing. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.