Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » One parameter, Multiple data sets(Help with parameters)
One parameter, Multiple data sets [message #786904] Mon, 30 January 2012 23:45 Go to next message
Mike Brandenburger is currently offline Mike BrandenburgerFriend
Messages: 5
Registered: January 2012
Junior Member
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 #786908 is a reply to message #786904] Mon, 30 January 2012 23:49 Go to previous messageGo to next message
Russell Bateman is currently offline Russell BatemanFriend
Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

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 #786911 is a reply to message #786908] Mon, 30 January 2012 23:56 Go to previous messageGo to next message
Mike Brandenburger is currently offline Mike BrandenburgerFriend
Messages: 5
Registered: January 2012
Junior Member
Thanks Russell!

Im building the report in...
Eclipse
Version: Indigo Release
Build ID: 20110615-0604
Re: One parameter, Multiple data sets [message #787025 is a reply to message #786911] Tue, 31 January 2012 04:07 Go to previous messageGo to next message
Mike Brandenburger is currently offline Mike BrandenburgerFriend
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 Go to previous messageGo to next message
Russell Bateman is currently offline Russell BatemanFriend
Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

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).
Re: One parameter, Multiple data sets [message #787712 is a reply to message #787395] Tue, 31 January 2012 22:25 Go to previous message
Mike Brandenburger is currently offline Mike BrandenburgerFriend
Messages: 5
Registered: January 2012
Junior Member
Ahhh I will search for that and post there thanks again!
Previous Topic:Apache Geronimo - Eclipse Indigo- JAXWS deployment problem
Next Topic:Install Issues
Goto Forum:
  


Current Time: Wed Jun 23 06:54:57 GMT 2021

Powered by FUDForum. Page generated in 0.03357 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top