For some reason this part of my select statement is not showing in the SQL query. Any ideas? Only the BI_CUR_HISTORY_SW="Y" value is making it to the criterea. BI_USAGE is not there
Selection formula:
If {?p_Annual_Budget_Billing_Accounts} = "Yes" Then //Annual Account ({BI_AR.BI_CONS_CLASS_CD} = "A") Else If {?p_Annual_Budget_Billing_Accounts} = "No" then //Exclude All Annual Accounts (But include B, or Balanced Billing Accounts). ({BI_AR.BI_CONS_CLASS_CD} <> "A"; //Usage History {BI_HIST_USAGE.BI_USAGE} = {?p_kwhUsage}; {BI_HISTORY.BI_CUR_HIST_SW} = "Y") //USE ONLY TO VERIFY GROSS NUMBER OF METERS / ACCOUNTS Else If {?p_Annual_Budget_Billing_Accounts} = "Both" then //Active Meters ({BI_MTR_INV.BI_MTR_STAT_CD} = 1)
SQL Where Clause:
WHERE "BI_TYPE_SERVICE"."BI_SRV_STAT_CD"=1 AND ("BI_HISTORY"."BI_REV_YRMO">=201107 AND "BI_HISTORY"."BI_REV_YRMO"<=201108) AND "BI_HISTORY"."BI_CUR_HIST_SW"='Y' ORDER BY "BI_AR"."BI_CONS_CLASS_CD" DESC, "BI_RDG"."BI_ACCT", "BI_MTR_INV"."BI_MTR_NBR", "BI_HIST_USAGE"."BI_REV_YRMO"