Drag and drop reporting provides an alternative method for creating reports. You use the action pane to design the report structures and contents. The resulting report is based on EvDRE, so after you create the report you can modify it using the drag and drop reporting interface or the EvDRE control panel.
Note
We recommend that you use EvDRE Builder to use more advanced features, such as the following:
Options and Format ranges
Advanced sorting options
Expand by sheet function
Multiple EvDRE tables per sheet
By default, drag and drop reporting does not support these features.
You can use the following screen elements to design your report:
Screen element |
Description |
---|---|
Start Designing |
Select this screen element to choose the desired dimensions, members, and other options for the columns and rows. |
Dimensions list in Design Options action pane |
Drag any available dimension name to either the column or row area. The system nests the dimension if one already exists on the column or row. |
Include description |
Select this element to include the dimension description in the grid. |
Edit MemberSets |
Choose the dimension for which you want to define members, then select options from the following list:
|
Set Options |
Allows you to apply special formatting options to this data grid. For more information, see one of the following: For the Microsoft version, see EvDRE Options. For the SAP NetWeaver version, see EvDRE Options |
To create a report using drag and drop, follow these steps:
Select Reporting & Analysis from the Getting Started action pane in Interface for Excel.
Select Build a report using drag & drop.
Drag the Data Grid object to a cell in the top-left corner of an EvDRE data grid, then use the screen elements listed above to define the report.
Click the check box until you return to the Report State action pane, then select Save to My Reports folder.
To remove a dimension, choose Edit report using drag and drop - Start designing in the action pane. Then, select the dimension cell and drag it out of the key range.