table grand total
707781Oct 5 2009 — edited Oct 6 2009
hi, in physical layer, there are 4 physical tables.
region, area, city, value
region 1:n area
area 1:n city
city 1:n value
in the Answer, if region and city are selected.
it gives the correct results.
the sql issued includes region.
the "grand total" (the grand total imagebutton on the menu bar) of the table is also enabled.
I found that the total result is not correct.
I fount that the sql issued does not include the region.
so it gives the wrong grand total result.
are there any settings to correct it?
thank you very much!