Supress based on # of records

[Former Member]

I have a report listing the number of times a city is used (grouped by city). In my report, I have a counter formula and at the beginning of each group, there is a total count for each City.

I only want to view the Cities that have been used less than 5 times. Is there a way to use the Section Expert or something to supress all cities that were used more than 5 times?

[Former Member · Accepted solution]

Use the counter in the section expert suppress condition like

if counter>5 then true

else

false

this supresses the records that shows more that five

Regards,

Raghavendra

[Former Member · Accepted solution]

Hi,

You can try "Select Expert" -Record,

choose the field 'Counter' is less than '5', or directly type Counter < 5.

Then the report will only show data with counter less than 5.

Good luck.

~Michelle

[Former Member]

Write below Formula in Report >> Section Expertu2026

Count({TableName.City}, {TableName.City}) > 5

For the sections Group Header (which is based on City), Details and Group Footer To suppress it Conditionally.

Regards,

Alpana

[Former Member]

My "counter" is based on the formula:

Whileprintingrecords;

numbervar x:x+1

and I reset the counter on every change of groups.

The problem is in the Record Select Group, it does not let me select Counter as a means to select records because the Counter Formula must be evaluated later.

Should I just find a different way to count the records?

[Former Member]

Use section expert instead of select expert so that you can supress the unwanted records.

Use the counter in the section expert suppress condition like

if counter>5 then true

else

false

this supresses the records that shows more that five

Regards,

Raghavendra