Problem passing date as parameter

<p>Hi all, I am doing a report in which I have a similar data set as this:</p><p> </p><p>Select id, art_name, price</p><p>from articles</p><p>where date = : p_f_date</p><p> </p><p>I am listing the report from a form and the problem is that i want to put the date as 'dd/mm/yyyy' and BIRT is expecting to receive it with the format 'mm/dd/yyyy', how can I change in BIRT to accept the date in the format that i want (dd/mm/yyyy).</p><p>If i am not clear let me know, sorry for my english.</p><p>Thank you in advance.</p>

Find more posts tagged with

Comments

lnix

<p>Try changing the format of the parameter on the Edit Parameter window.</p>

kidtorres

<blockquote class="ipsBlockquote" data-author="lnix" data-cid="118068" data-time="1372442634"><div><p>Try changing the format of the parameter on the Edit Parameter window.</p></div></blockquote><p>Hi, thank you for your response, I did that, but inside that option, in the bottom it says 'Please enter as: MM/dd/yyyy hh:mm:ss AM/PM'</p><p>and thats the problem, I want to change that..</p>

johnw

<p>I'm a little confused. In your database, are you using a date field? And you just want to have an input form that takes in dd/mm/yy?</p><p> </p><p>If so, you have a few options to do this. The easiest from a report design perspective would be to just use a Date/Time or Date parameter in your report, and do your conversion in your form.</p><p> </p><p>If your using the BIRT viewers form, you are stuck with the crummy format. The good news is that you can use a String parameter, and in your dataset, instead of "binding" it to a report parameter, set the default value expression to do something like:</p><pre class="_prettyXprint">var parser = new Packages.java.text.SimpleDateFormat("mm/dd/yy");var dateValue = parser.parse(parameters["inputDate"]);dateValue;</pre><p>This will leverage Javas SimpleDateFormat to parse the String report parameter, and return a Date parameter to your data set query. </p>

kidtorres

<blockquote class="ipsBlockquote" data-author="johnw" data-cid="118071" data-time="1372448480"><div><p>I'm a little confused. In your database, are you using a date field? And you just want to have an input form that takes in dd/mm/yy?</p><p> </p><p>If so, you have a few options to do this. The easiest from a report design perspective would be to just use a Date/Time or Date parameter in your report, and do your conversion in your form.</p><p> </p><p>If your using the BIRT viewers form, you are stuck with the crummy format. The good news is that you can use a String parameter, and in your dataset, instead of "binding" it to a report parameter, set the default value expression to do something like:</p><pre class="_prettyXprint">var parser = new Packages.java.text.SimpleDateFormat("mm/dd/yy");var dateValue = parser.parse(parameters["inputDate"]);dateValue;</pre><p>This will leverage Javas SimpleDateFormat to parse the String report parameter, and return a Date parameter to your data set query. </p></div></blockquote><p> </p><p>Hi John, thanks for your time, my problem is like the 1st solution, I tried to solved it in the form but it was a little dificult and because of that i tried to see if it was possible to solve it in BIRT, i thought that I could change the way it expects to receive the date parameter (mm/dd/yyyy) to the one I need (dd/mm/yyyy)</p>

johnw

<p>I wrote up a quick example. You can make the format string for parsing the dates anything you want. I used the dd/MM/yyyy you requested in this example. To change the format that the report uses for dates, change the formatString variable in the Data Explorer.</p><p> </p><p>Sorry for the XML, but the attach file feature appears to be broken at the moment.</p><p> </p><p>John</p><pre class="_prettyXprint _lang-"><?xml version="1.0" encoding="UTF-8"?><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1"> <property name="createdBy">Eclipse BIRT Designer Version 4.2.1.v201209101448 Build <4.2.1.v20120912-1721></property> <property name="units">in</property> <property name="iconFile">/templates/blank_report.gif</property> <property name="bidiLayoutOrientation">ltr</property> <property name="imageDPI">96</property> <parameters> <scalar-parameter name="StartDateParameter" id="9"> <text-property name="promptText">Enter the date (mm/dd/yyyy)</text-property> <property name="valueType">static</property> <property name="dataType">string</property> <property name="distinct">true</property> <simple-property-list name="defaultValue"> <value type="constant">01/01/2003</value> </simple-property-list> <list-property name="selectionList"/> <property name="paramType">simple</property> <property name="controlType">text-box</property> <structure name="format"> <property name="category">Unformatted</property> </structure> </scalar-parameter> <scalar-parameter name="EndDateParameter" id="10"> <text-property name="promptText">Enter the End Date (mm/dd/yyyy)</text-property> <property name="valueType">static</property> <property name="dataType">string</property> <property name="distinct">true</property> <simple-property-list name="defaultValue"> <value type="constant">01/01/2005</value> </simple-property-list> <list-property name="selectionList"/> <property name="paramType">simple</property> <property name="controlType">text-box</property> <structure name="format"> <property name="category">Unformatted</property> </structure> </scalar-parameter> </parameters> <data-sources> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7"> <list-property name="privateDriverProperties"> <ex-property> <name>contentBidiFormatStr</name> <value>ILYNN</value> </ex-property> <ex-property> <name>metadataBidiFormatStr</name> <value>ILYNN</value> </ex-property> </list-property> <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property> <property name="odaURL">jdbc:classicmodels:sampledb</property> <property name="odaUser">ClassicModels</property> </oda-data-source> </data-sources> <data-sets> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="setGetOrders" id="8"> <list-property name="columnHints"> <structure> <property name="columnName">ORDERNUMBER</property> <property name="analysis">measure</property> <text-property name="displayName">ORDERNUMBER</text-property> <text-property name="heading">ORDERNUMBER</text-property> </structure> <structure> <property name="columnName">ORDERDATE</property> <property name="analysis">dimension</property> <text-property name="displayName">ORDERDATE</text-property> <text-property name="heading">ORDERDATE</text-property> </structure> <structure> <property name="columnName">REQUIREDDATE</property> <property name="analysis">dimension</property> <text-property name="displayName">REQUIREDDATE</text-property> <text-property name="heading">REQUIREDDATE</text-property> </structure> <structure> <property name="columnName">SHIPPEDDATE</property> <property name="analysis">dimension</property> <text-property name="displayName">SHIPPEDDATE</text-property> <text-property name="heading">SHIPPEDDATE</text-property> </structure> <structure> <property name="columnName">STATUS</property> <property name="analysis">dimension</property> <text-property name="displayName">STATUS</text-property> <text-property name="heading">STATUS</text-property> </structure> <structure> <property name="columnName">COMMENTS</property> <property name="analysis">dimension</property> <text-property name="displayName">COMMENTS</text-property> <text-property name="heading">COMMENTS</text-property> </structure> <structure> <property name="columnName">CUSTOMERNUMBER</property> <property name="analysis">measure</property> <text-property name="displayName">CUSTOMERNUMBER</text-property> <text-property name="heading">CUSTOMERNUMBER</text-property> </structure> </list-property> <list-property name="parameters"> <structure> <property name="name">param_1</property> <property name="nativeName"></property> <property name="dataType">date</property> <property name="nativeDataType">91</property> <property name="position">1</property> <expression name="defaultValue" type="javascript">var parser = new Packages.java.text.SimpleDateFormat(vars["formatString"]);var dateValue = parser.parse( params["StartDateParameter"].value );dateValue;</expression> <property name="isOptional">true</property> <property name="allowNull">true</property> <property name="isInput">true</property> <property name="isOutput">false</property> </structure> <structure> <property name="name">param_2</property> <property name="nativeName"></property> <property name="dataType">date</property> <property name="nativeDataType">91</property> <property name="position">2</property> <expression name="defaultValue" type="javascript">var parser = new Packages.java.text.SimpleDateFormat(vars["formatString"]);var dateValue = parser.parse( params["EndDateParameter"].value );dateValue;</expression> <property name="isOptional">true</property> <property name="allowNull">true</property> <property name="isInput">true</property> <property name="isOutput">false</property> </structure> </list-property> <structure name="cachedMetaData"> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">ORDERNUMBER</property> <property name="dataType">integer</property> </structure> <structure> <property name="position">2</property> <property name="name">ORDERDATE</property> <property name="dataType">date</property> </structure> <structure> <property name="position">3</property> <property name="name">REQUIREDDATE</property> <property name="dataType">date</property> </structure> <structure> <property name="position">4</property> <property name="name">SHIPPEDDATE</property> <property name="dataType">date</property> </structure> <structure> <property name="position">5</property> <property name="name">STATUS</property> <property name="dataType">string</property> </structure> <structure> <property name="position">6</property> <property name="name">COMMENTS</property> <property name="dataType">string</property> </structure> <structure> <property name="position">7</property> <property name="name">CUSTOMERNUMBER</property> <property name="dataType">integer</property> </structure> </list-property> </structure> <property name="dataSource">Data Source</property> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">ORDERNUMBER</property> <property name="nativeName">ORDERNUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> <structure> <property name="position">2</property> <property name="name">ORDERDATE</property> <property name="nativeName">ORDERDATE</property> <property name="dataType">date</property> <property name="nativeDataType">91</property> </structure> <structure> <property name="position">3</property> <property name="name">REQUIREDDATE</property> <property name="nativeName">REQUIREDDATE</property> <property name="dataType">date</property> <property name="nativeDataType">91</property> </structure> <structure> <property name="position">4</property> <property name="name">SHIPPEDDATE</property> <property name="nativeName">SHIPPEDDATE</property> <property name="dataType">date</property> <property name="nativeDataType">91</property> </structure> <structure> <property name="position">5</property> <property name="name">STATUS</property> <property name="nativeName">STATUS</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">6</property> <property name="name">COMMENTS</property> <property name="nativeName">COMMENTS</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">7</property> <property name="name">CUSTOMERNUMBER</property> <property name="nativeName">CUSTOMERNUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> </list-property> <xml-property name="queryText"><![CDATA[select *from CLASSICMODELS.ORDERSwhere CLASSICMODELS.ORDERS.ORDERDATE between ? and ?]]></xml-property> <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?><model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel"> <Version>2.0</Version> <DataSetParameters> <parameter> <design:ParameterDefinition> <design:inOutMode>In</design:inOutMode> <design:attributes> <design:identifier> <design:name></design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:inputAttributes> <design:elementAttributes> <design:optional>true</design:optional> </design:elementAttributes> </design:inputAttributes> </design:ParameterDefinition> </parameter> <parameter> <design:ParameterDefinition> <design:inOutMode>In</design:inOutMode> <design:attributes> <design:identifier> <design:name></design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:inputAttributes> <design:elementAttributes> <design:optional>true</design:optional> </design:elementAttributes> </design:inputAttributes> </design:ParameterDefinition> </parameter> </DataSetParameters> <design:ResultSets derivedMetaData="true"> <design:resultSetDefinitions> <design:resultSetColumns> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>ORDERNUMBER</design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>ORDERNUMBER</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>ORDERNUMBER</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>ORDERDATE</design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>ORDERDATE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>ORDERDATE</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>REQUIREDDATE</design:name> <design:position>3</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>REQUIREDDATE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>REQUIREDDATE</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>SHIPPEDDATE</design:name> <design:position>4</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>SHIPPEDDATE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>SHIPPEDDATE</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>STATUS</design:name> <design:position>5</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>15</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>STATUS</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>STATUS</design:label> <design:formattingHints> <design:displaySize>15</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>COMMENTS</design:name> <design:position>6</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>32700</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>COMMENTS</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>COMMENTS</design:label> <design:formattingHints> <design:displaySize>32700</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CUSTOMERNUMBER</design:name> <design:position>7</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CUSTOMERNUMBER</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CUSTOMERNUMBER</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> </design:resultSetColumns> <design:criteria/> </design:resultSetDefinitions> </design:ResultSets></model:DesignValues>]]></xml-property> </oda-data-set> </data-sets> <styles> <style name="report" id="4"> <property name="fontFamily">sans-serif</property> <property name="fontSize">10pt</property> </style> <style name="crosstab-cell" id="5"> <property name="borderBottomColor">#CCCCCC</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">1pt</property> <property name="borderLeftColor">#CCCCCC</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">1pt</property> <property name="borderRightColor">#CCCCCC</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">1pt</property> <property name="borderTopColor">#CCCCCC</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">1pt</property> </style> <style name="crosstab" id="6"> <property name="borderBottomColor">#CCCCCC</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">1pt</property> <property name="borderLeftColor">#CCCCCC</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">1pt</property> <property name="borderRightColor">#CCCCCC</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">1pt</property> <property name="borderTopColor">#CCCCCC</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">1pt</property> </style> </styles> <page-setup> <simple-master-page name="Simple MasterPage" id="2"> <page-footer> <text id="3"> <property name="contentType">html</property> <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> </text> </page-footer> </simple-master-page> </page-setup> <body> <grid id="58"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">thin</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">thin</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">thin</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">thin</property> <property name="width">7.947916666666667in</property> <list-property name="boundDataColumns"> <structure> <property name="name">startDate</property> <expression name="expression" type="javascript">var parser = new Packages.java.text.SimpleDateFormat(vars["formatString"]);var dateValue = parser.parse( params["StartDateParameter"].value );dateValue;</expression> <property name="dataType">date-time</property> <property name="allowExport">true</property> </structure> <structure> <property name="name">endDate</property> <expression name="expression" type="javascript">var parser = new Packages.java.text.SimpleDateFormat(vars["formatString"]);var dateValue = parser.parse( params["EndDateParameter"].value );dateValue;</expression> <property name="dataType">date-time</property> <property name="allowExport">true</property> </structure> </list-property> <column id="59"> <property name="width">1.0520833333333333in</property> <property name="fontWeight">bold</property> </column> <column id="60"> <property name="width">6.895833333333333in</property> </column> <row id="61"> <cell id="62"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <label id="67"> <text-property name="text">Start Date:</text-property> </label> </cell> <cell id="63"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <data id="69"> <structure name="dateTimeFormat"> <property name="category">Long Date</property> <property name="pattern">Long Date</property> </structure> <property name="resultSetColumn">startDate</property> </data> </cell> </row> <row id="64"> <cell id="65"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <label id="68"> <text-property name="text">End Date:</text-property> </label> </cell> <cell id="66"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <data id="70"> <structure name="dateTimeFormat"> <property name="category">Long Date</property> <property name="pattern">Long Date</property> </structure> <property name="resultSetColumn">endDate</property> </data> </cell> </row> </grid> <table id="11"> <property name="dataSet">setGetOrders</property> <list-property name="boundDataColumns"> <structure> <property name="name">ORDERNUMBER</property> <text-property name="displayName">ORDERNUMBER</text-property> <expression name="expression" type="javascript">dataSetRow["ORDERNUMBER"]</expression> <property name="dataType">integer</property> </structure> <structure> <property name="name">ORDERDATE</property> <text-property name="displayName">ORDERDATE</text-property> <expression name="expression" type="javascript">dataSetRow["ORDERDATE"]</expression> <property name="dataType">date</property> </structure> <structure> <property name="name">REQUIREDDATE</property> <text-property name="displayName">REQUIREDDATE</text-property> <expression name="expression" type="javascript">dataSetRow["REQUIREDDATE"]</expression> <property name="dataType">date</property> </structure> <structure> <property name="name">SHIPPEDDATE</property> <text-property name="displayName">SHIPPEDDATE</text-property> <expression name="expression" type="javascript">dataSetRow["SHIPPEDDATE"]</expression> <property name="dataType">date</property> </structure> <structure> <property name="name">STATUS</property> <text-property name="displayName">STATUS</text-property> <expression name="expression" type="javascript">dataSetRow["STATUS"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">COMMENTS</property> <text-property name="displayName">COMMENTS</text-property> <expression name="expression" type="javascript">dataSetRow["COMMENTS"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">CUSTOMERNUMBER</property> <text-property name="displayName">CUSTOMERNUMBER</text-property> <expression name="expression" type="javascript">dataSetRow["CUSTOMERNUMBER"]</expression> <property name="dataType">integer</property> </structure> </list-property> <column id="50"/> <column id="51"/> <column id="52"/> <column id="53"/> <column id="54"/> <column id="55"/> <column id="56"/> <header> <row id="12"> <cell id="13"> <label id="14"> <text-property name="text">ORDERNUMBER</text-property> </label> </cell> <cell id="15"> <label id="16"> <text-property name="text">ORDERDATE</text-property> </label> </cell> <cell id="17"> <label id="18"> <text-property name="text">REQUIREDDATE</text-property> </label> </cell> <cell id="19"> <label id="20"> <text-property name="text">SHIPPEDDATE</text-property> </label> </cell> <cell id="21"> <label id="22"> <text-property name="text">STATUS</text-property> </label> </cell> <cell id="23"> <label id="24"> <text-property name="text">COMMENTS</text-property> </label> </cell> <cell id="25"> <label id="26"> <text-property name="text">CUSTOMERNUMBER</text-property> </label> </cell> </row> </header> <detail> <row id="27"> <cell id="28"> <data id="29"> <property name="resultSetColumn">ORDERNUMBER</property> </data> </cell> <cell id="30"> <data id="31"> <property name="resultSetColumn">ORDERDATE</property> </data> </cell> <cell id="32"> <data id="33"> <property name="resultSetColumn">REQUIREDDATE</property> </data> </cell> <cell id="34"> <data id="35"> <property name="resultSetColumn">SHIPPEDDATE</property> </data> </cell> <cell id="36"> <data id="37"> <property name="resultSetColumn">STATUS</property> </data> </cell> <cell id="38"> <data id="39"> <property name="resultSetColumn">COMMENTS</property> </data> </cell> <cell id="40"> <data id="41"> <property name="resultSetColumn">CUSTOMERNUMBER</property> </data> </cell> </row> </detail> <footer> <row id="42"> <cell id="43"/> <cell id="44"/> <cell id="45"/> <cell id="46"/> <cell id="47"/> <cell id="48"/> <cell id="49"/> </row> </footer> </table> </body> <property name="pageVariables"> <variable-element name="formatString"> <expression name="value" type="javascript">"dd/MM/yyyy"</expression> <property name="type">report</property> </variable-element> </property></report></pre>

kidtorres

<blockquote class="ipsBlockquote" data-author="johnw" data-cid="118106" data-time="1372729132"><div><p> </p><p>I wrote up a quick example. You can make the format string for parsing the dates anything you want. I used the dd/MM/yyyy you requested in this example. To change the format that the report uses for dates, change the formatString variable in the Data Explorer.</p><p> </p><p>Sorry for the XML, but the attach file feature appears to be broken at the moment.</p><p> </p><p>John</p><pre class="_prettyXprint _lang-"><?xml version="1.0" encoding="UTF-8"?><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1"> <property name="createdBy">Eclipse BIRT Designer Version 4.2.1.v201209101448 Build <4.2.1.v20120912-1721></property> <property name="units">in</property> <property name="iconFile">/templates/blank_report.gif</property> <property name="bidiLayoutOrientation">ltr</property> <property name="imageDPI">96</property> <parameters> <scalar-parameter name="StartDateParameter" id="9"> <text-property name="promptText">Enter the date (mm/dd/yyyy)</text-property> <property name="valueType">static</property> <property name="dataType">string</property> <property name="distinct">true</property> <simple-property-list name="defaultValue"> <value type="constant">01/01/2003</value> </simple-property-list> <list-property name="selectionList"/> <property name="paramType">simple</property> <property name="controlType">text-box</property> <structure name="format"> <property name="category">Unformatted</property> </structure> </scalar-parameter> <scalar-parameter name="EndDateParameter" id="10"> <text-property name="promptText">Enter the End Date (mm/dd/yyyy)</text-property> <property name="valueType">static</property> <property name="dataType">string</property> <property name="distinct">true</property> <simple-property-list name="defaultValue"> <value type="constant">01/01/2005</value> </simple-property-list> <list-property name="selectionList"/> <property name="paramType">simple</property> <property name="controlType">text-box</property> <structure name="format"> <property name="category">Unformatted</property> </structure> </scalar-parameter> </parameters> <data-sources> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7"> <list-property name="privateDriverProperties"> <ex-property> <name>contentBidiFormatStr</name> <value>ILYNN</value> </ex-property> <ex-property> <name>metadataBidiFormatStr</name> <value>ILYNN</value> </ex-property> </list-property> <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property> <property name="odaURL">jdbc:classicmodels:sampledb</property> <property name="odaUser">ClassicModels</property> </oda-data-source> </data-sources> <data-sets> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="setGetOrders" id="8"> <list-property name="columnHints"> <structure> <property name="columnName">ORDERNUMBER</property> <property name="analysis">measure</property> <text-property name="displayName">ORDERNUMBER</text-property> <text-property name="heading">ORDERNUMBER</text-property> </structure> <structure> <property name="columnName">ORDERDATE</property> <property name="analysis">dimension</property> <text-property name="displayName">ORDERDATE</text-property> <text-property name="heading">ORDERDATE</text-property> </structure> <structure> <property name="columnName">REQUIREDDATE</property> <property name="analysis">dimension</property> <text-property name="displayName">REQUIREDDATE</text-property> <text-property name="heading">REQUIREDDATE</text-property> </structure> <structure> <property name="columnName">SHIPPEDDATE</property> <property name="analysis">dimension</property> <text-property name="displayName">SHIPPEDDATE</text-property> <text-property name="heading">SHIPPEDDATE</text-property> </structure> <structure> <property name="columnName">STATUS</property> <property name="analysis">dimension</property> <text-property name="displayName">STATUS</text-property> <text-property name="heading">STATUS</text-property> </structure> <structure> <property name="columnName">COMMENTS</property> <property name="analysis">dimension</property> <text-property name="displayName">COMMENTS</text-property> <text-property name="heading">COMMENTS</text-property> </structure> <structure> <property name="columnName">CUSTOMERNUMBER</property> <property name="analysis">measure</property> <text-property name="displayName">CUSTOMERNUMBER</text-property> <text-property name="heading">CUSTOMERNUMBER</text-property> </structure> </list-property> <list-property name="parameters"> <structure> <property name="name">param_1</property> <property name="nativeName"></property> <property name="dataType">date</property> <property name="nativeDataType">91</property> <property name="position">1</property> <expression name="defaultValue" type="javascript">var parser = new Packages.java.text.SimpleDateFormat(vars["formatString"]);var dateValue = parser.parse( params["StartDateParameter"].value );dateValue;</expression> <property name="isOptional">true</property> <property name="allowNull">true</property> <property name="isInput">true</property> <property name="isOutput">false</property> </structure> <structure> <property name="name">param_2</property> <property name="nativeName"></property> <property name="dataType">date</property> <property name="nativeDataType">91</property> <property name="position">2</property> <expression name="defaultValue" type="javascript">var parser = new Packages.java.text.SimpleDateFormat(vars["formatString"]);var dateValue = parser.parse( params["EndDateParameter"].value );dateValue;</expression> <property name="isOptional">true</property> <property name="allowNull">true</property> <property name="isInput">true</property> <property name="isOutput">false</property> </structure> </list-property> <structure name="cachedMetaData"> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">ORDERNUMBER</property> <property name="dataType">integer</property> </structure> <structure> <property name="position">2</property> <property name="name">ORDERDATE</property> <property name="dataType">date</property> </structure> <structure> <property name="position">3</property> <property name="name">REQUIREDDATE</property> <property name="dataType">date</property> </structure> <structure> <property name="position">4</property> <property name="name">SHIPPEDDATE</property> <property name="dataType">date</property> </structure> <structure> <property name="position">5</property> <property name="name">STATUS</property> <property name="dataType">string</property> </structure> <structure> <property name="position">6</property> <property name="name">COMMENTS</property> <property name="dataType">string</property> </structure> <structure> <property name="position">7</property> <property name="name">CUSTOMERNUMBER</property> <property name="dataType">integer</property> </structure> </list-property> </structure> <property name="dataSource">Data Source</property> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">ORDERNUMBER</property> <property name="nativeName">ORDERNUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> <structure> <property name="position">2</property> <property name="name">ORDERDATE</property> <property name="nativeName">ORDERDATE</property> <property name="dataType">date</property> <property name="nativeDataType">91</property> </structure> <structure> <property name="position">3</property> <property name="name">REQUIREDDATE</property> <property name="nativeName">REQUIREDDATE</property> <property name="dataType">date</property> <property name="nativeDataType">91</property> </structure> <structure> <property name="position">4</property> <property name="name">SHIPPEDDATE</property> <property name="nativeName">SHIPPEDDATE</property> <property name="dataType">date</property> <property name="nativeDataType">91</property> </structure> <structure> <property name="position">5</property> <property name="name">STATUS</property> <property name="nativeName">STATUS</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">6</property> <property name="name">COMMENTS</property> <property name="nativeName">COMMENTS</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">7</property> <property name="name">CUSTOMERNUMBER</property> <property name="nativeName">CUSTOMERNUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> </list-property> <xml-property name="queryText"><![CDATA[select *from CLASSICMODELS.ORDERSwhere CLASSICMODELS.ORDERS.ORDERDATE between ? and ?]]></xml-property> <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?><model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel"> <Version>2.0</Version> <DataSetParameters> <parameter> <design:ParameterDefinition> <design:inOutMode>In</design:inOutMode> <design:attributes> <design:identifier> <design:name></design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:inputAttributes> <design:elementAttributes> <design:optional>true</design:optional> </design:elementAttributes> </design:inputAttributes> </design:ParameterDefinition> </parameter> <parameter> <design:ParameterDefinition> <design:inOutMode>In</design:inOutMode> <design:attributes> <design:identifier> <design:name></design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> </design:attributes> <design:inputAttributes> <design:elementAttributes> <design:optional>true</design:optional> </design:elementAttributes> </design:inputAttributes> </design:ParameterDefinition> </parameter> </DataSetParameters> <design:ResultSets derivedMetaData="true"> <design:resultSetDefinitions> <design:resultSetColumns> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>ORDERNUMBER</design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>ORDERNUMBER</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>ORDERNUMBER</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>ORDERDATE</design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>ORDERDATE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>ORDERDATE</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>REQUIREDDATE</design:name> <design:position>3</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>REQUIREDDATE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>REQUIREDDATE</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>SHIPPEDDATE</design:name> <design:position>4</design:position> </design:identifier> <design:nativeDataTypeCode>91</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>SHIPPEDDATE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>SHIPPEDDATE</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>STATUS</design:name> <design:position>5</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>15</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>STATUS</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>STATUS</design:label> <design:formattingHints> <design:displaySize>15</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>COMMENTS</design:name> <design:position>6</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>32700</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>COMMENTS</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>COMMENTS</design:label> <design:formattingHints> <design:displaySize>32700</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CUSTOMERNUMBER</design:name> <design:position>7</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CUSTOMERNUMBER</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CUSTOMERNUMBER</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> </design:resultSetColumns> <design:criteria/> </design:resultSetDefinitions> </design:ResultSets></model:DesignValues>]]></xml-property> </oda-data-set> </data-sets> <styles> <style name="report" id="4"> <property name="fontFamily">sans-serif</property> <property name="fontSize">10pt</property> </style> <style name="crosstab-cell" id="5"> <property name="borderBottomColor">#CCCCCC</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">1pt</property> <property name="borderLeftColor">#CCCCCC</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">1pt</property> <property name="borderRightColor">#CCCCCC</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">1pt</property> <property name="borderTopColor">#CCCCCC</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">1pt</property> </style> <style name="crosstab" id="6"> <property name="borderBottomColor">#CCCCCC</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">1pt</property> <property name="borderLeftColor">#CCCCCC</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">1pt</property> <property name="borderRightColor">#CCCCCC</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">1pt</property> <property name="borderTopColor">#CCCCCC</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">1pt</property> </style> </styles> <page-setup> <simple-master-page name="Simple MasterPage" id="2"> <page-footer> <text id="3"> <property name="contentType">html</property> <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> </text> </page-footer> </simple-master-page> </page-setup> <body> <grid id="58"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">thin</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">thin</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">thin</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">thin</property> <property name="width">7.947916666666667in</property> <list-property name="boundDataColumns"> <structure> <property name="name">startDate</property> <expression name="expression" type="javascript">var parser = new Packages.java.text.SimpleDateFormat(vars["formatString"]);var dateValue = parser.parse( params["StartDateParameter"].value );dateValue;</expression> <property name="dataType">date-time</property> <property name="allowExport">true</property> </structure> <structure> <property name="name">endDate</property> <expression name="expression" type="javascript">var parser = new Packages.java.text.SimpleDateFormat(vars["formatString"]);var dateValue = parser.parse( params["EndDateParameter"].value );dateValue;</expression> <property name="dataType">date-time</property> <property name="allowExport">true</property> </structure> </list-property> <column id="59"> <property name="width">1.0520833333333333in</property> <property name="fontWeight">bold</property> </column> <column id="60"> <property name="width">6.895833333333333in</property> </column> <row id="61"> <cell id="62"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <label id="67"> <text-property name="text">Start Date:</text-property> </label> </cell> <cell id="63"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <data id="69"> <structure name="dateTimeFormat"> <property name="category">Long Date</property> <property name="pattern">Long Date</property> </structure> <property name="resultSetColumn">startDate</property> </data> </cell> </row> <row id="64"> <cell id="65"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <label id="68"> <text-property name="text">End Date:</text-property> </label> </cell> <cell id="66"> <property name="borderBottomColor">#000000</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">medium</property> <property name="borderLeftColor">#000000</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">medium</property> <property name="borderRightColor">#000000</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">medium</property> <property name="borderTopColor">#000000</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">medium</property> <data id="70"> <structure name="dateTimeFormat"> <property name="category">Long Date</property> <property name="pattern">Long Date</property> </structure> <property name="resultSetColumn">endDate</property> </data> </cell> </row> </grid> <table id="11"> <property name="dataSet">setGetOrders</property> <list-property name="boundDataColumns"> <structure> <property name="name">ORDERNUMBER</property> <text-property name="displayName">ORDERNUMBER</text-property> <expression name="expression" type="javascript">dataSetRow["ORDERNUMBER"]</expression> <property name="dataType">integer</property> </structure> <structure> <property name="name">ORDERDATE</property> <text-property name="displayName">ORDERDATE</text-property> <expression name="expression" type="javascript">dataSetRow["ORDERDATE"]</expression> <property name="dataType">date</property> </structure> <structure> <property name="name">REQUIREDDATE</property> <text-property name="displayName">REQUIREDDATE</text-property> <expression name="expression" type="javascript">dataSetRow["REQUIREDDATE"]</expression> <property name="dataType">date</property> </structure> <structure> <property name="name">SHIPPEDDATE</property> <text-property name="displayName">SHIPPEDDATE</text-property> <expression name="expression" type="javascript">dataSetRow["SHIPPEDDATE"]</expression> <property name="dataType">date</property> </structure> <structure> <property name="name">STATUS</property> <text-property name="displayName">STATUS</text-property> <expression name="expression" type="javascript">dataSetRow["STATUS"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">COMMENTS</property> <text-property name="displayName">COMMENTS</text-property> <expression name="expression" type="javascript">dataSetRow["COMMENTS"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">CUSTOMERNUMBER</property> <text-property name="displayName">CUSTOMERNUMBER</text-property> <expression name="expression" type="javascript">dataSetRow["CUSTOMERNUMBER"]</expression> <property name="dataType">integer</property> </structure> </list-property> <column id="50"/> <column id="51"/> <column id="52"/> <column id="53"/> <column id="54"/> <column id="55"/> <column id="56"/> <header> <row id="12"> <cell id="13"> <label id="14"> <text-property name="text">ORDERNUMBER</text-property> </label> </cell> <cell id="15"> <label id="16"> <text-property name="text">ORDERDATE</text-property> </label> </cell> <cell id="17"> <label id="18"> <text-property name="text">REQUIREDDATE</text-property> </label> </cell> <cell id="19"> <label id="20"> <text-property name="text">SHIPPEDDATE</text-property> </label> </cell> <cell id="21"> <label id="22"> <text-property name="text">STATUS</text-property> </label> </cell> <cell id="23"> <label id="24"> <text-property name="text">COMMENTS</text-property> </label> </cell> <cell id="25"> <label id="26"> <text-property name="text">CUSTOMERNUMBER</text-property> </label> </cell> </row> </header> <detail> <row id="27"> <cell id="28"> <data id="29"> <property name="resultSetColumn">ORDERNUMBER</property> </data> </cell> <cell id="30"> <data id="31"> <property name="resultSetColumn">ORDERDATE</property> </data> </cell> <cell id="32"> <data id="33"> <property name="resultSetColumn">REQUIREDDATE</property> </data> </cell> <cell id="34"> <data id="35"> <property name="resultSetColumn">SHIPPEDDATE</property> </data> </cell> <cell id="36"> <data id="37"> <property name="resultSetColumn">STATUS</property> </data> </cell> <cell id="38"> <data id="39"> <property name="resultSetColumn">COMMENTS</property> </data> </cell> <cell id="40"> <data id="41"> <property name="resultSetColumn">CUSTOMERNUMBER</property> </data> </cell> </row> </detail> <footer> <row id="42"> <cell id="43"/> <cell id="44"/> <cell id="45"/> <cell id="46"/> <cell id="47"/> <cell id="48"/> <cell id="49"/> </row> </footer> </table> </body> <property name="pageVariables"> <variable-element name="formatString"> <expression name="value" type="javascript">"dd/MM/yyyy"</expression> <property name="type">report</property> </variable-element> </property></report></pre></div></blockquote><p>Hi John, thank you very very much for your time, I tried to do in my report what you did but it give me this error:</p><p>cant load the report query: 11 (11 is de id of the table in which I put all the results of the data set)</p><p>I dont know how to resolve that problem..</p><p>Thank you very much</p>