Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » Get totals from multiple datasets/tables(How to get information from multiple datasets/tables in report)
Get totals from multiple datasets/tables [message #1068054] Thu, 11 July 2013 20:47 Go to next message
Junior Martinez is currently offline Junior MartinezFriend
Messages: 8
Registered: May 2012
Junior Member
Hello,

I need help with my report. I have three datasets/tables in my report. Each dataset has an amount that I would like to do get and and put into a fourth table with for a remaining balance. So I will show an example below.


DataSet1/Table 1
Vendor , Description, VendorID, Purchase Limit

DataSet2/Table 2
Vendor, Description, VendorID, Spent Amount

DataSet3/Table
Vendor, Description,VendorID, Invoice Amount

I want to have a 4th table or insert a data binding that has a remaining balance of
Purchase Limit - Spent Amount - Invoice Amount = Remaining Balance for Vendor

I don't know how to get attributes from different tables, can anyone help, please?

I have attached my design file. Any help would be greatly appreciated.
Re: Get totals from multiple datasets/tables [message #1068058 is a reply to message #1068054] Thu, 11 July 2013 20:49 Go to previous message
Russell Bateman is currently offline Russell BatemanFriend
Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

On 7/11/2013 2:47 PM, Junior Martinez wrote:
> Hello,
>
> I need help with my report. I have three datasets/tables in my report. Each dataset has an amount that I would like to do get and and put into a fourth table with for a remaining balance. So I will show an example below.
>
>
> DataSet1/Table 1
> Vendor , Description, VendorID, Purchase Limit
>
> DataSet2/Table 2
> Vendor, Description, VendorID, Spent Amount
>
> DataSet3/Table
> Vendor, Description,VendorID, Invoice Amount
>
> I want to have a 4th table or insert a data binding that has a remaining balance of
> Purchase Limit - Spent Amount - Invoice Amount = Remaining Balance for Vendor
>
> I don't know how to get attributes from different tables, can anyone help, please?
>
> I have attached my design file. Any help would be greatly appreciated.
>

If by "report" you mean "BIRT", you should post in the dedicated Eclipse
BIRT forum.
Previous Topic:Constantly getting "Path must include project and resource name: /" with new Kepler worksp
Next Topic:Minimize does not minimize to a TrimStack anymore
Goto Forum:
  


Current Time: Thu Mar 28 12:05:35 GMT 2024

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

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

Back to the top