Running Reports in Query Report Viewer

Access the Query Report Viewer page (Select Reporting Tools, and then BI Publisher, and then BIP Query Report Viewer.)

This example illustrates the fields and controls on the Query Report Viewer page. You can find definitions for the fields and controls later on this page.

The Query Report Viewer allows selection and online viewing of those reports that have a data source type of PeopleSoft Query, Connected Query, or Composite Query. Existing Query security applies so that each user has access to run only the reports to which he or she has qualified Query access to the data source.

Note:

Connected Query based reports cannot be viewed by default. To view the reports, set the psxp_cq_report_viewer property to True either on the Global Properties page or on the Properties tab of the Report Definition.

See Setting Up BI Publisher

Field or Control	Description
Show Template Prompts	Click to expand the Report Definition Search Results grid to include the template ID and as of date template prompts.
Report Name	Displays the name of the report.
Description	Displays the report's description.
Data Source Type	Displays the type of data source.
Data Source ID	Displays the report's data source ID.
Template ID	Select from the templates associated with the report definition.
As Of Date	Select the as of date for the template version that you want to view.
Format	Select from the output format choices associated with the report definition.
Burst	Indicates whether the report definition includes bursting instructions. Note: Bursted reports are listed, but you can't run them from the Query Report Viewer component. Bursted reports must be run from the Query Report Scheduler component.
View Report	Click to view the report online. When Query runtime parameters exist, the parameters are displayed. A new window opens displaying the report results according to the runtime inputs. You can save the report results locally by using the browser's Save functionality. Note: This link is disabled for bursted reports.

Note:

The data and template translation language choice is automatically supplied to the user’s session language.