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:
- In SQL Server Reporting services, add the Tablix/Matrix or List object to the canvas
- Add the required fields to the object
- Right click on the object
- Select the Properties option
- In the Properties dialog box, select the Filters Tab - Add
- Create the following filter:
Expression : Select the Field from the Database
Operator: =
Value: 1
- Press the OK button
- Select the Tablix/Matrix/List object
- Copy and Paste it on the canvas
- Repeat steps 3 - 7, changing the Value accordingly
- Run the report
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us |