The report allow user to enter country as parameter.
It group by country, fran, and imp to get field value:
tbl1.target, tbl2.sales
The problem I encounter is, if user enter parameter country = All, i need sum the tbl2.sales, this i manage to do.
But for tbl1.target, if user select "All" country, i need to select target WHERE tbl1.country='999', not sum.
The problem now is tbl2.country has 149,658,667.
While tbl1.country has 999,149,658,667
If all, tbl1.country = 999 while tbl2 sum sales for all country 149,658,667
My report selection formula now is:
if {?Country}="All" then
({tbl1.country} = '149' or {tbl1.country} = '658' or {tbl1.country} = '667') else
{tbl1.country} = {?country}
Any expert know how to select tbl1.target where tbl1.country='999' if user enter parameter "All"?
IP Logged
