<?xml version="1.0"?>
<api>
  <query-continue>
    <allpages gapcontinue="Securing_Pages_and_Folders" />
  </query-continue>
  <query>
    <pages>
      <page pageid="1380" ns="0" title="Report Portlet">
        <revisions>
          <rev contentformat="text/x-wiki" contentmodel="wikitext" xml:space="preserve">[[Image:Report.jpg|400px|thumb]]

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 [[Portlet_XML_Tags| Format Portlets using XML]] for additional information on XML formatting.

'''Cancel:''' Cancel changes and display the report.

'''Save:''' Save changes and display the report.

&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;

== Completed Report Portlet ==

[[Image:reportcompl.jpg|400px|thumb]]

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

'''Parameters:''' Entering Valid Lever Names ( see [[Levers_Portlet|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.  

[[Image:Reportlever.jpg]]


'''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.

&lt;br&gt;
&lt;br&gt;

Here is the displayed report from the Report Portlet example:

[[Image:reportexampl.jpg]]</rev>
        </revisions>
      </page>
      <page pageid="1535" ns="0" title="Sample Dashboard">
        <revisions>
          <rev contentformat="text/x-wiki" contentmodel="wikitext" xml:space="preserve">== WELCOME ==

After you have entered your license key  - you have installed DASH.  We have provided a smaple DASHBOARD for you to use as an example.  Click the '''DASH''' menu item and the sample dashboard page displays.&lt;br&gt;&lt;br&gt;

[[Image:Welcome.jpg|600px]]

== You are All Done ==

That's it.  You now have DASH configured and can build your own dashboards.  Some things to review on the Welcome pane.

Review each Portlet - click on the pencil icon in the upper right corner of each portlet.  Read the sections on Meter, Chart and Report portlets in this wiki.
&lt;br&gt;
* [[Chart_Portlets|Chart Portlet]] , How to update and save MARVELit Charts

* [[Report_Portlet|Report Portlet]] , How to update and save MARVELit Reports

* [[Meter_Portlet|Meter Portlet]] , How to update and save MARVELit Meters (dials)

* [[Editable_Report_Portlet|Editable Report Portlet]] , How to update and save MARVELit Editable Reports - data entry screens

&lt;br&gt;
Review the Levers - Select Jetspeed Administration Portlets - than DASH Levers Administration - the Levers are displayed.  See the Levers sections for further information.
&lt;br&gt;
* [[Levers_Portlet|Levers Portlet]] , How to add Levers (pull down selections) and have them work on a page

&lt;br&gt;
Review the Page Layout - click on the pencil icon in the upper right corner of the Welcome page.  See the Page Layout sections for further information.
&lt;br&gt;
* [[Formating_Panes|Formating Panes]]  , Adding Columns and Rows to existing Dashboard Panes

== What's Next ==

You now can build your own DASHBOARDS.  Review the following secitons of this wiki to help you get started.

* [[Administration_Portlets#Adding_Data_Sources|Administration Portlets]] , Adding Data Sources - Set up your own data sources

* [[Adding_Panes|Adding Panes]] , How to add or modify dashboard panes in the portal
* [[Formating_Panes|Formating Panes]]  , Adding Columns and Rows to existing Dashboard Panes
* [[Adding_Portlets|Adding Portlets to a Pane]] , Adding MARVELit portlets to panes to create dashbboards

* [[Chart_Portlets|Chart Portlet]] , How to update and save MARVELit Charts
* [[Report_Portlet|Report Portlet]] , How to update and save MARVELit Reports
* [[Meter_Portlet|Meter Portlet]] , How to update and save MARVELit Meters (dials)
* [[Editable_Report_Portlet|Editable Report Portlet]] , How to update and save MARVELit Editable Reports - data entry screens
* [[Levers_Portlet|Levers Portlet]] , How to add Levers (pull down selections) and have them work on a page
* [[Portlet_Variables|Portlet Variables]] , How to use Variables in Portlet configurations
* [[Portlet_XML_Formatting|Format Portlets using XML]] , How to use XML tags to create custom colors, fonts, and threshholds

There are also some flash movie files on our web site at [http://www.marvelit.com/video.html video.html] that provide a good overview.</rev>
        </revisions>
      </page>
    </pages>
  </query>
</api>