Query Engine Error

[tjbennett]

I have the following in a formula:

{Master_Data.cus_no} < "000000200000" and not({Master_Data.cus_no} in
["000000000200","000000000201","000000102304","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"])and{Master_Data.slspsn_no} <> "DMR" and
{Master_Data.state} 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"]


And get this error:

Failed to open a rowset.

Query Engine Error: DAO Error Code: 0xc00
Source: DAO Database
Description: Expression too complex.


If I remove the string of customer numbers it will run. Any ideas????

Thanks.

 

[tjbennett]

Forgot to mention, I'm running Crystal Reports 10.

 

[tjbennett]

Okay, so I removed the last 4 customer numbers out of the string and created a new "and not({Master_Data.cus_no} in " statement to include those 4 numbers and it works????

 

[Madawc]

Expression too complex

The answer is in what you posted - too much all together. Break it up into formula fields like

{Master_Data.state} in "WV", "VA", "VT", "RI", "PA", "NY", "NJ", "NH", "MA","MD", "ME", "DE", "CT"]

This would return 'True' or 'False'. You can use the test elsewhere by entering @DateState - or not @DateState in your case.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[tjbennett]

Thank you for the response Madawc. That makes sense.

 

[lbass]

I think you need parens to clarify whether the 'or' clause at the end should be considered alone or whether it belongs with some other elements of the query. In other words, do you mean for everything else to be considered "OR" the last line?

-LB