Conditionall suppress detail

[tfloyd]

I would liked to suppress the group header and detail based on the value (>0) for the last record of a group.

Report design

GH1 - ProductID
Detail - Date, End_balance
GF1

Travis Floyd
Summit Industrial Products

 

[lbass]

I'm a little unclear on what you would like to achieve, but...

If by "last record of a group" you mean the most recent record, then go to report->edit selection formula->group and enter:

{table.date} = maximum({table.date},{table.yourgroupfield})

This will return only the most recent record for each group.

If you want to suppress the group header and the detail section if the most recent record is > 0 (or do you mean you only want to suppress when it equals a certain value > 0?) then go to format section->group header->suppress and enter:

if {table.date} = maximum({table.date},{table.yourgroupfield}) then {table.endingbal} > 0

Add this formula to the details section->suppress->X+2 area also.

This should suppress the group header and details section if the most recent record shows an ending balance > 0.

-LB

 

[synapsevampire]

A record itself does not equate to >0, a field value within the record might.

When posting, please try to supply meaningful information, such as fields used, example data and expected output.

What you appear to want is if the last row of a group has some column which is > 0, then don't return that row.

A generic answer is to use the record selection formula->group with something like:

maximum({Orders.Order Amount}, {Orders.Order Date}) = 0

-k