<?xml version="1.0"?><Report><ReportQuery><Format><ReportTitle>Film List</ReportTitle><ReportDescription>The Film List Report provides a list of the DVD titles available from our shop.
&lt;p&gt;
This is Tutorial demonstrates the following features :-
&lt;p&gt;
1. &lt;b&gt;Incorporating a database graphic into the report&lt;/b&gt;
</ReportDescription><PageSize>A4</PageSize><PageOrientation>Portrait</PageOrientation><TopMargin></TopMargin><BottomMargin></BottomMargin><RightMargin></RightMargin><LeftMargin></LeftMargin><pdfFont></pdfFont><pdfFontSize></pdfFontSize><PreExecuteCode>NONE</PreExecuteCode><formBetweenRows>solidline</formBetweenRows><gridDisplay>.DEFAULT</gridDisplay><gridSortable>.DEFAULT</gridSortable><gridSearchable>.DEFAULT</gridSearchable><gridPageable>.DEFAULT</gridPageable><gridPageSize>.DEFAULT</gridPageSize></Format><Datasource><SourceType>database</SourceType><SourceConnection><DatabaseType>mysql</DatabaseType><DatabaseName></DatabaseName><HostName></HostName><ServiceName></ServiceName><UserName></UserName><Password></Password></SourceConnection></Datasource><EntryForm><Query><TableSql>reptut_film film, reptut_country country, reptut_category category</TableSql><WhereSql>         AND film.cat_code = category.cat_code
AND film.country_code = country.country_code</WhereSql><GroupSql></GroupSql><RowSelection>all</RowSelection><SQL><QuerySql></QuerySql><SQLRaw></SQLRaw></SQL><QueryColumns><QueryColumn><Name>film_id</Name><TableName>film</TableName><ColumnName>film_id</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title>Film Id</column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label></group_trailer_label></Format></QueryColumn><QueryColumn><Name>title</Name><TableName></TableName><ColumnName>title</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF>5cm</ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title>Title</column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label></group_trailer_label></Format></QueryColumn><QueryColumn><Name>cat_desc</Name><TableName></TableName><ColumnName>cat_desc</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>hide</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF>3cm</ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title>Category</column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label></group_trailer_label></Format></QueryColumn><QueryColumn><Name>country_name</Name><TableName>country</TableName><ColumnName>country_name</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title>Country</column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label></group_trailer_label></Format></QueryColumn><QueryColumn><Name>year</Name><TableName></TableName><ColumnName>year</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title>Year</column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label></group_trailer_label></Format></QueryColumn><QueryColumn><Name>country_code</Name><TableName>film</TableName><ColumnName>country_code</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>hide</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF>2cm</ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title></column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label></group_trailer_label></Format></QueryColumn><QueryColumn><Name>minyear</Name><TableName></TableName><ColumnName></ColumnName><ColumnType>char</ColumnType><ColumnLength></ColumnLength><Format><column_display>hide</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title></column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label>Min</group_trailer_label></Format></QueryColumn><QueryColumn><Name>maxyear</Name><TableName></TableName><ColumnName></ColumnName><ColumnType>char</ColumnType><ColumnLength></ColumnLength><Format><column_display>hide</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title></column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label>Max</group_trailer_label></Format></QueryColumn><QueryColumn><Name>avgyear</Name><TableName></TableName><ColumnName></ColumnName><ColumnType>char</ColumnType><ColumnLength></ColumnLength><Format><column_display>hide</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title></column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label>Avg</group_trailer_label></Format></QueryColumn><QueryColumn><Name>sumyear</Name><TableName></TableName><ColumnName></ColumnName><ColumnType>char</ColumnType><ColumnLength></ColumnLength><Format><column_display>hide</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title></column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label>Total</group_trailer_label></Format></QueryColumn><QueryColumn><Name>count</Name><TableName></TableName><ColumnName></ColumnName><ColumnType>char</ColumnType><ColumnLength></ColumnLength><Format><column_display>hide</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title>Line</column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label>Grand Total Count</group_trailer_label></Format></QueryColumn><QueryColumn><Name>groupcount</Name><TableName></TableName><ColumnName></ColumnName><ColumnType>char</ColumnType><ColumnLength></ColumnLength><Format><column_display>hide</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title></column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label>Category Count</group_trailer_label></Format></QueryColumn><QueryColumn><Name>grandtotals</Name><TableName></TableName><ColumnName></ColumnName><ColumnType>char</ColumnType><ColumnLength></ColumnLength><Format><column_display>hide</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF></ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title></column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label></group_trailer_label></Format></QueryColumn><QueryColumn><Name>flag</Name><TableName></TableName><ColumnName></ColumnName><ColumnType>char</ColumnType><ColumnLength></ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><ColumnStartPDF></ColumnStartPDF><justify>left</justify><ColumnWidthPDF>2cm</ColumnWidthPDF><ColumnWidthHTML></ColumnWidthHTML><column_title>Flag</column_title><tooltip></tooltip><group_header_label></group_header_label><group_header_label_xpos></group_header_label_xpos><group_header_data_xpos></group_header_data_xpos><group_trailer_label></group_trailer_label></Format></QueryColumn></QueryColumns><OrderColumns><OrderColumn><Name>cat_desc</Name><OrderType>ASC</OrderType></OrderColumn><OrderColumn><Name>title</Name><OrderType>ASC</OrderType></OrderColumn></OrderColumns><PreSQLS><PreSQL><SQLText>-- Enter SQL</SQLText></PreSQL></PreSQLS></Query><Assignments><Assignment><AssignName>minyear</AssignName><AssignNameNew></AssignNameNew><Expression>min({year},{cat_desc})</Expression><Condition></Condition></Assignment><Assignment><AssignName>maxyear</AssignName><AssignNameNew></AssignNameNew><Expression>embed_hyperlink('Drill', '/swsite/site/reportico-git/./run.php?xmlin=tut1_films.xml&amp;execute_mode=EXECUTE&amp;target_format=HTML&amp;target_show_body=1&amp;project=tutorials&amp;MANUAL_film='.{film_id}.'', true, true)</Expression><Condition></Condition></Assignment><Assignment><AssignName>sumyear</AssignName><AssignNameNew></AssignNameNew><Expression>sum({year},{cat_desc})</Expression><Condition></Condition></Assignment><Assignment><AssignName>avgyear</AssignName><AssignNameNew></AssignNameNew><Expression>round(avg({year},{cat_desc}))</Expression><Condition></Condition></Assignment><Assignment><AssignName>count</AssignName><AssignNameNew></AssignNameNew><Expression>count()</Expression><Condition></Condition></Assignment><Assignment><AssignName>groupcount</AssignName><AssignNameNew></AssignNameNew><Expression>count({cat_desc})</Expression><Condition></Condition></Assignment><Assignment><AssignName>flag</AssignName><AssignNameNew></AssignNameNew><Expression>imagequery(&quot;SELECT flag FROM reptut_country where country_code ='&quot;.{country_code}.&quot;'&quot;,50)</Expression><Condition></Condition></Assignment><Assignment><AssignName>title</AssignName><AssignNameNew></AssignNameNew><Expression>embed_hyperlink({title}, 'run.php?xmlin=tut2_loanhistory.xml&amp;execute_mode=EXECUTE&amp;target_format=HTML&amp;target_show_body=1&amp;project=tutorials&amp;MANUAL_loanDate_FROMDATE=FIRSTOFLASTYEAR&amp;MANUAL_loanDate_TODAY&amp;MANUAL_film='.{film_id}.'')</Expression><Condition></Condition></Assignment></Assignments><Criteria><CriteriaItem><Name>film</Name><Title>Film</Title><QueryTableName></QueryTableName><QueryColumnName>film.film_id</QueryColumnName><CriteriaType>LOOKUP</CriteriaType><CriteriaDisplay>TEXTFIELD</CriteriaDisplay><ExpandDisplay>MULTI</ExpandDisplay><ReturnColumn>film_id</ReturnColumn><DisplayColumn>full</DisplayColumn><OverviewColumn>title</OverviewColumn><MatchColumn>title</MatchColumn><CriteriaDefaults></CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql>reptut_film</TableSql><WhereSql>          
[ and country_code IN ({country,VALUE}) ]  
[ and cat_code IN ({category,VALUE}) ]</WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQLRaw></SQLRaw><SQL><QuerySql></QuerySql></SQL><QueryColumns><QueryColumn><Name>film_id</Name><TableName></TableName><ColumnName>film_id</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><justify>left</justify></Format></QueryColumn><QueryColumn><Name>title</Name><TableName></TableName><ColumnName>title</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><justify>left</justify></Format></QueryColumn><QueryColumn><Name>full</Name><TableName></TableName><ColumnName></ColumnName><ColumnType>char</ColumnType><ColumnLength></ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><justify>left</justify></Format></QueryColumn></QueryColumns><OrderColumns><OrderColumn><Name>title</Name><OrderType>ASC</OrderType></OrderColumn></OrderColumns><Assignments><Assignment><AssignName>full</AssignName><AssignNameNew></AssignNameNew><Expression>str_pad({film_id},4,&quot;0&quot;,STR_PAD_LEFT).&quot;.&amp;nbsp;&amp;nbsp;&quot;.{title}</Expression><Condition></Condition></Assignment></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem><CriteriaItem><Name>country</Name><Title>Country</Title><QueryTableName></QueryTableName><QueryColumnName>country.country_code</QueryColumnName><CriteriaType>LOOKUP</CriteriaType><CriteriaDisplay>TEXTFIELD</CriteriaDisplay><ExpandDisplay>MULTI</ExpandDisplay><ReturnColumn>country_code</ReturnColumn><DisplayColumn>country_name</DisplayColumn><OverviewColumn>country_name</OverviewColumn><MatchColumn>country_name</MatchColumn><CriteriaDefaults></CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql>reptut_country</TableSql><WhereSql></WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQLRaw></SQLRaw><SQL><QuerySql></QuerySql></SQL><QueryColumns><QueryColumn><Name>country_code</Name><TableName></TableName><ColumnName>country_code</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><justify>left</justify></Format></QueryColumn><QueryColumn><Name>country_name</Name><TableName></TableName><ColumnName>country_name</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><justify>left</justify></Format></QueryColumn></QueryColumns><OrderColumns><OrderColumn><Name>country_name</Name><OrderType></OrderType></OrderColumn></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem><CriteriaItem><Name>category</Name><Title>Film Category</Title><QueryTableName></QueryTableName><QueryColumnName>film.cat_code</QueryColumnName><CriteriaType>LOOKUP</CriteriaType><CriteriaDisplay>CHECKBOX</CriteriaDisplay><ExpandDisplay>NOINPUT</ExpandDisplay><ReturnColumn>cat_code</ReturnColumn><DisplayColumn>cat_desc</DisplayColumn><OverviewColumn>cat_desc</OverviewColumn><MatchColumn>cat_desc</MatchColumn><CriteriaDefaults></CriteriaDefaults><CriteriaList></CriteriaList><Query><TableSql>reptut_category</TableSql><WhereSql>      </WhereSql><GroupSql></GroupSql><RowSelection></RowSelection><SQLRaw></SQLRaw><SQL><QuerySql></QuerySql></SQL><QueryColumns><QueryColumn><Name>cat_code</Name><TableName></TableName><ColumnName>cat_code</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><justify>left</justify></Format></QueryColumn><QueryColumn><Name>cat_desc</Name><TableName></TableName><ColumnName>cat_desc</ColumnName><ColumnType>char</ColumnType><ColumnLength>30</ColumnLength><Format><column_display>show</column_display><content_type>plain</content_type><justify>left</justify></Format></QueryColumn></QueryColumns><OrderColumns></OrderColumns><Assignments></Assignments></Query><CriteriaLinks></CriteriaLinks></CriteriaItem></Criteria><Output><PageHeaders></PageHeaders><PageFooters></PageFooters><DisplayOrders><DisplayOrder><ColumnName>film_id</ColumnName><OrderNumber>1</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>title</ColumnName><OrderNumber>2</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>cat_desc</ColumnName><OrderNumber>3</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>country_name</ColumnName><OrderNumber>4</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>year</ColumnName><OrderNumber>5</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>minyear</ColumnName><OrderNumber>6</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>maxyear</ColumnName><OrderNumber>7</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>avgyear</ColumnName><OrderNumber>8</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>sumyear</ColumnName><OrderNumber>9</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>count</ColumnName><OrderNumber>10</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>groupcount</ColumnName><OrderNumber>11</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>grandtotals</ColumnName><OrderNumber>12</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>flag</ColumnName><OrderNumber>13</OrderNumber></DisplayOrder><DisplayOrder><ColumnName>country_code</ColumnName><OrderNumber>14</OrderNumber></DisplayOrder></DisplayOrders><Groups><Group><GroupName>grandtotals</GroupName><BeforeGroupHeader>blankline</BeforeGroupHeader><AfterGroupHeader>blankline</AfterGroupHeader><BeforeGroupTrailer>blankline</BeforeGroupTrailer><AfterGroupTrailer>blankline</AfterGroupTrailer><GroupHeaders></GroupHeaders><GroupTrailers><GroupTrailer><GroupTrailerDisplayColumn>title</GroupTrailerDisplayColumn><GroupTrailerValueColumn>count</GroupTrailerValueColumn><GroupTrailerCustom></GroupTrailerCustom></GroupTrailer></GroupTrailers></Group><Group><GroupName>cat_desc</GroupName><BeforeGroupHeader>blankline</BeforeGroupHeader><AfterGroupHeader>blankline</AfterGroupHeader><BeforeGroupTrailer>blankline</BeforeGroupTrailer><AfterGroupTrailer>blankline</AfterGroupTrailer><GroupHeaders><GroupHeader><GroupHeaderColumn>cat_desc</GroupHeaderColumn><GroupHeaderCustom></GroupHeaderCustom></GroupHeader></GroupHeaders><GroupTrailers><GroupTrailer><GroupTrailerDisplayColumn>year</GroupTrailerDisplayColumn><GroupTrailerValueColumn>minyear</GroupTrailerValueColumn><GroupTrailerCustom></GroupTrailerCustom></GroupTrailer><GroupTrailer><GroupTrailerDisplayColumn>year</GroupTrailerDisplayColumn><GroupTrailerValueColumn>maxyear</GroupTrailerValueColumn><GroupTrailerCustom></GroupTrailerCustom></GroupTrailer><GroupTrailer><GroupTrailerDisplayColumn>year</GroupTrailerDisplayColumn><GroupTrailerValueColumn>avgyear</GroupTrailerValueColumn><GroupTrailerCustom></GroupTrailerCustom></GroupTrailer><GroupTrailer><GroupTrailerDisplayColumn>year</GroupTrailerDisplayColumn><GroupTrailerValueColumn>sumyear</GroupTrailerValueColumn><GroupTrailerCustom></GroupTrailerCustom></GroupTrailer><GroupTrailer><GroupTrailerDisplayColumn>title</GroupTrailerDisplayColumn><GroupTrailerValueColumn>groupcount</GroupTrailerValueColumn><GroupTrailerCustom></GroupTrailerCustom></GroupTrailer></GroupTrailers></Group></Groups><Graphs></Graphs></Output></EntryForm></ReportQuery></Report>