×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Groups

Groups

(OP)
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

RE: Groups

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

RE: Groups

(OP)
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?

RE: Groups

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.

RE: Groups

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close