FieldCount causes report to repeat

[cesaralves]

In my report i want to display a variable number of images in one of the sections. But in the case there are no images to display, i want to suppress this section, so i added a formula to the suppress field of the section, something like:

Count({images.ID}) = 0

but this cases all report to repeat times the number of images in the images table.

Cesar

 

[HowardHammerman]

The expression you are using will ceate a grand total count.
I assume that "images" is the name of your table and "id" is the name of your field.

You are suppressing a section. I bet it is not a report header or a report footer section. The expression you are using would be fine for either one of these. However if you are putting your images in any other section (detail for example) it will never suppress (assuming you have one or more images.)

Use a group count appropriate to the section that you are putting your images in. If you are putting the images in the detail section, you will have to create different logic such as:

if {table.keyfield} <> previous{table.keyfield} and
isnull({images.id})

Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269