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.
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
Code:
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.