Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How do i proceed to create automatics parameters in DataSet ?
icon10.gif  How do i proceed to create automatics parameters in DataSet ? [message #693898] Thu, 07 July 2011 09:10 Go to next message
Fernando  is currently offline Fernando
Messages: 27
Registered: July 2011
Junior Member
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]

Report message to a 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 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1560
Registered: July 2009
Senior Member

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


Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
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 Go to previous messageGo to next message
Fernando  is currently offline Fernando
Messages: 27
Registered: July 2011
Junior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Fernando  is currently offline Fernando
Messages: 27
Registered: July 2011
Junior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Fernando  is currently offline Fernando
Messages: 27
Registered: July 2011
Junior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Fernando  is currently offline Fernando
Messages: 27
Registered: July 2011
Junior Member

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 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1560
Registered: July 2009
Senior Member

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


Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: (no subject) [message #696728 is a reply to message #695859] Thu, 14 July 2011 14:05 Go to previous message
Fernando  is currently offline Fernando
Messages: 27
Registered: July 2011
Junior Member
I posted the bug. Id 351693.

Thanks.
Previous Topic:Where to plugin new IDocArchiveReader
Next Topic:Top 3 report
Goto Forum:
  


Current Time: Sat Aug 23 13:31:36 EDT 2014

Powered by FUDForum. Page generated in 0.01979 seconds