|1 Parameter box for Multiple Data Sets [message #787717]
||Tue, 31 January 2012 17:32
| Mike Brandenburger
Registered: January 2012
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 =)
WHERE dbase.filenumber = ?
WHERE payments.filenumber = ?
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
| Jason Weathersby
Registered: July 2009
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.
On 1/31/2012 5:32 PM, Mike Brandenburger wrote:
> 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 =)
> SELECT dbase.fullname,
> FROM dbase
> WHERE dbase.filenumber = ?
> SELECT payments.filenumber,
> FROM payments
> WHERE payments.filenumber = ?
> # Log...
> SELECT log.filenumber,
> FROM log
> WHERE log.filenumber = ?
> Thanks in advance for your help!
Powered by FUDForum
. Page generated in 0.01844 seconds