Tuesday, April 30, 2013

Crystal Reports : Counting Distinct Records

When creating a "Summary", using the Count function may not be desirable. It is often the case that a report must only return the number of unique contact records, as other tables (i.e. History) may contain multiple rows for each customer.
Select Insert | Summary.
Select the fieldname you wish to summarize.
Make sure to select Distinct Count as the Summary Operation.

4 comments:

professional essay writing services uk said...

There was a time when your message reached to sender after several days and now the time when you can see and talk your beloved at the same time is great miracle of education. Start learning for doing something different.

professional essay writing services uk said...

There was a time when your message reached to sender after several days and now the time when you can see and talk your beloved at the same time is great miracle of education. Start learning for doing something different.

Frip Games said...

This is really a nice and informative. Thanks for sharing it,

chenlina said...

chenlina20170228
coach handbags
ralph lauren uk
ralph lauren polo
ralph lauren
cheap ray ban sunglasses
nike air max
mont blanc mountain pen
gucci uk
pandora charms
chanel outlet