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

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

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.

Report message to a moderator

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

Jason Weathersby

BIRT Exchange

Report message to a moderator

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.

Report message to a moderator

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.

Jason Weathersby

BIRT Exchange

Report message to a moderator

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.

Report message to a moderator

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

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Report message to a moderator

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

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 10:38:48 EDT 2013

Powered by FUDForum. Page generated in 0.02138 seconds