| One parameter, Multiple data sets [message #786904] |
Mon, 30 January 2012 18:45  |
Eclipse User |
|
|
|
Hello all,
Im not certain where to post my question, being new to the forum Im posting here. I have searched endlessly for a solution to my report needs without luck. I'm sure the answer is already on the forum but I may not be using the correct words when searching. Anyways here is goes...
I have a report with multiple data sets.
1. Payments
2. Log
3. DBase
The report has 3 tables, one for each data set. I have a parameter that I need to be used on all 3 tables. The parameter must point to a common column on all 3 datasets called FileNumber.
This report shows payments, note log entries and basic person info for one FileNumber.
How can I get the parameter to filter FileNumber on all 3 tables?
I appreciate any help in advance and I apologize if my posting location is wrong or this is already answered. If additional info is needed I certainly can reply with it.
Thanks again!
|
|
|
|
|
| Re: One parameter, Multiple data sets [message #787025 is a reply to message #786911] |
Mon, 30 January 2012 23:07  |
| Eclipse User |
|
|
|
Hey there here are the queries. 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!!!
|
|
|
| Re: One parameter, Multiple data sets [message #787395 is a reply to message #787025] |
Tue, 31 January 2012 09:34 |
| Eclipse User |
|
|
|
On 30-Jan-12 21:07, Mike Brandenburger wrote:
> Hey there here are the queries. 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!!!
Finally, the magic word: BIRT.
Now I can tell you that there is a separate Eclipse BIRT forum for you
to ask your questions (and likely, you'll only get help in that forum).
|
|
|
|
Powered by
FUDForum. Page generated in 0.25785 seconds
Home