Editing Reports Using the Wizard

The wizard takes you through all report details to allow you to modify any of them, including adding new objects.

To edit a new report using the wizard

1. On the Menu toolbar, access the appropriate reporting menu option:

To create a published report, click Manage > Publish Reports.

To create a personal report, click View > Reports > My Reports.

2. Navigate to the report that you want to edit and select it.

3. Click Edit Report to modify the report data.

4. Modify the report details.

a. Select Objects. Select data objects to include in the report using the arrow keys and click Next.

Note:OneData performs a join on the matching column names when there is more than one object in the report.

b. Select Columns. Select the columns from each object using the left and right arrow keys. Use the up and down arrow keys to adjust the order in which columns display on the report. Click Next.

c. Set Sort Order. Specify which columns to use when sorting the report data using the left and right arrows and the sorting priority using the up and down arrows. Click Enable Grouping in Report to create groups on common values. Click Next.

d. Select captions for columns. Specify the column name to display in the report and click Next.

e. Set Filter for Report. Display only a subset of data on the report by creating a filter. Use the expression builder tools to create the SQL query. Click Prompted Report to require user input before generating the report. Click Next.

f. Save Report Definition. Complete the report definition and click Finish.

Use the following table as a guide for completing the report definition:

Report Definition Field	Field Description
Report Name	The report name that displays as the report title and in the Published Reports screen.
Description	The description that identifies properties of the report.
Include Logically Deleted Records	Selected, includes logically deleted records in the result set.
Page Header	The header that displays at the top of the report pages.
Page Footer	The text that displays at the bottom of the report pages.
Display Related Column Description	Indicates whether to display column descriptions (if entered at the object-level) in the report.
Encoding	Indicates the type of encoding to use for the report.
Disable HTML Evaluation	Indicates whether OneData displays or applies HTML tags: Selected. Displays HTML tags (<i>Product Name</i>). Not selected. Applies HTML (Product Name).
Execution Mode	Select the option to run, save, or save and run the report.

5. To export the data to Excel, click Export to Excel.

If the number of records exceeds the maximum value defined in the property onedata.job.attachmentmaxrecordcount, OneData provides a warning and the option to continue or stop the export.