Get totals from multiple datasets/tables [message #1068054] |
Thu, 11 July 2013 20:47 |
Junior Martinez 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 |
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.08172 seconds