Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Getting values from other datasets/tables
Migrateduser
<p><span>Hello,<br />
<br />
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.<br />
<br />
<br />
DataSet1/Table 1<br />
Vendor , Description, VendorID, <strong class='bbc'>Purchase Limit</strong><br />
<br />
DataSet2/Table 2<br />
Vendor, Description, VendorID, <strong class='bbc'>Spent Amount</strong><br />
<br />
DataSet3/Table<br />
Vendor, Description,VendorID, <strong class='bbc'>Invoice Amount</strong><br />
<br />
I want to have a 4th table or insert a data binding that has a remaining balance of<br />
<strong class='bbc'>Purchase Limit</strong> - <strong class='bbc'>Spent Amount</strong> - <strong class='bbc'>Invoice Amount</strong> = Remaining Balance for Vendor<br />
<br />
I don't know how to get attributes from different tables, can anyone help, please?<br />
<br />
I have attached my design file. Any help would be greatly appreciated. I'm using BIRT 3.7.1</span></p>
Find more posts tagged with
Comments
There are no comments yet