Suppress Data that Does Not Contain a Specific Criteria 1

[yatesk]

I have this report that is grouped by Case # and it returns all activity for one case, for example:
Case #123
Appearance Date
Courtesy Due Date
Time Payment Plan

Case #456
Trial
Copy of Check
Copy of Complaint

I want to be able to say...all cases that contains "Time Payment Plan" return the requested data with all other activity pertaining to that case...suppress all other cases and its activities that do not meet the criteria. Is this possible?

I hope I did not confuse anyone. Thanks for your help!

 

[buck149]

Why don't you put that in your record selection so that you only have that "Time Payment Plan" in your grouping?

 

[yatesk]

I do understand that, however, if I do that all that will be displayed is Time Payment Plan and the rest of the activity of that citation will be suppressed. I want my report to display all cases that contain Time Payment Plan and its other activity pertaining to that case.

Am I making sense? Please let me know if you are needing more information. Thanks.

 

[synapsevampire]

I guess you mean "ONLY cases that contains "Time Payment Plan", all others should be suppressed.

Create a formula of:

//TPPCnt
if {table.case} = "Time Payment Plan" then
1
else
0

Then in the Report->Selection Expert->Record place:

sum({@TPPCnt}.{table.case}) > 0

-k

 

[synapsevampire]

Sorry,m that should be:

Then in the Report->Selection Expert->GROUP place:

sum({@TPPCnt}.{table.case}) > 0

 

[yatesk]

I tried this formula: sum({@TPPCnt}.{table.case})>0, of course replacing my tables, however, I keep getting an error message that says the "(" is missing. Am I doing something wrong?

 

[lbass]

That should be a comma:

sum({@TPPCnt},{table.case})>0

-LB

 

[yatesk]

That worked! Thank you so much!