Printing Related Records

[Radha_(Guest)]

Kathleen,____I tried to print the lines in accordance with the example you had pointed out (available in this site). It works. But, I have another challenge.____The steps taken are as follows:__Scan the database__Use the scanned records to build the line.____At the same time, check on the record number and Count the records which gets re-set when the index changes.____I try and print the completed line (when the index changes) through a footer line (for the index).____The formuale I use:____Test1=DB1_SCODE DB1_SDES__Test2=Test2 " " Test1____This is correct for the first record. It prints perfectly. The problem here is that it does not get initialized when the index changes and get the new value.____Test2 gets printed on the footer line. It works for the first record. Then when the index changes, I need to initialise the Test2 a blank so that it could have the new values.____But, when I do the following formulae which is what given in the example as per the documentation:____Test2=IIF(COUNT=1,DB1_SCOD DB1_SDES,Test2 " " Test1)____It prints the final line as follows:____FB (This is the first record value), NT (second record value) NT (Second Record Value) NT (second Record Value) LL (third record value) LL (third Record Value) UU (fourth Record Value) UU Fourth Record Value) etc....____Ideally, I would have liked to see the following:____FB (This is the first record value), NT (second record value) NT (Second Record Value) LL (third record value) UU (fourth Record Value) etc....____This has been a real pain for me as I am not sure how I cold get related records printed on the same line.____I would appreciate if you could let me know how I could achieve my goal.____