Report Builder result row limit to continue in second column before continuing on next page

20 Views Asked by At

I have a 3 columned table requested report that has about 200 results pending the parameter limits selected(based on date range). I'd like to limit the rows per page to 30 and have the table/column continue in a second page column to the right before moving to the next page resulting in 3 or 4 pages printed instead of having everything in one table/column with 7 or more pages printed.

[Result Example]

enter image description here

(row 1)1Aa1  3Aa3   5Aa5 
(row 2)2Aa2  4Aa4   5Aa5
--new page--
(row 1)6Aa6  8Aa8   9Aa9

[Result Example] enter image description here

(row 1)1Bb1  3Bb3
(row 2)2Bb2  4Bb4
--new page--
(row1)5Bb5  7Bb7

I'm using Report Builder 3.0 with a shared SQL database. Policy for my department includes restriction for creating temporary tables or stored procedures.

--create an additional column with expression-- 
    =RowNumber(Nothing)
--1st table
    =IIF(RowNumber("DSRoster") = CountRows("DSRoster") AND RowNumber("DSRoster") mod 2 = 0, false, true)
--2nd table
    =IIF(RowNumber("DSRoster") = CountRows("DSRoster") AND RowNumber("DSRoster") mod 2 = 1, false, true)

--adding columns to the page properties with and without the above code--

--add in SQL query to SELECT--  ,row_number() OVER (ORDER BY location_5) AS RowNumber
--add in SQL query after conditions-- ORDER BY location_5
--add to both tables--
    =CStr(CInt(Fields!RowNumber.Value) mod 2)
0

There are 0 best solutions below