1 of 1 people found this helpful
I'd not even attempt to do that in Query Designer, even crystal is going to struggle
Find an attribute on your user record that they all share so you can query against that.
Alternatively, put a boolean value (say called Include in Query Count) on the user object, backfill it to be false. Then set this value for the customers you want to query, and then you can select all incidents raised for these users.
I'd still need to go through each of the 300 or so users to select the checkbox though. It seems a bit counter productive when I have the list of names already
if i did it in SQL then I can create the WHERE part of the query by creating it in excel and pasting it in
Still seems excessive though