suppress in multiple records

[ulag]

I need to suppress section if the ruleid exist
ruleid has multiple records (derived from another table, other than real data table)

ruleid
2
7
11
25

any help?

 

[Madawc]

I'm not sure I understand the question. Also it helps to say which version of Crystal, since extra features keep being added.

If you want the "MAIN" records to be suppressed whenever there is a linked "ruleid" record, that's not hard to do. Make a 'left outer' link from "MAIN" to "ruleid". Then check some field in "ruleid" and suppress the section when it is found. For Crystal 8.5, something like

not isnull {ruleid.accno}

in the suppress formula for the section.

Madawc Williams (East Anglia)

 

[ulag]

Hi Madawc,

Thanks for your reply. I use CR10.
I have suppressing table (separate one)
which has list of ruleid to supress
So the ruleid are in list.

For each section, I assigned as ruleid. If the ruleid is presnt in table, I have to suppress. I mean I have to supress detail section (2, 7,11,25) or (b,g,k, aa)

 

[Madawc]

So create a formula, including your various rules. Use that for suppressing.

If you don't say 'if' in your formula, it becomes a boolian and can be tested for true/false. Useful for multiple choices.

Madawc Williams (East Anglia)