How do i go about this graph

[SkiNLaB]

I have a shopper table, and an orders table.

so when they join they create lots of duplicate shopper records in the result set (cuz they multiply with each order > 1)

and i would like a cross tab graph that plots out ShopperType1 vs ShopperType2 obviously this plots false numbers because it is counting duplicate shoppers (because of the join to the order table)

how do i get around this?

[brucevde]

Use Distinct Count instead of Count.

[SkiNLaB]

that would work if i was counting shopperID's

but im graphing shopperType1 (business, consumer, trade) vs shoppertype2(prospect, customer)

so if i did a distinct count summary i would just get 1 for each type....

can i get a quick lowdown on how 2 chuck in a subreport into a report so that it has its own datasource so i can just chuck in this graph pulling JUST from the shopper table, while everything else pulls from the shopper INNER JOIN order table ........

thanks!