<?xml version="1.0"?><Report><ReportQuery><Format><ReportTitle>Configure Tutorials</ReportTitle><ReportDescription>

Enable your tutorials project here by configuring the connection to an existing MySQL database that the tutorials will run against.
&lt;br&gt;&lt;br&gt;
After correctly setting your database credentials and pressing the &lt;i&gt;Go&lt;/i&gt; the example reports and tutorials are set up in the folder &lt;i&gt;projects/tutorials&lt;/i&gt; under you Reportico installation folder.&lt;br&gt;&lt;br&gt;
Then you can return to the Admin Menu, and select the &lt;b&gt;tutorials&lt;/b&gt; project from the "Run Project Report Suite" drop down and use "Generate the Tutorial Tables" option to create your sample data. Then you are ready to run the sample reports and try out the tutorials.


</ReportDescription>
<PageSize>A4</PageSize><PageOrientation>Portrait</PageOrientation><TopMargin></TopMargin><BottomMargin></BottomMargin><RightMargin></RightMargin><LeftMargin></LeftMargin><pdfFont></pdfFont><pdfFontSize></pdfFontSize><PreExecuteCode>global $_configure_mode;

$_configure_mode = &quot;CREATETUTORIALS&quot;;

include('projects/admin/configureproject.xml.php');</PreExecuteCode><bodyDisplay>show</bodyDisplay><graphDisplay>show</graphDisplay></Format><Datasource><SourceType>database</SourceType><SourceConnection><DatabaseType></DatabaseType><DatabaseName></DatabaseName><HostName>localhost</HostName><ServiceName></ServiceName><UserName></UserName><Password></Password></SourceConnection></Datasource><EntryForm><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection>all</RowSelection><SQL><QuerySql></QuerySql><SQLLimitFirst></SQLLimitFirst><SQLSkipOffset></SQLSkipOffset></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><PreSQLS></PreSQLS></Query><Assignments></Assignments><Criteria>

<CriteriaItem><Name>project</Name><Title>Project Name</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_PROJECT_NAME</CriteriaHelp><CriteriaType>TEXTFIELD</CriteriaType><CriteriaHidden>yes</CriteriaHidden><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>tutorials</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>projtitle</Name><Title>Project Title</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHidden>yes</CriteriaHidden><CriteriaHelp>HELP_PROJECT_TITLE</CriteriaHelp><CriteriaType>TEXTFIELD</CriteriaType><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>Northwind Tutorials System</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>dbtype</Name><Title>Database Type</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_DATABASE_TYPE</CriteriaHelp><CriteriaType>LIST</CriteriaType><CriteriaDisplay>RADIO</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>pdo_mysql</CriteriaDefaults><CriteriaList>mysql=pdo_mysql</CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>host</Name><Title>Host Name</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_DATABASE_HOST</CriteriaHelp><CriteriaType>TEXTFIELD</CriteriaType><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_DB_HOST}</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>database</Name><Title>Database Name</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_DATABASE_NAME</CriteriaHelp><CriteriaType>TEXTFIELD</CriteriaType><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_DB_DATABASE}</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>user</Name><Title>User Name</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_DATABASE_USER</CriteriaHelp><CriteriaType>TEXTFIELD</CriteriaType><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_DB_USER}</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>password</Name><Title>Password</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_DATABASE_PASSWORD</CriteriaHelp><CriteriaType>TEXTFIELD</CriteriaType><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_DB_PASSWORD}</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>baseurl</Name><Title>Base URL</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_DATABASE_BASE_URL</CriteriaHelp><CriteriaHidden>yes</CriteriaHidden><CriteriaType>TEXTFIELD</CriteriaType><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_HTTP_BASEDIR}</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>server</Name><Title>Server (Informix Only)</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_DATABASE_INFORMIX_SERVER</CriteriaHelp><CriteriaHidden>yes</CriteriaHidden><CriteriaType>TEXTFIELD</CriteriaType><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_DB_SERVER}</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>protocol</Name><Title>Protocol (Informix Only)</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_DATABASE_INFORMIX_PROTOCOL</CriteriaHelp><CriteriaHidden>yes</CriteriaHidden><CriteriaType>TEXTFIELD</CriteriaType><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_DB_PROTOCOL}</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>dbencoding</Name><Title>Database Character &lt;br&gt;Encoding</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHidden>yes</CriteriaHidden><CriteriaType>LIST</CriteriaType><CriteriaDisplay>DROPDOWN</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_DB_ENCODING}</CriteriaDefaults>
<CriteriaList>
No Encoding=None,
UTF8=UTF8,
LATIN1/ISO-8859-1/Western European=LATIN1,
LATIN2/ISO-8859-2/Central European=LATIN2,
LATIN3/ISO-8859-3/South European=LATIN3,
LATIN4/ISO-8859-4/Baltic=LATIN4,
ISO-8859-5/Cyrillic=ISO-8859-5,
ISO-8859-6/Arabic=ISO-8859-6,
ISO-8859-7/Greek=ISO-8859-7,
ISO-8859-8/Hebrew=ISO-8859-8,
LATIN5/ISO-8859-9/Turkish=LATIN5,
LATIN6/ISO-8859-10/Nordic=LATIN6,
LATIN7/ISO-8859-13/Baltic=LATIN7,
LATIN8/ISO-8859-14/Celtic=LATIN8,
LATIN9/ISO-8859-15/Western=LATIN9,
LATIN10/ISO-8859-16/Romanian=LATIN10,
GB2312=GB2312,
GBK=GBK,
Shift JIS=SJIS,
BIG5=BIG5,
Central European (Windows 1250)=WIN1250,
Cyrillic (Windows 1251)=WIN1251,
Western (Windows 1252)=WIN1252,
Greek (Windows 1253)=WIN1253,
Turkish (Windows 1254)=WIN1254,
Hebrew (Windows 1255)=WIN1255,
Arabic (Windows 1256)=WIN1256,
Baltic (Windows 1257)=WIN1257,
Vietnamese (Windows 1258)=WIN1258,
Windows 866=WIN866,
Windows 874=WIN874,
EUC_CN=EUC_CN,
EUC_JP=EUC_JP,
EUC_KR=EUC_KR,
EUC_TW=EUC_TW,
GB18030=GB18030,
TIS620=TIS620
</CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>outputencoding</Name><Title>Output Character Encoding</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaType>LIST</CriteriaType><CriteriaHidden>yes</CriteriaHidden><CriteriaDisplay>DROPDOWN</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_OUTPUT_ENCODING}</CriteriaDefaults><CriteriaList>
No Encoding=None,
UTF8=UTF8,
Western European (ISO-8859-1)=ISO-8859-1,
Central European (ISO-8859-2)=ISO-8859-2,
Southern European (ISO-8859-3)=ISO-8859-3,
Baltic (ISO-8859-4)=ISO-8859-4,
Cyrillic (ISO-8859-5)=ISO-8859-5,
Arabic (ISO-8859-6)=ISO-8859-6,
Greek (ISO-8859-7) ISO-8859-7,
Hebrew Visual (ISO-8859-8-I)=ISO-8859-8-I,
Hebrew Logical (ISO-8859-8)=ISO-8859-8,
Turkish (ISO-8859-9)=ISO-8859-9,
Nordic (ISO-8859-10)=ISO-8859-10,
Estonian (ISO-8859-11)=ISO-8859-11,
Estonian (ISO-8859-12)=ISO-8859-12,
Estonian (ISO-8859-13)=ISO-8859-13,
Celtic (ISO-8859-14)=ISO-8859-14,
Western (ISO-8859-15)=ISO-8859-15,
Romanian (ISO-8859-16)=ISO-8859-16,
Chinese Simplified (GB2312)=GB2312,
GBK=GBK,
Japanese (Shift-JIS)=Shift_JIS,
Central European (Windows-1250)=Windows-1250,
Cyrillic (Windows-1251)=Windows-1251,
Western European (Windows-1252)=Windows-1252
Greek (Windows-1253)=Windows-1253,
Turkish (Windows-1254)=Windows-1254,
Hebrew (Windows-1255)=Windows-1255,
Arabic (Windows-1256)=Windows-1256,
Baltic (Windows-1257)=Windows-1257,
Vietnamese (Windows-1258)=Windows-1258,
Chinese Traditional (Big5)=Big5,
Chinese Simplified (GB18030)=GB18030,
Chinese Simplified (HZ)=HZ,
Japanese (EUC)=EUC-JP,
Korean=EUC-KR,
Thai (Windows TIS-620)=TIS-620
</CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>language</Name><Title>Project Language</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaType>LIST</CriteriaType><CriteriaHidden>yes</CriteriaHidden><CriteriaDisplay>DROPDOWN</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_LANGUAGE}</CriteriaDefaults><CriteriaList>{languages}</CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>projectpassword</Name><Title>Project Password</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_PASSWORD</CriteriaHelp><CriteriaType>TEXTFIELD</CriteriaType><CriteriaDisplay>NOINPUT</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_PROJECT_PASSWORD}</CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>displaydateformat</Name><Title>Display Date Format</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_DATE_FORMAT</CriteriaHelp><CriteriaType>LIST</CriteriaType><CriteriaDisplay>DROPDOWN</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_PREP_DATEFORMAT}</CriteriaDefaults><CriteriaList>DD/MM/YYYY=d/m/Y,DD-MM-YYYY=d-m-Y,MM/DD/YYYY=m/d/Y,MM-DD-YYYY=m-d-Y,YYYY/MM/DD=Y/m/d,YYYY-MM-DD=Y-m-d</CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>dbdateformat</Name><Title>Database Date (for MySql leave as default YYYY-MM-DD)</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaType>LIST</CriteriaType><CriteriaHidden>yes</CriteriaHidden><CriteriaDisplay>DROPDOWN</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_DB_DATEFORMAT}</CriteriaDefaults><CriteriaList>DD/MM/YYYY=d/m/Y,DD-MM-YYYY=d-m-Y,MM/DD/YYYY=m/d/Y,MM-DD-YYYY=m-d-Y,YYYY/MM/DD=Y/m/d,YYYY-MM-DD=Y-m-d</CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

<CriteriaItem><Name>safemode</Name><Title>Safe Design Mode</Title><QueryTableName></QueryTableName><QueryColumnName></QueryColumnName><CriteriaHelp>HELP_SAFE_MODE</CriteriaHelp><CriteriaType>LIST</CriteriaType><CriteriaDisplay>CHECKBOX</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn></ReturnColumn><DisplayColumn></DisplayColumn><OverviewColumn></OverviewColumn><MatchColumn></MatchColumn><CriteriaDefaults>{constant,SW_SAFE_DESIGN_MODE}</CriteriaDefaults><CriteriaList>=1</CriteriaList><Query><TableSql></TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQL><QuerySql></QuerySql></SQL><QueryColumns></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem>

</Criteria><Output><PageHeaders></PageHeaders><PageFooters></PageFooters><DisplayOrders></DisplayOrders><Groups></Groups><Graphs></Graphs></Output></EntryForm></ReportQuery></Report>
