16.13 Printing a Report Region by Defining a Report Query
Print a report region by defining a report query.
- About Report Queries
Learn about report queries. - Creating a Report Query
Create a report query in Shared Components. - Editing a Report Query
Edit a report query in Shared Components. - Copying a Report Query
Copy a report query in Shared Components.
Parent topic: Managing Shared Components
16.13.1 About Report Queries
Learn about report queries.
You can print a report region by defining a report query as a Shared Component. A report query identifies the data to be extracted. Unlike SQL statements contained in regions, report queries contain SQL statements that are validated when you save the query. Note that report queries must be SQL statements, not functions returning SQL statements.
You can associate a report query with a report layout and download it as a formatted document. If no report layout is selected, a generic layout is used. The generic layout is intended to be used to test and verify a report query. When using the generic layout option and multiple source queries are defined, only the first result set is included in the print document. The reports can include session state of the current application.
To make these reports available to end users, you then integrate them with an application. For example, you can associate a report query with a button, list item, branch, or other navigational component that enables you to use URLs as targets. Selecting that item then initiates the printing process.
Parent topic: Printing a Report Region by Defining a Report Query
16.13.2 Creating a Report Query
Create a report query in Shared Components.
Note that the availability of the report query options depends on how your service administrator configures report printing for your instance. All options described in these steps may not be available to you.
To create a report query:
- Navigate to the Shared Components page:
- Under Files and Reports, click Report Queries.
- Click Create.
- Report Query Definition - Specify the following:
- Source Queries - For SQL Query, .
- SQL Query - Enter a SQL statement to define the report query.
- Set Bind Variables - Click Set Bind Variables to be able to enter in values for each bind variable and test the query to ensure the expected output is returned.
- Click Next.
- Download Definition:
- Upload Report Layout:
- Report Layout Source - Specify whether to use the generic built-in report layout or a custom report layout.
- Layout Name - Enter a layout name (optional). The default is the report query name.
- Report Layout File - Select the file to upload.
- Click Next.
- Confirm displays the following information:
See Also:
Parent topic: Printing a Report Region by Defining a Report Query
16.13.3 Editing a Report Query
Edit a report query in Shared Components.
To edit a report query:
- Navigate to the Shared Components page:
- Under Files and Reports, click Report Queries.
- Select the appropriate report query.
- On the Edit page, edit the appropriate attributes.
- Click Apply Changes.
Parent topic: Printing a Report Region by Defining a Report Query
16.13.4 Copying a Report Query
Copy a report query in Shared Components.
To copy a report query:
Parent topic: Printing a Report Region by Defining a Report Query