Group Specified on a non recurring field

[ganjass]

Hi All,

CR10

I have altered a report group to reflect the following logic, although it doesn't like it, i'm now getting the e\m : group specified on a non recurring field. Any ideas how i can maintain the grouping with this logic without it failing.

Cheers


if {debt_trans.tran-code} = "SU1000"
AND
(
{debt_trans.tx-date} = MINIMUM({debt_trans.tx-date})
)
AND
left({debt_trans.tx-prostamp},6) startswith ["TC>","FPTR","TRBD1","TRBD2","TRRECK","TRACE"]
then "Received By Trace"

else
if
NOT (left({debt_trans.tx-prostamp},6) startswith ["TC>","FPTR","TRBD1","TRBD2","TRRECK","LTRACE","TRACE","TRRECK"])
then "Received By Collections"

else
{debt_trans.tx-prostamp}

 

[lbass]

You can't use the minimum function in a formula you want to group by. You might want to try breaking this into two steps. Use the following for your group:

if NOT (left({debt_trans.tx-prostamp},6) startswith ["TC>","FPTR","TRBD1","TRBD2","TRRECK","LTRACE","TRACE","TRRECK"]) then
"Received By Collections" else
"Other"

Then create a second formula {@received by trace}:

if {debt_trans.tran-code} = "SU1000" AND
{debt_trans.tx-date} = MINIMUM({debt_trans.tx-date}) AND
left({debt_trans.tx-prostamp},6) startswith ["TC>","FPTR","TRBD1","TRBD2","TRRECK","TRACE"] then
"Received By Trace" else
{debt_trans.tx-prostamp}

Place this in the detail section, and it will identify those records in the "Other" group which meet your other criteria.

Do you really mean you want only to identify those records that match the minimum date for the report as a whole for inclusion in the "Received by Trace" group?

-LB

 

[ganjass]

yes i want to pick up the first SU1000 codes placed on the system. I used {debt_trans.tran-code} = "SU1000" AND
{debt_trans.tx-date} = MINIMUM({debt_trans.tx-date}) as group selection, and kept the group as

left({debt_trans.tx-prostamp},6) startswith ["TC>","FPTR","TRBD1","TRBD2","TRRECK","TRACE"]
then "Received By Trace"

else
if
NOT (left({debt_trans.tx-prostamp},6) startswith ["TC>","FPTR","TRBD1","TRBD2","TRRECK","LTRACE","TRACE","TRRECK"])
then "Received By Collections"

else
{debt_trans.tx-prostamp}

will this bring back the correct data?

Thanks in advance

 

[lbass]

I don't think so, since your original formula was designed to bring the minimum date and the particular tran_code ONLY for the "Received by Trace" group instance--unless you didn't really mean that...

-LB