Report Portlet

From MT Marvelit
Jump to: navigation, search

Row / Column based reports are displayed using the MarvelIT Report Portlet.

Select Datasource: The datasource used to execute the query for this report.

Select from Saved Query: A list of saved queries (from the Report table).

Parameter List: List of Parameters, separated by a space. Is available when selecting a saved query. See Parameter section below.

Title: Title of the report.

Saved Report Name: Name of the report (displayed in the Saved Query list). Admin only.

SQL: SQL Query used to populate the report. Admin only.

XML Descriptor: Field for entering XML formating for the report. See Format Portlets using XML for additional information on XML formatting.

Cancel: Cancel changes and display the report.

Save: Save changes and display the report.

Completed Report Portlet


Here is a completed Completed Report Portlet. Several things to point out:

Parameters: Entering Valid Lever Names ( see Levers Portlet ) in the Parameter List field - causes the portlet to refresh and fields are displayed for entering default values for each lever. In this example: specific values for the lever are entered. Any value for that particular lever can be entered as a default value.

Parameters in SQL: The Levers are entered into the example SQL as follows:

  • Org2 like '$P{Org2} and FClass like '$P{FClass} and RClass like '$P{RClass}'
  • When the pane is displayed - those levers will appear at the top of the pane. Selecting values for them and clicking the GO button - will cause the portlet to refresh and the lever values will be used in the SQL statement.


Parameters in Titles: Lever values can be used in Titles as well. For Example if you wanted to place the selected value of Org2 in the Title - you would enter Charges by Type $P{Org2} in the Title Field.

Here is the displayed report from the Report Portlet example: