Skip to Content
0
Former Member
Jun 25, 2009 at 03:22 PM

Crystal - where to add SQL to control what is displayed.

79 Views

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.