OneData 10.7 | Managing Master Data with webMethods OneData | webMethods OneData User’s Guide | Working with Reports | Creating Reports | Creating a Published or Personal Report Free-Hand
 
Creating a Published or Personal Report Free-Hand
You can create a new report by manually entering the SQL queries. This option is for advanced users who are familiar with SQL and have experience writing queries. Lookups cannot be performed while creating the query. Therefore, before starting this procedure, note the properties about the data that you want to include in the report.
*To create a new report free-hand
1. On the Menu toolbar, access the appropriate reporting menu for the report type:
*To create a published report, click Manage > Publish Reports.
*To create a personal report, click View > Reports > My Reports.
2. Click Add Report to create a new report.
3. Select Use Free Hand and choose New Report or Use Existing Report. Click Next.
*New Report: Create a completely new report.
*Use Existing Report: Create a new report by modifying a similar existing report.
4. If you are using an existing report as a template, select the report from the Existing Report List field. OneData automatically populates an example report name and creates a select all statement in the SQL field.
5. Define the report properties, using the following table as a guide:
Report Definition Field
Field Description
Report Name
The name of the report. The report name displays as the title in the report and in the Published Reports screen.
Description
The description that identifies properties of the report.
Header
The text that displays at the top of report pages.
Footer
The text that displays at the bottom of report pages.
SQL Statement
Specify the objects, columns, sort order, and
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 to the data (Product Name).
Execution Mode
Select the option to run, save, or save and run the report.
Prompted Report
Select Prompted Report to have OneData request user input before generating the report.
6. Click Finish.
7. To export the data to Excel, click Export to Excel. If the number of records exceeds the maximum value defined in the onedata.job.attachmentmaxrecordcount property, OneData provides a warning and the option to continue or stop the export.