Since all of the data is on the same record, and you want to display each test result in a separate row, you will need to use a formula.

Your formula will involve checking each field to see if there is a value, and then building a string as you go.

You will use chr(10) to specify that the next test should appear on a new line.

ie:

local stringvar temp = "";



if table.test1 then

   temp := temp + {patient ID} + (tab character) + "test1" + (tab character) + totext(table.test1)



if table.test2 then

   temp := temp + chr(10) + {patient ID} + (tab character) + "test2" + ...



...



temp;

This formula will take each record and output a formatted version. You can then manually place your headings to line up with each "column". You may consider using more than one tab character between each column.

Edited by Keikoku - 16 May 2011 at 3:13am