Menu
I am using BIDS and SQL Server Reporting Services (SSRS) 2008 R2 to build a report. And I want the each category to show as a separate table/grid.
Important: the columns (CELERY, EGG etc) are dynamic and come from values in a table, so the person building the report cannot hard-code them into the report. So we are using a matrix control at the moment.
What the report looks like now:
How I would like the report to look:
Any ideas?
Thanks, Craig
748
At the bottom of the report builder, you will see two boxes, Row Groups and Column Groups. Select the Column Groups drop down, click "Advanced Mode" and then in Row groups highlight "Details". In Properties under the "Other" section, select "True" for Keep Together. and save.
Right-click the Detail group handle (it is the grey box on the left with three horizontal lines when the table is selected), choose Insert Row -> then Inside Group - Below or just Below (depending on whether you are on the top row of the group). Now put the columns where you want them.
Using data-grid as my data-source for my report using SQL Server Reporting Services. Is this possible? The simple answer is no.
In a tablix data region, click in the table, matrix, or list to display the Grouping pane. Drag dataset fields to the Row Group and Column Group pane to create parent or child groups.
Use a list ontrol and put the matrix inside the list. Use the category as your grouping for the list. Add a textbox just above the matrix to display the category.
156
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
