官术网_书友最值得收藏!

Creating sections

Users want to see the details of Orders. They would like to see the Order number and the details (product name, promotion, quantity, and unit sell price).

Getting ready

Create a simple list report with Sales order | Order number, Product | Product name, Sales fact | Quantity, and Sales fact | Unit sale price as columns.

How to do it...

  1. Click on the Order number column. Hit the section button on the toolbar.
    How to do it...
  2. You will see that Report Studio automatically creates a header for Order number and moves it out of the list.
  3. Notice that the Order number field is now grouped.
    How to do it...
  4. Run the report to test it.

How it works...

The information we are trying to show in this report can also be achieved by normally grouping on order number. That will bring all the related records together. We can also set appropriate group/level span and sorting for better appearance.

However, in this recipe, I want to introduce another feature of Report Studio called Section.

When you create a section on a column, Report Studio automatically does the following:

  1. It creates a new list object and moves the current report object (in our case, the existing list) inside that. This is report nesting. Both the inner and outer objects use the same query.
  2. It creates grouping on the column selected for section, which is Order Number here. Creates a Group Header for that item and removes it from the inner list.
  3. It formats to outer list appropriately. For example, hiding the column title.

There's more...

Some of the advantages of creating sections are as follows:

  1. As mentioned above, Report Studio does a lot of the work for you and gives a report that looks more presentable. It makes the information more readable by clearly differentiating different entities, in our case, different orders.
  2. As the outer and inner queries are same, there is no maintenance overhead.

See also

If you create a section for a crosstab or chart report, you need to explicitly define the master-detail relationship. Chapter 2 defines the master-detail relationship.

主站蜘蛛池模板: 唐山市| 威宁| 鄢陵县| 土默特左旗| 黔南| 佛冈县| 贡山| 建阳市| 莆田市| 永新县| 元谋县| 彩票| 都江堰市| 汉沽区| 正定县| 永福县| 弋阳县| 三河市| 昌江| 咸阳市| 长治县| 白山市| 合川市| 河津市| 建瓯市| 黎平县| 武平县| 余江县| 崇左市| 方城县| 舒兰市| 金寨县| 集安市| 武强县| 福海县| 丹棱县| 宁城县| 永寿县| 都江堰市| 化州市| 杭州市|