Eclipse Community Forums: BIRT » inner tables and parameters from outer tables

Home » Archived » BIRT » inner tables and parameters from outer tables

inner tables and parameters from outer tables [message #245884]

Mon, 02 July 2007 09:26

Eclipse User

Hi!
I am testing BIRT2.2 and have some problems with
inner tables.
My inner table should take a report parameter from an outer table
(row["id_order_entry"])

It worked with 2.2M5, now it doesn't.

The error I get is the following:

--------------------------------------------
ReportDesign (id = 1):
- Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: No value specified for parameter 1.

odaconsumer.CannotExecuteStatement ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Cannot execute
the statement.
SQL statement does not return a ResultSet object.
SQL error #1: No value specified for parameter 1.
--------------------------------------------

It seems that no parameter is passed.

Could you please help me ?

Thank you in advance,
Nico

Re: inner tables and parameters from outer tables [message #245946 is a reply to message #245884]

Mon, 02 July 2007 10:53

Eclipse User

Originally posted by: jasonweathersby.alltel.net

Nico,

Take a look at this example:
http://wiki.eclipse.org/MasterDetailOneReport_%28BIRT%29

Jason

Nico wrote:
> Hi!
> I am testing BIRT2.2 and have some problems with
> inner tables.
> My inner table should take a report parameter from an outer table
> (row["id_order_entry"])
>
> It worked with 2.2M5, now it doesn't.
>
> The error I get is the following:
>
> --------------------------------------------
> ReportDesign (id = 1):
> - Cannot execute the statement.
> SQL statement does not return a ResultSet object.
> SQL error #1: No value specified for parameter 1.
>
> odaconsumer.CannotExecuteStatement ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: Cannot execute
> the statement.
> SQL statement does not return a ResultSet object.
> SQL error #1: No value specified for parameter 1.
> --------------------------------------------
>
> It seems that no parameter is passed.
>
> Could you please help me ?
>
> Thank you in advance,
> Nico

Re: inner tables and parameters from outer tables [message #246758 is a reply to message #245946]

Sun, 08 July 2007 04:36

Eclipse User

Originally posted by: aaa.aaa.it

Jason Weathersby ha scritto:
> Nico,
>
> Take a look at this example:
> http://wiki.eclipse.org/MasterDetailOneReport_%28BIRT%29
>
> Jason
>
> Nico wrote:
>> Hi!
>> I am testing BIRT2.2 and have some problems with
>> inner tables.
>> My inner table should take a report parameter from an outer table
>> (row["id_order_entry"])
>>
>> It worked with 2.2M5, now it doesn't.
>>
>> The error I get is the following:
>>
>> --------------------------------------------
>> ReportDesign (id = 1):
>> - Cannot execute the statement.
>> SQL statement does not return a ResultSet object.
>> SQL error #1: No value specified for parameter 1.
>>
>> odaconsumer.CannotExecuteStatement ( 1 time(s) )
>> detail : org.eclipse.birt.data.engine.core.DataException: Cannot
>> execute the statement.
>> SQL statement does not return a ResultSet object.
>> SQL error #1: No value specified for parameter 1.
>> --------------------------------------------
>>
>> It seems that no parameter is passed.
>>
>> Could you please help me ?
>>
>> Thank you in advance,
>> Nico

Hi!
I solved my problem.
I'd like the all the newsgroup to know that a parameter in query NOW
(with BIRT 2.2) requires (mandatory!!!) a default value (even if the
message in query section says that you SHOULD not leave an empty-value).

In that way the query is executed and then the correct parameter from
inner table is passed.
Now my reports work good like before :)

I hope that it helps.

Bye Nico

Previous Topic:	default values in cascading parameters broken
Next Topic:	Problem with ODA driver after upgrade to BIRT 2.2

Goto Forum:

-=] Back to Top [=-

Current Time: Mon May 12 08:44:08 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter