Hi
I have created a new Crystal report showing all service calls. However I would like to restrict the output so it only shows all reports APART from closed reports. I am a SQL developer so know SQL very well and simply need somewhere I can insert: WHERE ixvServiceCall.status <> "Closed"
Where can I do this? I can see the database expert but no where I can edit the SQL governing the report. I can view something called "Show SQL Query" but this is not editable.
Thank you very much for any help.