I am trying to write a report with a formula that used to work. I now get the "Expression too complex" error.
Here is the code:
({Master_Data.StateCode} in ["WV", "VA", "VT", "RI", "PA", "NY", "NJ", "NH",
"MA","MD", "ME", "DE", "CT"]
or {Master_Data.cus_no} in ["000000100827","000000101999","000000102231",
"000000101709","000000000101", "000000102436",
"000000101900", "000000101213", "000000101712"]) and
(not({Master_Data.cus_no} in ["000000000200","000000000201","000000102304",
"000000101518",
"000000100033","000000101440","000000101737","000000101485","000000101855",
"000000189999","000000101736","000000101127",
"000000100855","000000100021","000000101231","000000101340","000000100149",
"000000100663","000000100671","000000100311",
"000000102221","000000100880","000000101427","000000101992","000000102219",
"000000101338","000000101849","000000100697",
"000000100322","000000100787","000000100693","000000176543","000000101985",
"000000101326","000000102151","000000101837",
"000000102956","000000100539","000000101886","000000101476","000000101943",
"000000100793","000000101549","000000101830",
"000000101121","000000100885","000000101218","000000102292","000000100688",
"000000100998","000000107643","000000101921",
"000000101795","000000100840","000000101304","000000102129","000000100277",
"000000101213","000000101712","000000101053",
"000000101900","000000100063","000000100865","000000101655","000000101594",
"000000101235","000000101007","000000100501",
"000000101110","000000101262","000000100891","000000101287","000000102123",
"000000101277","000000100912","000000101236",
"000000101063","000000100299","000000101536","000000100938","000000101418",
"000000100921","000000101016","000000101329",
"000000101847","000000100215","000000102718","000000102230","000000102556",
"000000100332","000000101483","000000104044",
"000000100967","000000101749","000000100700","000000100279", "000000100081",
"000000101518", "000000000102"])
or {Master_Data.slspsn_no} <> "DMR")
Thanks in advance.
Edited by tjbennett - 09 Sep 2010 at 8:29am