I have a fairly basic report which needs to select all records from a file where a field is not equal to 2 specific values. when i try and run the report i get a failed top open rowset the code produced by crystal is :
not ({STOCK.STOCK_CAT} in [4, 40])
To change it to use a is one off would be a real pain as extra values are added on a regular basis.
Any ideas whats upsetting it cant I use in is not one of when using ODBC.
not ({STOCK.STOCK_CAT} in [4, 40])
To change it to use a is one off would be a real pain as extra values are added on a regular basis.
Any ideas whats upsetting it cant I use in is not one of when using ODBC.