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!

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

Filter sum in crosstab

Status
Not open for further replies.
ermutigen

ermutigen

MIS
Apr 6, 2006
7
US
How can filter the sum field in a crosstab report? I want to the sum to only show values that are < 40.

Thanks,
e
 
Sort by date Sort by votes
Depending on your Crystal version, you may be able to do a Crosstab on a formula field,
Code: 
if {value} < 40 then {value}
else 0

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
550
hilfy
hilfy
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
256
jchewsmith
jchewsmith
Lucy_G
  • Locked
  • Question
Highlight whole row in a crosstab based on non crosstab info
Replies
2
Views
168
Lucy_G
Lucy_G
john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
320
john432
john432
inkbird01
  • Locked
  • Question
Filters &gt; Record Selection for dates between
Replies
4
Views
286
pmax9999
pmax9999

Part and Inventory Search

Sponsor

Back
Top