Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Accept the limitations of your mind
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

13
April

How Do I Add More than on Table on a page from the same data in SSRS?

The client had a reporting requirement that needed a table to text wrap across the page, filling the page, with  3 tables of the same dataset object

However when one adds a Tablix to the SSRS canvas it will by default run down the page, unless one changes the number of columns of the report.

The only problem with this approach is that this is a global setting applied to the whole report, and if the report becomes a subreport, it takes the column formatting of the main report.


Solution

The quickest way around this problem was to create a field in the underlying SQL statement to arrange records into values of 1,2 or 3. Then one can sort the tables on that field by:

  1. In SQL Server Reporting services, add the Tablix/Matrix or List object to the canvas

  2. Add the required fields to the object

  3. Right click on the object

  4. Select the Properties option

  5. In the Properties dialog box, select the Filters Tab - Add

  6. Create the following filter:

    Expression : Select the Field from the Database

    Operator: =

    Value: 1

  7. Press the OK button

  8. Select the Tablix/Matrix/List object

  9. Copy and Paste it on the canvas

  10. Repeat steps 3 - 7, changing the Value accordingly

  11. Run the report



If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

37 + 64 =