In my report, which is developed through SQL, I have several category codes of different categories. It is concatenated column for which I have taken a data item and concatenated category code and desc. I want to restrict it to some categories code to only few but filter is throwing up an error "sql prepare with" and parsing error. I gave expression like [data item] not in ('1','2',3'). Please Help.
You are concatenating the Code and Description but you are including the code in not in function. How it recognizes the Data Code only when it has description.
Use the Concertinaed Field value or Create one data item for code only and use that one in Filter area.
One More thing for report performance wise better to avoid the "Not in" operator when you are dealing with huge amount of data"
Check with your business scenario.
Best Regards,
Srinivas Kalyanapu