Click here to Skip to main content
15,891,777 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
Posted
Comments
Richard Deeming 29-Jul-16 10:49am    
Sounds like you want multiple columns in your report:
How to: Create a Newsletter-Style Report (Reporting Services)[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900