Using iReports, is there a way to display the data where it's going back and forth and pulling the data from one SQL statement?
Where an SQL query returned the following records
a0
a1
a2
a3
a4
a5
The report would be filled as follows ...
a0 a1
a2 a3
a4 a5
Normally I wouldn't have a problem doing a table, but I have to replicate someone's "application."
Yes, iReports allows you to fill your report so that the data is presented horizontally as you require in your question.
You can also specify how many columns you present in your report.
In the Report Inspector, right click on the report and select Properties
In the Properties Dialog,