Passing parameters from button click

simonmaskell

<p>Hi</p><p> </p><p>I have a report which loads up some summarised data into some bar charts using 5 datasets, the data is filtered using a date which at the moment is set today's date. What I want to be able to do is click a button to go back one day or forward one day. I am struggling to work out how to get a parameter from the click of a button into the datasets.</p><p> </p><p>Would anyone be able to point me in the right direction</p><p> </p><p>Thanks</p><p> </p><p>Simon</p>

kclark

<p>You can use two labels and set them as hyperlinks to a hidden parameter.  Then use a sql query like this</p><pre class="_prettyXprint">select *from paymentswhere paymentdate = ?</pre><p>Then in your forward one day link you can use</p><pre class="_prettyXprint">BirtDateTime.addDay(params["NewParameter"].value, 1);</pre><p>To move your report forward one day.  Or</p><pre class="_prettyXprint">BirtDateTime.addDay(params["NewParameter"].value, -1);</pre><p>To move backwards.</p><p> </p><p>Here's an example, sorry for the xml</p><pre class="_prettyXprint"><?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.3.0.v201306041519 Build &lt;4.3.0.v20130604-1520></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="NewParameter" id="9"> <property name="hidden">true</property> <property name="valueType">static</property> <property name="isRequired">false</property> <property name="dataType">date</property> <property name="distinct">true</property> <simple-property-list name="defaultValue"> <value type="constant">2013-07-02</value> </simple-property-list> <list-property name="selectionList"/> <property name="paramType">simple</property> <property name="concealValue">false</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="Data Set" id="8"> <list-property name="columnHints"> <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> <structure> <property name="columnName">CHECKNUMBER</property> <property name="analysis">dimension</property> <text-property name="displayName">CHECKNUMBER</text-property> <text-property name="heading">CHECKNUMBER</text-property> </structure> <structure> <property name="columnName">PAYMENTDATE</property> <property name="analysis">dimension</property> <text-property name="displayName">PAYMENTDATE</text-property> <text-property name="heading">PAYMENTDATE</text-property> </structure> <structure> <property name="columnName">AMOUNT</property> <property name="analysis">measure</property> <text-property name="displayName">AMOUNT</text-property> <text-property name="heading">AMOUNT</text-property> </structure> </list-property> <list-property name="parameters"> <structure> <property name="name">param_1</property> <property name="paramName">NewParameter</property> <property name="nativeName"></property> <property name="dataType">date</property> <property name="nativeDataType">91</property> <property name="position">1</property> <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">CUSTOMERNUMBER</property> <property name="dataType">integer</property> </structure> <structure> <property name="position">2</property> <property name="name">CHECKNUMBER</property> <property name="dataType">string</property> </structure> <structure> <property name="position">3</property> <property name="name">PAYMENTDATE</property> <property name="dataType">date</property> </structure> <structure> <property name="position">4</property> <property name="name">AMOUNT</property> <property name="dataType">float</property> </structure> </list-property> </structure> <property name="dataSource">Data Source</property> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">CUSTOMERNUMBER</property> <property name="nativeName">CUSTOMERNUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> <structure> <property name="position">2</property> <property name="name">CHECKNUMBER</property> <property name="nativeName">CHECKNUMBER</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">3</property> <property name="name">PAYMENTDATE</property> <property name="nativeName">PAYMENTDATE</property> <property name="dataType">date</property> <property name="nativeDataType">91</property> </structure> <structure> <property name="position">4</property> <property name="name">AMOUNT</property> <property name="nativeName">AMOUNT</property> <property name="dataType">float</property> <property name="nativeDataType">8</property> </structure> </list-property> <xml-property name="queryText"><![CDATA[select *from paymentswhere paymentdate = ?]]></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> </DataSetParameters> <design:ResultSets derivedMetaData="true"> <design:resultSetDefinitions> <design:resultSetColumns> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CUSTOMERNUMBER</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>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:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CHECKNUMBER</design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CHECKNUMBER</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CHECKNUMBER</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>PAYMENTDATE</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>PAYMENTDATE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>PAYMENTDATE</design:label> <design:formattingHints> <design:displaySize>10</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>AMOUNT</design:name> <design:position>4</design:position> </design:identifier> <design:nativeDataTypeCode>8</design:nativeDataTypeCode> <design:precision>15</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>AMOUNT</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>AMOUNT</design:label> <design:formattingHints> <design:displaySize>22</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> <data id="40"> <list-property name="boundDataColumns"> <structure> <property name="name">NewParameter</property> <expression name="expression" type="javascript">params["NewParameter"]</expression> <property name="dataType">date</property> </structure> </list-property> <property name="resultSetColumn">NewParameter</property> </data> <table id="10"> <property name="dataSet">Data Set</property> <list-property name="boundDataColumns"> <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> <structure> <property name="name">CHECKNUMBER</property> <text-property name="displayName">CHECKNUMBER</text-property> <expression name="expression" type="javascript">dataSetRow["CHECKNUMBER"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">PAYMENTDATE</property> <text-property name="displayName">PAYMENTDATE</text-property> <expression name="expression" type="javascript">dataSetRow["PAYMENTDATE"]</expression> <property name="dataType">date</property> </structure> <structure> <property name="name">AMOUNT</property> <text-property name="displayName">AMOUNT</text-property> <expression name="expression" type="javascript">dataSetRow["AMOUNT"]</expression> <property name="dataType">float</property> </structure> </list-property> <column id="34"/> <column id="35"/> <column id="36"/> <column id="37"/> <header> <row id="11"> <cell id="12"> <label id="13"> <text-property name="text">CUSTOMERNUMBER</text-property> </label> </cell> <cell id="14"> <label id="15"> <text-property name="text">CHECKNUMBER</text-property> </label> </cell> <cell id="16"> <label id="17"> <text-property name="text">PAYMENTDATE</text-property> </label> </cell> <cell id="18"> <label id="19"> <text-property name="text">AMOUNT</text-property> </label> </cell> </row> </header> <detail> <row id="20"> <cell id="21"> <data id="22"> <property name="resultSetColumn">CUSTOMERNUMBER</property> </data> </cell> <cell id="23"> <data id="24"> <property name="resultSetColumn">CHECKNUMBER</property> </data> </cell> <cell id="25"> <data id="26"> <property name="resultSetColumn">PAYMENTDATE</property> </data> </cell> <cell id="27"> <data id="28"> <property name="resultSetColumn">AMOUNT</property> </data> </cell> </row> </detail> <footer> <row id="29"> <cell id="30"> <label id="38"> <text-property name="text">&lt;&lt;</text-property> <list-property name="action"> <structure> <property name="linkType">drill-through</property> <property name="reportName">new_report_53.rptdesign</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">NewParameter</property> <simple-property-list name="expression"> <value type="javascript">BirtDateTime.addDay(params["NewParameter"].value, -1);</value> </simple-property-list> </structure> </list-property> </structure> </list-property> </label> </cell> <cell id="31"/> <cell id="32"/> <cell id="33"> <label id="39"> <text-property name="text">>></text-property> <list-property name="action"> <structure> <property name="linkType">drill-through</property> <property name="reportName">new_report_53.rptdesign</property> <property name="targetWindow">_self</property> <property name="targetFileType">report-design</property> <list-property name="paramBindings"> <structure> <property name="paramName">NewParameter</property> <simple-property-list name="expression"> <value type="javascript">BirtDateTime.addDay(params["NewParameter"].value, 1);</value> </simple-property-list> </structure> </list-property> </structure> </list-property> </label> </cell> </row> </footer> </table> </body></report></pre>