Creating a banded report

A banded object is a kind of component that can present grouped data and detailed data, and is composed of several banded panels with which you can easily organize data fields and other elements.

To create a banded report, follow the steps below:

  1. Take steps 1 and 2 in Creating a report tab.
  2. Select Banded as the layout and click OK to display the Banded Wizard.
  3. In the Data screen, select the business/report cube in the current catalog, on which the banded object will be built.
  4. In the Display screen, add the required fields from the Resources box to be displayed in the banded object. Modify the display name of any added field if necessary.
  5. In the Group screen, add the dimension objects as the grouping criteria, then specify the sorting direction of each group in the Sort column.
  6. To add summaries, go to the Summary screen. Select the group to which the summary will be applied, then add a measure object as the summary field.
  7. In the Query Filter screen, specify the filter you want to apply to the business/report cube.
  8. In the Style screen, apply a style to the banded object.
  9. Click Finish to create the report.

See also Banded Wizard for details about options in the wizard.

Note: If there is only one cube in the current catalog, this cube will be used to create the report by default, and the Data screen will be hidden from the wizard. This is the same case when there is only one style available to be applied to the report.