I have a report that lists a fixed set of transaction detail fields on one line, and then on a second line reports any descriptive text comment that was attached to the entry. the problem is - the second text line is not required and therefore does not appear with every record.
Here's an example:
TR NUM TR DATE ENT DATE JV NUMBER SRC PROJECT NUMBER BEG BALANCE DEBIT CREDIT END BALANCE
ACCT NUMBER: 1-10-000-0000-1007 Cash - Operating -4225384.64
70010 03/01/07 03/02/07 SJV-101 AR 75339.51
70059 03/01/07 03/08/07 RA -8203829.07
ACCRUAL TRANSACTION FOR THIS REVERSAL IS: 69906
70081 03/02/07 03/09/07 SJV-101 AR 711203.59
70091 03/09/07 03/16/07 SJV-101 AR 696633.11
70093 03/08/07 03/20/07 GL 36753.18
WIRE PAYMENT TO FUNLOC 130218
70102 03/19/07 03/22/07 SJV-WIRE GL 192478.65
WIRE PAYMENT TO FUNLOC 130915
I don't know if this posts clearly enough to see what I'm describing....
In any case, line 70010 has no text descrip line, but line 70059 does.
I've tried dealing with this with both an append and footer template. both don't get me there. both assign a description to a line that does not have one.
The result I'd like would be line this - where there is no description for line 70010.
GL ACCT ACCT NAME TRANS # TRAN DATE ENTRY DATE JV NUMBER SOURCE DEBIT CREDIT DESCRIP
1-10-000-0000-1007 Cash - Operating 70010 03/01/07 03/02/07 SJV-101 AR 75,339.51
1-10-000-0000-1007 Cash - Operating 70059 03/01/07 03/08/07 RA (8,203,829.07) ACCRUAL TRANSACTION FOR THIS REVERSAL IS: 69906
thanks for any help you can give!