on 09-19-2008 10:03 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.