Hi
Any ideas regarding this error
Am using cr8.5 with a visual foxpro db thru odbc driver but am getting the following error
Error [Microsoft][odbc visual foxpro driver] sql too many subqueries
This error only seems to occur when we use a formula field in cross tabs, is this a problem in cr 8.5. As soon as i withdraw the formula field from the report everything runs ok.
However the only other factor is the dictionary we use is quite complex and as many joins, could this be a factor. Is there a max number of joins that crystal can cope with ?
any ideas would be great
Any ideas regarding this error
Am using cr8.5 with a visual foxpro db thru odbc driver but am getting the following error
Error [Microsoft][odbc visual foxpro driver] sql too many subqueries
This error only seems to occur when we use a formula field in cross tabs, is this a problem in cr 8.5. As soon as i withdraw the formula field from the report everything runs ok.
However the only other factor is the dictionary we use is quite complex and as many joins, could this be a factor. Is there a max number of joins that crystal can cope with ?
any ideas would be great