Report creator query filter multiple items

[DGRL]

Dear forum,

Since the report creator PDF file does not cover this issue I would like to ask your help.

Due to the different types of datasheets we have I need to use the query filter in report creator to filter out multiple items. We use the short description to filter items on.
What is the correct filter string for this? 

I tried 

<>'LEVEL GAUGE' <-- Valid but this is only 1 item.....

<>'LEVEL GAUGE' or <>'SAFETYR RELIEF VALVE' <-- INVALID 

<>'LEVEL GAUGE' and <>'SAFETYR RELIEF VALVE' <-- INVALID

<>'LEVEL GAUGE' <>'SAFETYR RELIEF VALVE' <-- gives error "eQryErSynUnbalPar"

<>'LEVEL GAUGE' 'SAFETYR RELIEF VALVE' <-- gives error "eQryErSynUnbalPar"

<>'LEVEL GAUGE','SAFETYR RELIEF VALVE' <-- gives error "eQryErSynUnbalPar"

If there is another field that can be used to filter out multiple items please let me know.

Regards

[AndyDavisCadline · Accepted solution]

Hi,

If you want to include values, the syntax is: (IN 'LEVEL GAUGE', 'SAFETY RELIEF VALVE' ) 

To exclude values, the syntax is: (NOT IN 'LEVEL GAUGE', 'SAFETY RELIEF VALVE' ) 

Regards,

Andy

[DGRL]

hi @AndyDavisCadline 

I tried that and it does not seems to work.
I will make a small screencast for you to see.
Please hold on will make it now.

[DGRL]

Dear @AndyDavisCadline 

I already found what I was doing wrong...
I forgot to apply the filter at INLINE instruments as well..

[dave.wolfe · Accepted solution]

I can't tell where you are setting up the filter, but my preference is to use the Filter String property in the Report Designer. To get there, select the Report (top level item) in the Report Explorer, and then open the Filter string property. It's much more powerful/easy to use than modifying the query, so you get a UI that takes care of formatting.

Similar syntax though:

[DGRL]

@dave.wolfe 

That is also a good solution. Either of them seems to work proper...

Thanks for pointing out