Skip to main content



      Home
Home » Archived » BIRT » Jason, can you help me?
Jason, can you help me? [message #184601] Mon, 14 August 2006 09:13 Go to next message
Eclipse UserFriend
If it is possible take a look to "Dataset - Property Binding and
Dynamic parameter" post. It is very important to me this simple issue to
be resolved.

Thanks in advance.

Mauro
Re: Jason, can you help me? [message #184618 is a reply to message #184601] Mon, 14 August 2006 10:09 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: raison.fermat.eu

This is a multi-part message in MIME format.
--------------000704050000040904070006
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello Mauro,
Maybe i don't understand the problem, but why don't you use a parameter in your select instead of params expression ?
Something like the report I post.

The only thing is that the parameter can't be hidden.
I tried to put it manually hidden but noway.

And if the parameter is not a cascading one, the dataset of the second parameter is not reparsed.

I searched for
Mauro R. Ubeda wrote:
> If it is possible take a look to "Dataset - Property Binding and
> Dynamic parameter" post. It is very important to me this simple issue to
> be resolved.
>
> Thanks in advance.
>
> Mauro


--------------000704050000040904070006
Content-Type: text/xml;
name="mauro.rptdesign"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="mauro.rptdesign"

<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.2" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.1.0.N20060628-1351 Build &lt;20060628-1537></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 &lt;&lt;Your Company Name here>></property>
<parameters>
<scalar-parameter name="Country" id="107">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="concealValue">true</property>
<property name="allowBlank">false</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Customer" id="108">
<property name="valueType">dynamic</property>
<property name="dataType">decimal</property>
<property name="allowBlank">false</property>
<property name="controlType">list-box</property>
<property name="dataSetName">customers</property>
<expression name="valueExpr">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="mustMatch">false</property>
<property name="fixedOrder">true</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">Data Source</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>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="country" id="7">
<text-property name="displayName">country</text-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<property name="queryText">select distinct CLASSICMODELS.CUSTOMERS.COUNTRY
from CLASSICMODELS.CUSTOMERS</property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="customers" id="13">
<text-property name="displayName">customers</text-property>
<list-property name="parameters">
<structure>
<property name="name">param1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
<property name="position">1</property>
<expression name="defaultValue">params["Country"]</expression>
<property name="isInput">true</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">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<property name="queryText">select *
from customers
where country = ?</property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="payments" id="64">
<text-property name="displayName">payments</text-property>
<list-property name="parameters">
<structure>
<property name="name">param1</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
<property name="position">1</property>
<expression name="defaultValue">params["Customer"]</expression>
<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-time</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>
<property name="queryText">select *
from CLASSICMODELS.PAYMENTS
where CLASSICMODELS.PAYMENTS.CUSTOMERNUMBER = ?</property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Data Set" id="93">
<text-property name="displayName">Data Set</text-property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CUSTOMERNUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CUSTOMERNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</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">CUSTOMERNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">CONTACTLASTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">CONTACTFIRSTNAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">PHONE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">ADDRESSLINE1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ADDRESSLINE2</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">CITY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">STATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">POSTALCODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">COUNTRY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">SALESREPEMPLOYEENUMBER</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">CREDITLIMIT</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<property name="queryText">select distinct c.*
from CLASSICMODELS.CUSTOMERS as c
, CLASSICMODELS.PAYMENTS as p
where c.CUSTOMERNUMBER = p.CUSTOMERNUMBER
and c.country='Australia'</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="65">
<property name="width">100%</property>
<property name="dataSet">payments</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">CHECKNUMBER</property>
<expression name="expression">dataSetRow["CHECKNUMBER"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PAYMENTDATE</property>
<expression name="expression">dataSetRow["PAYMENTDATE"]</expression >
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">AMOUNT</property>
<expression name="expression">dataSetRow["AMOUNT"]</expression>
<property name="dataType">float</property>
</structure>
</list-property>
<column id="89"/>
<column id="90"/>
<column id="91"/>
<column id="92"/>
<header>
<row id="66">
<cell id="67">
<label id="68">
<text-property name="text">CUSTOMERNUMBER</text-property>
</label>
</cell>
<cell id="69">
<label id="70">
<text-property name="text">CHECKNUMBER</text-property>
</label>
</cell>
<cell id="71">
<label id="72">
<text-property name="text">PAYMENTDATE</text-property>
</label>
</cell>
<cell id="73">
<label id="74">
<text-property name="text">AMOUNT</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="75">
<cell id="76">
<data id="77">
<property name="resultSetColumn">CUSTOMERNUMBER</property>
</data>
</cell>
<cell id="78">
<data id="79">
<property name="resultSetColumn">CHECKNUMBER</property>
</data>
</cell>
<cell id="80">
<data id="81">
<property name="resultSetColumn">PAYMENTDATE</property>
</data>
</cell>
<cell id="82">
<data id="83">
<property name="resultSetColumn">AMOUNT</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="84">
<cell id="85"/>
<cell id="86"/>
<cell id="87"/>
<cell id="88"/>
</row>
</footer>
</table>
</body>
</report>

--------------000704050000040904070006--
Re: Jason, can you help me? [message #184634 is a reply to message #184618] Mon, 14 August 2006 10:49 Go to previous messageGo to next message
Eclipse UserFriend
Hi Raison, first thank you for your help.
The problem is that when i set COUNTRY param ( no cascading parameter)
(via URL or in the parameter selection window), the CUSTOMER list box
remains empty.
I want to filter a report by country (setting it ONLY via URL) and
only show in a list box parameter all costumers filtered by country (it
is a dynamic list box parameter).

I had test all combinations, setting the dataset via:

1. Select customernumber ... where country = ?
2. Via beforeOpen() replacing the same query but using "where country
= params["country"]"
3. Idem 2 but using Parameter binding on the data set.

In all case List box remains empty wherever i do to list them.
It seems that Parameter components are filled before the data set query
is replaced by beforeOpen() or Parameter binding.

So, if this is the problem, the only tip i want to know i how to refresh
parameters components (combo box, list box, etc).

You can find the example in the original post.



Thanks again!
Mauro



Raison escribió:
> Hello Mauro,
> Maybe i don't understand the problem, but why don't you use a parameter
> in your select instead of params expression ?
> Something like the report I post.
>
> The only thing is that the parameter can't be hidden.
> I tried to put it manually hidden but noway.
>
> And if the parameter is not a cascading one, the dataset of the second
> parameter is not reparsed.
>
> I searched for
> Mauro R. Ubeda wrote:
>> If it is possible take a look to "Dataset - Property Binding and
>> Dynamic parameter" post. It is very important to me this simple issue
>> to be resolved.
>>
>> Thanks in advance.
>>
>> Mauro
>
Re: Jason, can you help me? [message #184679 is a reply to message #184601] Mon, 14 August 2006 12:04 Go to previous messageGo to next message
Eclipse UserFriend
Response below.

Jason
"Mauro R. Ubeda" <ubeda@delsatgroup.com> wrote in message
news:ebpsp8$g83$1@utils.eclipse.org...
> If it is possible take a look to "Dataset - Property Binding and Dynamic
> parameter" post. It is very important to me this simple issue to be
> resolved.
>
> Thanks in advance.
>
> Mauro
Re: Jason, can you help me? [message #184715 is a reply to message #184679] Mon, 14 August 2006 12:35 Go to previous message
Eclipse UserFriend
Thanks Jason, but still not working. See my answer in the original post.


Jason Weathersby escribió:
> Response below.
>
> Jason
> "Mauro R. Ubeda" <ubeda@delsatgroup.com> wrote in message
> news:ebpsp8$g83$1@utils.eclipse.org...
>> If it is possible take a look to "Dataset - Property Binding and Dynamic
>> parameter" post. It is very important to me this simple issue to be
>> resolved.
>>
>> Thanks in advance.
>>
>> Mauro
>
>
Previous Topic:where clause for parameter with blank value
Next Topic:Multipage PDF with subreport
Goto Forum:
  


Current Time: Fri Jul 04 04:57:51 EDT 2025

Powered by FUDForum. Page generated in 0.04404 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top