Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports Cross Tab

Status
Not open for further replies.

beth4530

Technical User
May 5, 2011
44
US
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.


[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top