We have a query that is primarily filtered by GACTX.USER, so that the user who is logged in can see only their orders on this query. However, for some users I would like them to be able to see the entire report. I was wondering if there was a way to filter the report on something like current user OR functional profile = "CSADMIN"
Any ideas? My hope is to avoid having to author and maintain two different versions of the same report.
