I have a SSRS report to show values from a stored procedure in SQL Server Business Intelligence Studio. The stored procedure will return 120 rows, each row will be displayed as a table format in my report.
So now I have 120 pages, each page having one table equivalent to a row in the stored procedure. I want 4 tables on every single page, so that there should be 30 pages in the SSRS report, with each page having 4 tables that is 4 rows from the stored procedure.
I have added grouping and page breaks but it did not help. Can you please help me.?
march april
value1 100 200
value2 200 300
march april
value1 100 200
value2 200 300
march april
value1 100 200
value2 200 300
march april
value1 100 200
value2 200 300
This is what I am getting now
actually I want like this
march april march april
value1 100 200 value1 100 200
value2 200 300 value2 200 300
march april march april
value1 100 200 value1 100 200
value2 200 300 value2 200 300
In each page.
Hope You understand what I meant, Thanks in advance
What I have tried:
I tried adding page breaks and grouping, it wont help