Eclipse Community Forums: BIRT » expression builder in birt

Home » Archived » BIRT » expression builder in birt

expression builder in birt [message #207210]

Tue, 19 December 2006 01:20

Eclipse User

is that anyone can show me how to use the "report parameter" in the
expression builder for a data?

how can i write the expression with the report parameter?

thanks.

Re: expression builder in birt [message #207352 is a reply to message #207210]

Tue, 19 December 2006 10:47

Eclipse User

If you just want to display it use
params["ParameterName"] as the expression.

Jason

"70" <klhuang@shinyang.com.my> wrote in message
news:45285403ac257ee3eedcd3c5430a1a39$1@www.eclipse.org...
> is that anyone can show me how to use the "report parameter" in the
> expression builder for a data?
>
> how can i write the expression with the report parameter?
>
> thanks.
>

Re: expression builder in birt [message #207463 is a reply to message #207352]

Tue, 19 December 2006 19:08

Eclipse User

how can i write the script if i wish to use the report parameter as a
filter for my report?

Re: expression builder in birt [message #207732 is a reply to message #207463]

Wed, 20 December 2006 12:37

Eclipse User

Here is an example that filters the dataset based on a parameter.

Jason

<?xml version="1.0" encoding="UTF-8"?>



<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">

<property name="createdBy">Eclipse BIRT Designer Version
2.1.1.v20060922-1058 Build <20060926-0959></property>

<property name="units">in</property>

<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>

<parameters>

<scalar-parameter name="ProdCode" id="6">

<property name="valueType">dynamic</property>

<property name="dataType">string</property>

<property name="controlType">list-box</property>

<property name="dataSetName">prodcd</property>

<expression name="valueExpr">dataSetRow["PRODUCTCODE"]</expression>

<property name="mustMatch">false</property>

<property name="defaultValue">S18_1749</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="4">

<text-property name="displayName"></text-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>

<encrypted-property name="odaPassword"></encrypted-property>

</oda-data-source>

</data-sources>

<data-sets>

<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Data Set" id="5">

<list-property name="filter">

<structure>

<property name="operator">eq</property>

<expression name="expr">row["PRODUCTCODE"]</expression>

<expression name="value1">params["ProdCode"]</expression>

</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">PRODUCTCODE</property>

<property name="dataType">string</property>

</structure>

<structure>

<property name="position">3</property>

<property name="name">QUANTITYORDERED</property>

<property name="dataType">integer</property>

</structure>

<structure>

<property name="position">4</property>

<property name="name">PRICEEACH</property>

<property name="dataType">float</property>

</structure>

<structure>

<property name="position">5</property>

<property name="name">ORDERLINENUMBER</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">PRODUCTCODE</property>

<property name="nativeName">PRODUCTCODE</property>

<property name="dataType">string</property>

<property name="nativeDataType">12</property>

</structure>

<structure>

<property name="position">3</property>

<property name="name">QUANTITYORDERED</property>

<property name="nativeName">QUANTITYORDERED</property>

<property name="dataType">integer</property>

<property name="nativeDataType">4</property>

</structure>

<structure>

<property name="position">4</property>

<property name="name">PRICEEACH</property>

<property name="nativeName">PRICEEACH</property>

<property name="dataType">float</property>

<property name="nativeDataType">8</property>

</structure>

<structure>

<property name="position">5</property>

<property name="name">ORDERLINENUMBER</property>

<property name="nativeName">ORDERLINENUMBER</property>

<property name="dataType">integer</property>

<property name="nativeDataType">5</property>

</structure>

</list-property>

<property name="queryText">select *

from orderdetails</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>1.0</Version>

<design:ResultSets derivedMetaData="true">

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ORDERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</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:name>PRODUCTCODE</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>PRODUCTCODE</design:label>

<design:formattingHints>

<design:displaySize>15</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>QUANTITYORDERED</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

<design:precision>10</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>QUANTITYORDERED</design:label>

<design:formattingHints>

<design:displaySize>11</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PRICEEACH</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>PRICEEACH</design:label>

<design:formattingHints>

<design:displaySize>22</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ORDERLINENUMBER</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>5</design:nativeDataTypeCode>

<design:precision>5</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>ORDERLINENUMBER</design:label>

<design:formattingHints>

<design:displaySize>6</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ORDERNUMBER</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PRODUCTCODE</design:name>

<design:position>2</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>QUANTITYORDERED</design:name>

<design:position>3</design:position>

<design:nativeDataTypeCode>4</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PRICEEACH</design:name>

<design:position>4</design:position>

<design:nativeDataTypeCode>8</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>ORDERLINENUMBER</design:name>

<design:position>5</design:position>

<design:nativeDataTypeCode>5</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

</design:ResultSets>

</model:DesignValues>]]></xml-property>

</oda-data-set>

<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="prodcd" id="41">

<structure name="cachedMetaData">

<list-property name="resultSet">

<structure>

<property name="position">1</property>

<property name="name">PRODUCTCODE</property>

<property name="dataType">string</property>

</structure>

</list-property>

</structure>

<property name="dataSource">Data Source</property>

<list-property name="resultSet">

<structure>

<property name="position">1</property>

<property name="name">PRODUCTCODE</property>

<property name="nativeName">PRODUCTCODE</property>

<property name="dataType">string</property>

<property name="nativeDataType">12</property>

</structure>

</list-property>

<property name="queryText">select CLASSICMODELS.PRODUCTS.PRODUCTCODE

from products</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>1.0</Version>

<design:ResultSets derivedMetaData="true">

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PRODUCTCODE</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

<design:precision>15</design:precision>

<design:scale>0</design:scale>

<design:nullability>Nullable</design:nullability>

</design:attributes>

<design:usageHints>

<design:label>PRODUCTCODE</design:label>

<design:formattingHints>

<design:displaySize>15</design:displaySize>

</design:formattingHints>

</design:usageHints>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

<design:resultSetDefinitions>

<design:resultSetColumns>

<design:resultColumnDefinitions>

<design:attributes>

<design:name>PRODUCTCODE</design:name>

<design:position>1</design:position>

<design:nativeDataTypeCode>12</design:nativeDataTypeCode>

</design:attributes>

</design:resultColumnDefinitions>

</design:resultSetColumns>

</design:resultSetDefinitions>

</design:ResultSets>

</model:DesignValues>]]></xml-property>

</oda-data-set>

</data-sets>

<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>

<table id="7">

<property name="width">100%</property>

<property name="dataSet">Data Set</property>

<list-property name="boundDataColumns">

<structure>

<property name="name">ORDERNUMBER</property>

<expression name="expression">dataSetRow["ORDERNUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">PRODUCTCODE</property>

<expression name="expression">dataSetRow["PRODUCTCODE"]</expression >

<property name="dataType">string</property>

</structure>

<structure>

<property name="name">QUANTITYORDERED</property>

<expression name="expression">dataSetRow["QUANTITYORDERED"]</expression >

<property name="dataType">integer</property>

</structure>

<structure>

<property name="name">PRICEEACH</property>

<expression name="expression">dataSetRow["PRICEEACH"]</expression>

<property name="dataType">float</property>

</structure>

<structure>

<property name="name">ORDERLINENUMBER</property>

<expression name="expression">dataSetRow["ORDERLINENUMBER"]</expression >

<property name="dataType">integer</property>

</structure>

</list-property>

<column id="36"/>

<column id="37"/>

<column id="38"/>

<column id="39"/>

<column id="40"/>

<header>

<row id="8">

<cell id="9">

<label id="10">

<text-property name="text">ORDERNUMBER</text-property>

</label>

</cell>

<cell id="11">

<label id="12">

<text-property name="text">PRODUCTCODE</text-property>

</label>

</cell>

<cell id="13">

<label id="14">

<text-property name="text">QUANTITYORDERED</text-property>

</label>

</cell>

<cell id="15">

<label id="16">

<text-property name="text">PRICEEACH</text-property>

</label>

</cell>

<cell id="17">

<label id="18">

<text-property name="text">ORDERLINENUMBER</text-property>

</label>

</cell>

</row>

</header>

<detail>

<row id="19">

<cell id="20">

<data id="21">

<property name="resultSetColumn">ORDERNUMBER</property>

</data>

</cell>

<cell id="22">

<data id="23">

<property name="resultSetColumn">PRODUCTCODE</property>

</data>

</cell>

<cell id="24">

<data id="25">

<property name="resultSetColumn">QUANTITYORDERED</property>

</data>

</cell>

<cell id="26">

<data id="27">

<property name="resultSetColumn">PRICEEACH</property>

</data>

</cell>

<cell id="28">

<data id="29">

<property name="resultSetColumn">ORDERLINENUMBER</property>

</data>

</cell>

</row>

</detail>

<footer>

<row id="30">

<cell id="31"/>

<cell id="32"/>

<cell id="33"/>

<cell id="34"/>

<cell id="35"/>

</row>

</footer>

</table>

</body>

</report>

"70" <klhuang@shinyang.com.my> wrote in message
news:278991d756c9dd414a8c60541e83b52d$1@www.eclipse.org...
> how can i write the script if i wish to use the report parameter as a
> filter for my report?
>

Re: expression builder in birt [message #207905 is a reply to message #207732]

Wed, 20 December 2006 19:39

Eclipse User

okay jason....thanks a lot... ^o^

Previous Topic:	Maximum Data Set Size for BIRT?
Next Topic:	Page Totals Possible?

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 16 20:55:52 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter