report filter question

[hackware]

This is probably simple but I think I'm brain dead today. I modified one of the audit reports to show user logons for the past 7 days. It works fine. But now I want to narrow the results to certain users. I don't want to use a prompt since this will run weekly at midnight. Any ideas on a filter for this?

 

[YamaCog56]

If you are using CRN or Cognos 8, how about something like this:

[CRN Audit Reporting Model].[User Logins].[User name] in ('User Name1', 'User Name2', 'User Name3', 'User Name4', 'User Name5')

 

[hackware]

Thanks, I had tried that but it gives syntax or runtime errors.