Eclipse Community Forums: BIRT » How do i proceed to create automatics parameters in DataSet ?

Home

Home » Archived » BIRT » How do i proceed to create automatics parameters in DataSet ?

How do i proceed to create automatics parameters in DataSet ? [message #693898]

Thu, 07 July 2011 09:10

Eclipse User

Is it possible the BIRT manage the parameters of the DataSet according to the query parameters, creating these parameters automatically in DataSet?

Regards

[Updated on: Thu, 07 July 2011 10:37] by Moderator

Re: How do i proceed to create automatics parameters in DataSet ? [message #694012 is a reply to message #693898]

Thu, 07 July 2011 12:13

Eclipse User

Can you explain more about what you mean? To create a dataSet parameter in your query, you simply use a '?' as a marker. BIRT automatically creates a dataSet parameter for this under the parameters tab of the dataSet editor. From here, you can either enter a value for the parameter or link it to a report parameter for input by a user or external application. Let me know if this doesn't help.

Regards,

Michael
BIRT Evangelist on
http://www.birt-exchange.org

Re: How do i proceed to create automatics parameters in DataSet ? [message #694334 is a reply to message #694012]

Fri, 08 July 2011 07:03

Eclipse User

I would like the BIRT once I insert the query already with parameters,
the BIRT take these parameters and create these parameters in dataSet,
in sequence correct, after would link in the parameters of report manually.

Regards.

(no subject) [message #694446 is a reply to message #694334]

Fri, 08 July 2011 11:41

Eclipse User

Like Michael said the data set parameters are created automatically.
For example create a new datasource against the sample db. Create a new
dataset with the following query:

select * from orderdetails where ordernumber = ?

This will automatically create a dataset parameter. You can link this
dataset parameter to a report parameter by editing the dataset and
selecting the parameters tab.

Jason

On 7/8/2011 7:03 AM, Fernando wrote:
> I would like the BIRT once I insert the query already with parameters,
> the BIRT take these parameters and create these parameters in dataSet,
> in sequence correct, after would link in the parameters of report manually.
>
>
> Regards.

Re: (no subject) [message #694510 is a reply to message #694446]

Fri, 08 July 2011 14:19

Eclipse User

In sample db all right, but in the connection with oracle.jdbc does not work.
What can I do to solve ?

Regards.

Re: (no subject) [message #694524 is a reply to message #694510]

Fri, 08 July 2011 14:57

Eclipse User

This should work with oracle as well. Are you using the textual jdbc
dataset?

Jason

On 7/8/2011 2:19 PM, Fernando wrote:
> In sample db all right, but in the connection with oracle.jdbc does not
> work.
> What can I do to solve ?
>
>
> Regards.

Re: (no subject) [message #694563 is a reply to message #694524]

Fri, 08 July 2011 16:47

Eclipse User

Yes, i am using the textual jdbc dataset.

Jason Weathersby wrote on Fri, 08 July 2011 14:57

This should work with oracle as well. Are you using the textual jdbc
dataset?

Jason

On 7/8/2011 2:19 PM, Fernando wrote:
> In sample db all right, but in the connection with oracle.jdbc does not
> work.
> What can I do to solve ?
>
>
> Regards.

Re: (no subject) [message #694568 is a reply to message #694563]

Fri, 08 July 2011 17:03

Eclipse User

Can you open a bugzilla entry?

Jason

On 7/8/2011 4:47 PM, Fernando wrote:
> Yes, i am using the textual jdbc dataset.
>
>
>
>
> Jason Weathersby wrote on Fri, 08 July 2011 14:57
>> This should work with oracle as well. Are you using the textual jdbc
>> dataset?
>>
>> Jason
>>
>> On 7/8/2011 2:19 PM, Fernando wrote:
>> > In sample db all right, but in the connection with oracle.jdbc does not
>> > work.
>> > What can I do to solve ?
>> >
>> >
>> > Regards.
>
>

Re: (no subject) [message #695693 is a reply to message #694568]

Tue, 12 July 2011 06:38

Eclipse User

Yes, I can open a bugzilla entry.

Fernando

Jason Weathersby wrote on Fri, 08 July 2011 17:03

Can you open a bugzilla entry?

Jason

On 7/8/2011 4:47 PM, Fernando wrote:
> Yes, i am using the textual jdbc dataset.
>
>
>
>
> Jason Weathersby wrote on Fri, 08 July 2011 14:57
>> This should work with oracle as well. Are you using the textual jdbc
>> dataset?
>>
>> Jason
>>
>> On 7/8/2011 2:19 PM, Fernando wrote:
>> > In sample db all right, but in the connection with oracle.jdbc does not
>> > work.
>> > What can I do to solve ?
>> >
>> >
>> > Regards.
>
>

Re: (no subject) [message #695859 is a reply to message #695693]

Tue, 12 July 2011 12:50

Eclipse User

If you can post the bug info in here after you log it, it could be helpful to others who stumble across this thread with the same issue.

Thanks!

Michael

Re: (no subject) [message #696728 is a reply to message #695859]

Thu, 14 July 2011 14:05

Eclipse User

I posted the bug. Id 351693.

Thanks.

Previous Topic:	Where to plugin new IDocArchiveReader
Next Topic:	Top 3 report

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 15:44:59 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter