Help Desk and PC Inventory Software by Gritware   Gritware Support Forums
Gritware Support Forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Canadianmade

Member
Registered:
Posts: 69
Reply with quote  #1 
When generating a software report, under the report filter I have 2 entries that contain RisaFloor and Risa-3d, when I run the report nothing shows because it is using a AND operator whereas I would like it to use a OR operator in the prefilter but I don't see a way to do this?

Capture.JPG 

thoese

Moderator
Registered:
Posts: 491
Reply with quote  #2 
Hi,

As you pointed out all the filters you see here are using the 'AND' operator.  Unfortunately there's not a way to change this to 'OR'.

Here are a few alternatives that might work...

1.
Use the contains operator and filter on what's common to both (RISA for example).  You could then choose to group the report by this field so that it breaks up the different variations that are returned.

If this method gets you close you could also add a 'NOT IN' filter so items that match that you don't want won't appear.

2.
Use the 'IN' operator and separate each value with a comma...
RISAFloor 8.0, Risa 3D 12.0


The only issue with this method is that the text has to be an exact match.

3.  The last way would be to write a custom SQL statement.  If you need help with this let me know what fields you want to display and I could get you the statement.

Thanks,

__________________
Todd @ Gritware
Other resources
Gritware.com
Knowledge Base
Web Tracks Help
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.