CODEWITHSUNDEEP
crystal-reports-xi
Jake
Jake

Reputation: 604

Crystal Reports cross-tab suppress row formula

I have a cross-tab that is presenting information as follows:

+----------+-------+
| UserName | Total |
+----------+-------+
| User1    | $5    |
| User2    | $10   |
| User3    | $50   |
| User4    | $15   |
| User5    | $20   |
| User6    | $0    |
+----------+-------+

I cannot figure out how to suppress rows based on a formula. I want to limit records to User1, User2, and User3 - I have tried the following suppression formula:

IF {Command.UserName} IN ['User1', 'User2', 'User3'] THEN FALSE

Unfortunately this has not worked. I am at a loss here.

Upvotes: 0

Views: 1416

Answers (2)

Coty Nolen
Coty Nolen

Reputation: 1

You can use a formula for your summarized field that returns an empty string for any records you want to hide, this will cause the cross tab to ignore the record entirely without drawing a row.

IF {TableName.UserName} in ["User1","User2","User3"] THEN {TableName.Total} ELSE ""

I'm already in a sub-report by necessity, so I needed to come up with another solution. I hope this helps someone.

Upvotes: 0

jambonick
jambonick

Reputation: 716

If you have tried to use the suppression formula in Format Field options menu you will probably will not achieve the desired goal because it does not work as a filter in your rows. You should apply your filter on the UserName field before you use it in your cross-tab. You can use the Record Selection Formula for this and put your condition in there e.g.

IF {Command.UserName} IN ['User1', 'User2', 'User3']

(I am not sure if IN operator will work exactly as you want it but in any case you can figure out your condition)

Upvotes: 1

Related Questions