Displaying count for duplicate records 1

[maddyyikes]

Could you please let me know of a way to display the no. of occurences of a duplicate records without actually counting it every single time.for e.g.,

Record Count

Desktop s/w 1
Desktop s/w 1
Desktop s/w 1

I would like to display the following output:

Record Count
Desktop s/w 3

 

[synapsevampire]

For summary operations such as this, select Insert->Group and select the Record field.

Now place the Record field into the details and right click it and select Insert->Summary->Count

Now delete the Record field in the Details section, right click the Details section and select Suppress.

Now select Database->Perform Grouping on Server

You should get the desired output and pass the SQL to the database correctly for optimized performance.

Keep in mind that this is Crystal version and database dependent, neither of which you shared, but it should work for you.

-k