Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » 1 Parameter box for Multiple Data Sets(Help with parameters in BIRT)
1 Parameter box for Multiple Data Sets [message #787717] Tue, 31 January 2012 17:32 Go to next message
Mike Brandenburger is currently offline Mike Brandenburger
Messages: 5
Registered: January 2012
Junior Member
Hello,

Currently I have 1 parameter setup for each of the 3 queries below so I get three questions for the same filenumber on the popup when the report is ran in BIRT. I'd like to combine the dataset queries below so the popup only has one field to input the filenumber rather than 3 =)

#DBase.......

SELECT dbase.fullname,
dbase.address,
dbase.address2,
dbase.city,
dbase.state,
dbase.zip,
dbase.primaryphone,
FROM dbase
WHERE dbase.filenumber = ?

#Payments....

SELECT payments.filenumber,
payments.paymentdate,
payments.paymentamount
FROM payments
WHERE payments.filenumber = ?

# Log...

SELECT log.filenumber,
log.logmessage,
log.logdate,
log.logtime
FROM log
WHERE log.filenumber = ?

Thanks in advance for your help!
Re: 1 Parameter box for Multiple Data Sets [message #789217 is a reply to message #787717] Thu, 02 February 2012 13:45 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Those are three dataset parameters. You should be able to link them all
to one report parameter. Edit the datasets and look at the data set
parameter editor. There is a field to link them to a report parameter.

Jason

On 1/31/2012 5:32 PM, Mike Brandenburger wrote:
> Hello,
>
> Currently I have 1 parameter setup for each of the 3 queries below so I
> get three questions for the same filenumber on the popup when the report
> is ran in BIRT. I'd like to combine the dataset queries below so the
> popup only has one field to input the filenumber rather than 3 =)
>
> #DBase.......
>
> SELECT dbase.fullname,
> dbase.address,
> dbase.address2,
> dbase.city,
> dbase.state,
> dbase.zip,
> dbase.primaryphone,
> FROM dbase
> WHERE dbase.filenumber = ?
>
> #Payments....
>
> SELECT payments.filenumber,
> payments.paymentdate,
> payments.paymentamount
> FROM payments
> WHERE payments.filenumber = ?
>
> # Log...
>
> SELECT log.filenumber,
> log.logmessage,
> log.logdate,
> log.logtime
> FROM log
> WHERE log.filenumber = ?
>
> Thanks in advance for your help!
Previous Topic:An error has occurred: Plateau Report Designer-Birt
Next Topic:NoClassDefFoundError when trying to develop custom ODA for Birt
Goto Forum:
  


Current Time: Thu Aug 21 06:11:58 EDT 2014

Powered by FUDForum. Page generated in 0.02807 seconds