Need Design on Formula for a group

[thisisboni]

Hi:

Environ: CR10, SQL Server 2000

This is for a receiveable report

report on receivable by receivable owner and payer

Payer is divided into primary payer, secondory payer etc..
if primary payer = 'XXX' and secondary payer = 'YYY' then report the receivable as one row with recieveable from XXX + receiveable from YYY
else report on each receiveable on a different row.



rcv_table : {objid,pyr_table_objid, rcv_name,rcv_amt, pymts, bal}

pyr_table : {objid,pry_name, priority} // priority is used to distinguish between primary (set as 1), secondary (set as 2) etc...

join rcv_table and pyr_table on pyr_table.objid = rcv_table.pyr_table_objid


so I have group1 as rcv_name


based on the condition mentioned above I think I would need a formula for the next group - but I cannot figure out how do I find out who the secodary payer is when I am at row for primary payer.

Please let me know if more clarification is needed on my end.

Tx !!

 

[thisisboni]

a'rite - so I found a solution - I used a flag (set/reset) and used this value in supression expert to conditionally supress/unsupress !!

Tx eitherway