Database Reference
In-Depth Information
Figure 2-64.
The third page of the Report Wizard
You can drag and drop elements in the MDX query designer from the treeview on the left side of this dialog
window onto the report display section in the center of the dialog window. MDX code is written behind the
scenes every time you add or subtract an item from the report display section. When you click the OK button and
return to the previous dialog window, the MDX code is displayed.
After you create a report query, the wizard moves you through three pages that define the style of the report.
In Figure
2-65
, we configure the wizard to create a tabular-stepped report with data grouped by events.
You are able to choose between tabular or matrix formats. The tabular format looks very similar to an
Excel spreadsheet, and the matrix format looks similar to an Excel pivot table. We cover more on this subject in
Chapters 16 and 17.
Depending on your choice, you are asked to further clarify how you want the data presented in your report.
Because we chose a tabular format, the next screen of the wizard (as shown in Figure
2-65
) allows us to display
data in groups, and the next screen allows a choice between a data-stepped or blocked format.
