Monday, October 24, 2011

Crystal Reports : Counting Unique 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.

8 comments:

discount for Chanel bags said...

This bag was first made in the 1950s. The story goes that Jane Birkin, an English actress, complained about her travel bag when seated next to the Hermes CEO on a flight

Libin Huang said...

20160427libinhermes belt
michael kors handbags
reebok shoes
cheap jordans
michael kors uk outlet
true religion jeans
fitflops sale
true religion jeans
hermes outlet store
celine outlet online
police sunglasses
mulberry outlet
michael kors handbags
ralph lauren outlet
coach factory outlet
coach outlet
cheap ray ban sunglasses
polo ralph lauren
cartier sunglasses
bottega veneta outlet
true religion outlet
tiffany and co
cheap oakley sunglasses
ray-ban sunglasses
oakley sunglasses
ralph lauren outlet
michael kors handbags
tory burch shoes
beats by dre
michael kors outlet online
tory burch outlet online
lululemon outlet online
oakley sunglasses
oakley sunglasses wholesale
true religion jeans

xumeiqing said...

20160530meiqing
bottega veneta outlet
rolex submariner
designer handbags
gucci borse
jordan pas cher
sac longchamp
gucci handbags
kobe 9
oakley sunglasses,oakley sunglass,cheap oakley sunglasses,oakley sunglasses cheap,oakley sunglasses outlet,oakley store,oakley outlet,oakley outlet store,oakley sunglasses sale,oakley sunglasses discount
versace sunglasses
ray ban sunglasses
coach outlet
air max 95
ray ban sunglasses
michael kors outlet
louboutin uk
louis vuitton factory outlet
ugg sale
michael kors outlet clearance
louis vuitton outlet
supra for sale
hollister outlet
birkenstock sandals
fitflops
babyliss pro
under armour shoes
birkenstock sandals
cheap nhl jerseys
ralph lauren outlet
nike huarache trainers
adidas supercolor
coach factory outlet

Zheng junxai5 said...


zhengjx20160623
adidas superstar trainers
oakley sunglasses wholesale
pandora jewelry
lebron james shoes 13
tiffany and co
nike air force 1 white
kd 8
ralph lauren polo
coach factory outlet online
michael kors outlet
coach outlet
air max
fitflop shoes
fitflop shoes
michael kors outlet
retro 11
cheap toms shoes
christian louboutin wedges
marc jacobs outlet
replica rolex watches
michael kors outlet clearance
oakley outlet
oakley sunglasses wholesale
coach factory outlet
cheap jordans
coach outlet store
louis vuitton purses
louis vuitton handbags
polo ralph lauren
air jordan shoes
oakley vault
ralph lauren outlet
louboutin shoes
cheap oakleys
vans outlet
oakley sunglasses
oakley vault
nike air max uk
ray ban sunglasses

Zheng junxai5 said...

zhengjx20160623
jordan retro 8
louis vuitton outlet
gucci outlet online
cheap toms
ralph lauren outlet
basketball shoes
kids lebron shoes
toms shoes
michael kors purses
cheap toms
ray bans
replica watches
nike trainers women
michael kors outlet
gucci belts
true religion jeans
louis vuitton purses
coach outlet store online clearances
gucci handbags
true religion outlet store
jordan 3 retro
michael kors
coach outlet
true religion jeans
true religion outlet
air jordan 8
lebron 13
coach outlet clearance
coach outlet
nike blazers shoes
nike roshe run mens
nike sb dunks
pandora charms
louis vuitton outlet
michael kors outlet
coach outlet
cheap oakley sunglasses
louis vuitton outlet stores
louis vuitton handbags
tods sale

caiyan said...

christian louboutin sale
ugg outlet
cheap nike shoes
coach factory outlet
michael kors watches
nike air max
moncler outlet
pandora charms
kevin durant shoes
ralph lauren outlet
20161018caiyan

Meiqing Xu said...

michael kors outlet
ugg outlet
polo ralph lauren outlet online
armani exchange
michael kors canada
kate spade handbags
polo ralph lauren outlet
louis vuitton
michael kors handbags
pandora charms
20161209caiyan

xumeiqing said...

20170122meiqing
the north face outlet
puma shoes
sac longchamp pas cher
canada goose jackets
burberry outlet canada
coach outlet store
wholesale nike shoes
oakley sunglasses
converse trainers
michael kors outlet clearance