|Re: Calculates with 2 Data Sets [message #902861 is a reply to message #902553]
||Mon, 20 August 2012 18:32
| Jason Weathersby
Registered: July 2009
You could do something like:|
data set one table
in a table with ds 1 you could write a onCreate script for the data
filed that displays total sales.
do the same for the data set 2 total cost, but use a different variable
name, say TC.
Then below both tables add a data item (No binding needed) with the
You may want to get TC first and check for a 0 value.
On 8/18/2012 7:27 AM, JOSE LUIS wrote:
> I have a question.
> I have two databases one is access and other is MySql. I use information
> in tables and grid for each of these tables and using differents
> datasets, but when i want to create a DATA Cell with a result from 2
> datasets from i have a problem, I don't know what can i do?.
> My case is:
> DataSet1 = Only it has a row with a number. TOTALSALES = 1112
> DataSet2 = Only it has a row with a numbre. TOTALCOST = 345
> I want show the value --> TOTALSALES - TOTALCOST in a grid, but i don't
> know if this is possible or impossible. The DATA CELL i would like to
> name = BENEFITS
> BENEFITS = DataSet1.TOTALSALES - DataSet1.TOTALCOST BENEFITS = 1112 -
> 345 = 767
> (sorry for my english its no good)
Powered by FUDForum
. Page generated in 0.09724 seconds