May 10, 2012 at 4:20 pm
I am asking this question since I am new to working with report builder 3.0 that runs on sql server 2008 R2.
I would like to know how to display the data by grouping levels. There will be no amounts to calculate summary data.
When I supply data to the report builder 3.0 report, the sql (stored procedure) will have the data all ready presorted the way the data is suppose to appear on the report.
The data will look like the following:
highest level group
second highest group
third highest group (which is the lowest level group)
Now there will be detail lines that look like
detail line 1
detail line 2.
Thus can you tell me and/or point me to a reference that will tell me how to generate a report like this in report builder 3.0?
May 10, 2012 at 5:16 pm
Once you launch the Report Builder 3.0 in Report Manager you can create your groups in two ways:
1) Using the Table Wizard or Matrix Wizard under the Insert Tab your groups will automatically be built for you.
2) Or in Design View creating a report manually, you can add groups on rows or columns at the bottom of the design area. Be sure that View/Grouping is checked so that the grouping area is visible. Once you start creating your report by adding a table or matrix to the design area with at least one field, you will see a details group show up at the bottom. To add your groups, right click on the details group and you can continue from there.
May 11, 2012 at 7:23 am
Thank you very much!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply