Crystal Reports Cross Tab

[beth4530]

Is it possible to have my crosstab only count the records that are not suppressed?
I am displaying records that have a group count great than 1 and I'm suppressing those that are less than 1.
My crosstab is counting all the records.

 

[Madawc]

Depending on your version of Crystal, you should be able to create a formula field and use it in your crosstab in place of the item. Something like

if @NotSuppressed then 1
else 0

It helps to give your Crystal version - 8, 8.5, 9, 10, 11, 2008 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[beth4530]

Thank you- I was able to get it to work!