1 Parameter box for Multiple Data Sets [message #787717] |
Tue, 31 January 2012 22:32 |
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 18:45 |
|
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!
|
|
|
Powered by
FUDForum. Page generated in 0.02896 seconds