|Getting values from other datasets [message #1068061]
||Thu, 11 July 2013 21:06
| Junior Martinez
Registered: May 2012
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.
Vendor , Description, VendorID, Purchase Limit
Vendor, Description, VendorID, Spent Amount
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.
Powered by FUDForum
. Page generated in 0.02108 seconds