Skip to Main Content

table grand total

707781Oct 5 2009 — edited Oct 6 2009
hi, in physical layer, there are 4 physical tables.
they are:
region, area, city, value
their relationship:

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!