Home » Newcomers » Newcomers » One parameter, Multiple data sets(Help with parameters)
|
Re: One parameter, Multiple data sets [message #786908 is a reply to message #786904] |
Mon, 30 January 2012 23:49 |
|
On 2012.01.30 16:45, Mike Brandenburger wrote:
> 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!
You're right. You're probably in the wrong forum. There isn't enough
information on what you're trying to do even to refer you. Is this
merely a database question? Is it a BIRT question? Your question is
adequately specific, but there's insufficient information about its domain.
|
|
| |
Re: One parameter, Multiple data sets [message #787025 is a reply to message #786911] |
Tue, 31 January 2012 04:07 |
Mike Brandenburger Messages: 5 Registered: January 2012 |
Junior Member |
|
|
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 14:34 |
|
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).
|
|
| |
Goto Forum:
Current Time: Fri Apr 26 17:46:30 GMT 2024
Powered by FUDForum. Page generated in 0.08654 seconds
|