Hello everyone -

I am building a report which displays an item number. Each item number will contain 1 to n location records. I want to display the item number and top two location records if the first location record equals a certain value and more then one location record is returned.

Currently, my report is grouped by item number and displays the top two location records. The top two records are displayed using a running total count which is reset for each item number(group). In the section expert under suppress I input a formula {Top2} > 2.

But I can not figure out how to suppress an entire group if the first returned location record does not meet certain criteria or if only one location record is returned.

Any suggestions or help would be appreciated!

Thanks for your response! I have the report displaying the first two location records based on a desired criteria. At this point, I am leaving item numbers with one location record but I am sure the code below could be easily modified for that desired output. This is what I did:

1. Create this formula and put in the group header section.

@HideHeader
whileprintingrecords;
numbervar x := 1;
numbervar y := 0;

2. Create this formula and put it in the detail and footer section

@HideDetailFooter
whileprintingrecords;
numbervar x;
numbervar y;

if (x=1 and myTable.myField <> "MyCriteria") then
y := y + 1 else y;
x := x + 1;
y

3. I created a running total on the field I am grouping by. I am getting the count for each record which resets on change of group. I called this Top2.

4. In Details > Section Expert > Suppress (do not check) > Formula > Add

if {@HideDetailFooter} = 0 then
{#Top2} > 2 else
{@HideDetailFooter} = 1;