Need Help with columns on a report

[jpack23]

Hi,
I am using SQL 2005 Reporting services and would like to create a report that may or may not show 2 colums of data depending on how many rows are returned. My goal is to keep the report to one page so if 40 rows of data is returned and the page length can only show 30 rows I want the next 10 rows to appear in another column just to the right on the same page. Each row returned will have 2 fields. I am currently using a table in the report to display the rows and it looks great, but if there is too many rows the report create a new page. I hope I am explaining this right. I would appreciate any help. Thank you

Example

Current report
Report
FieldOne FieldTwo

row 1 data row 1 data
row 2 data row 2 data
row 3 data row 3 data

..this looks great but can span multiple pages

desired report
Report
Field 1 FieldTwo FieldOne FieldTwo

row 1 data row 2 data row 31 data row 31 data
row 2 data row 2 data row 32 data row 32 data
.
.
row 30 data row 30 data

thank you
j

 

[RiverGuy]

Here you go:

http://msdn.microsoft.com/en-us/library/ms159107(SQL.90).aspx