|
|
| Line 24: |
Line 24: |
| | == Completed Report Portlet == | | == Completed Report Portlet == |
| | | | |
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 861
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 862
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 587
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 587
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
| − | [[Image:reportcompl.jpg|400px|thumb]] | + | [[Image:reportcompl.jpg|500px|thumb]] |
| | | | |
| | Here is a completed Completed Chart Portlet. Several things to point out: | | Here is a completed Completed Chart Portlet. Several things to point out: |
| Line 36: |
Line 36: |
| | * 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. | | * 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. |
| | | | |
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 861
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 862
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 587
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 587
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 608
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 241
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 242
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/o3csyjea3ono/domains/wiki.marvelit.com/html/includes/diff/DairikiDiff.php on line 954
| − | [[Image:reportlever.jpg]] | + | [[Image:Reportlever.jpg]] |
| | | | |
| | | | |
Revision as of 04:48, 22 September 2006
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.
Column Format XML: Field for entering XML formating for the report. See Format Portlets using XML for additional information on XML formatting.
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.
Cancel: Cancel changes and display the report.
Save: Save changes and display the report.
Completed Report Portlet
Here is a completed Completed Chart 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: the wildcard for the database is 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:
- xtab_value_description = '$P{Value} and metric_code = '$P{MetricCode} and salesorgname = '$P{SalesOrg}'
- 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. The report title of Top $P{Cutoff} Customers will change based on the value selected in the Cutoff Lever.
Here is the displayed report from the Report Portlet example:
