Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Problem passing date as parameter
kidtorres
<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>
