Formula to show "Various" if there are more than 10 records 1

[moonpie2]

Hi,

I'm using Crystal 2008 and am trying to pull a field {table.field1} in a sub report (Details section), but if there are more than 10 records, I need it to show "Various" instead of the list of records.

For example, if the report shows:
1
2

Then I need the report to show "1" and "2".
If the report shows:
1
2
3
...
11
12

Then I need the report to show "Various" instead of listing all the numbers.

I've created a Running Total Count for the field and set a formula to say "Various" if count > 10 in the Report Footer, but I can't suppress the fields in the detail section, I can only get the fields beyond #10 to be suppressed...

Any help would be greatly appreciated!

 

[lbass]

Use a formula like this to suppress the detail section:

count({table.field}) > 10

For the formula in the footer, use:
if count({table.field}) > 10 then
"Various"

-LB

 

[moonpie2]

Thanks lbass! That worked like a charm!