Unanswered: Looping over 1 row (and 25 columns) in 'Detail' section of Report
So basically i have a report named 'invoice' in which i have a text box which should list all the 'parts used' to fix a tool. so, i have the text box in the 'Detail' section of the report so that it can repeat itself as long as there is more data in the table. however, it is supposed to read all its data off 1 row.
so, in my table, i have 'part1', 'part2' and so on till 'part25'. so, the text box must display all the information from each of these columns (except for when they are empty).
to sum it up, the 'Detail' section of the report should loop over 1 row (but about 25 colums for the 25 parts) instead of looping over the rows.
Is there any way to do this? or any other better way of doing all this. Please help me out!!!!!!!!!! I would really really appreciate it.