In the first step of the wizard, select the <Blank> template and click Next. You are now at the Query step. You may have your own query to insert into the Query section; however, for this tutorial we are using the following query:
select QUADRANT_ACTUALS.REGION, QUADRANT_ACTUALS.DEPARTMENT, QUADRANT_ACTUALS.POSITIONTITLE, QUADRANT_ACTUALS.ACTUAL, QUADRANT_ACTUALS.BUDGET, QUADRANT_ACTUALS.VARIANCE from QUADRANT_ACTUALS order by QUADRANT_ACTUALS.REGION,QUADRANT_ACTUALS.DEPARTMENT
JNDI
You have the option of using JNDI or XQuery for the SampleData database. The JNDI name to select is SampleData.
Adding a new JNDI connection
To create a new JNDI connection, click Add and enter the JDBC information for the JNDI connection. Be sure to give the connection a name. The list of drivers found in lib/jdbc is automatically populated in the list of drivers.
Adding a new JNDI connection.
The new connection is now available in the list of JNDI connections.
SQL Query Designer
For SQL queries you can design your query using the Query Designer. This allows you to graphically construct your query making it much easier to build. 
Mondrian/MDX
If you would like to use MDX instead of SQL select Use Mondrian/MDX and browse to your Mondrian Cube Definition file. Pentaho has included a few sample MDX reports in the samples folder. Next, enter the MDX query for your Mondrian cube and proceed to the next step.
Using Mondrian in the Report Design Wizard
XQuery
To use XQuery with the sample data browse to the Quad_Data.xml file under {WIZARD_ROOT}/samples/data. The query to use for this type of connection is /result-set/*. A more interesting query might be to select data for the Central region only as shown below:
/descendant::row[REGION='Central']
Metadata Query Language (MQL)
The Report Design Wizard supports the Pentaho Metadata Query Language (MQL). To use MQL in the RDW you must select MQL from the connection type and then browse to a valid XMI document. Once the document has been selected you can use the MQL query builder tool to construct your query.
Using the MQL designer in the Report Design Wizard
Comments (6)
Apr 10, 2007
Anonymous says:
"Adding a new JNDI Connection" "The list of drivers found in lib/jdbc is automa..."Adding a new JNDI Connection"
"The list of drivers found in lib/jdbc is automatically populated in the list of drivers."
That lib/jdbc dir is under eclipse\plugins\org.pentaho.designstudio.editors.actionsequence_1.2.0.341-GA\rdw\
Apr 10, 2007
Anonymous says:
Quad_Data.xml is actually under samples/reporting, not samples/data.Quad_Data.xml is actually under samples/reporting, not samples/data.
Apr 14, 2008
Anonymous says:
The report templates created from Pentaho Report Designer work fine in Report de...The report templates created from Pentaho Report Designer work fine in Report designer but when exported as xmi file and when the report is invoked in PCI on Tomcat, Pentaho Runtime Engine is not able to find out the model MODEL 1, Is there any alternative way of publishing the MQL Reports, please let me know, Am reachable on jayathirth.chitragar@wipro.com
the error i got is here
org.pentaho.pms.core.exception.PentahoMetadataException: MQLQuery.ERROR_0009 - model MODEL 1 not found (org.pentaho.plugin.mql.MQLRelationalDataComponent).
May 30, 2008
Anonymous says:
This is not a step by step guide. If so it would tell you to paste your query in...This is not a step by step guide. If so it would tell you to paste your query into the Specify Query String box. In addition, the information about Mondrian, etc. is additional information that might be good to know but is not part of a step by step guide. It could be referenced with additional links. This additional information merely detracts from someone trying to actually do something step by step. It would be much better to keep information to the point about what end users need to perform step by step in one entry, removing extraneous information. Should not have to go to a whole slew of files to complete step by step from one end to conclusion.
Jun 24, 2008
Anonymous says:
i found error java.lang.ArrayIndexOutOfBoundsException: 3184i found error
java.lang.ArrayIndexOutOfBoundsException: 3184
Jul 01, 2008
Anonymous says:
i wanna apply a query on an XMI based on meta data but the problem is that the p...i wanna apply a query on an XMI based on meta data but the problem is that the page doesnt show any of the tables i used in meta data ( note i have build a data base in access then i made a connection through metadata then i made the business tabeles & realationships then i published them but as i said they arnt shown in the report builder? so whats wrong?