Putting multiple records on the same line

[LeeLB]

Hello all,
I'm creating a report to export into a text file and am trying to put different bank account info on the same line of a specific check. when i run the report it creates the whole detail section over again for each Linetype and Sequencenumber (see Below). Some employees have one account, others have up to 4. I have many other detail lines that contain other infomation relevant to the employee or the check.
Here is what i have(i have ommitted irrelavant fields)

Table.employee
Employee Number 2525
Employee Name Jane

Table.checkheader
Employee Number 2525
checkdate 05-27-2010
check Number 002542

Table.checkdetail
Employee Number 2525
Checkdate 05-27-2010
Linetype (E, D, and V - I need V which stands for the deposit accout info) - V
SequenceNumber (000,001,002,003, etc...) 000 thur 002
Bankacctnumber - Acct#1, Acct#2, Acct#3
Routingnumber -Rout#1, Rout#2, Rout#3
Amount - 879, 100, 900

Here is what i need on the same line (they will be at fixed points on the line(not all together) with blanks for filler or blanks if no other account or sequence exists)

Bankacct1Routingnumber1AmountBankacct2Routingnumber2Amount Bankacct3Routingnumber3AmountBankacct4Routingnumber4Amount

I tried to use grouping and ideas from other posts but i still can't get them to show.

Any help would be great! Thanks in advance. Lee

 

[lbass]

You could collect these in a variable like this:

whileprintingrecords;
stringvar x;
x := x + {checkdetail.bankaccountnumber}+{checkdetail.routingnumber}+{checkdetail.amount};

Add a reset formula in a group header (group on checknumber):

whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";

Use a display formula in the group footer:
whileprintingrecords;
stringvar x;

Then suppress the detail and group header sections. I don't know how this will export though.

You could add spaced between elements in the accumulation formula and then you would be able to split (using the space as the divider) the long string into component parts in the group footer for spacing purposes.

-LB