I am using Forumulas in Crystal Reports and it has to count the total number of values for specific zones.

In SQL Server I could simply write:

Select count(*) from MyTable WHERE MyZone IN ('HH','YW', 'GWB', 'SVT')

Now for Crystal Reports, how do I use this query to run in Formulas that will give me the count of these zones.

Please reply.

Thank you! :)

I am using Crystal 2008 and am also having trouble with my WHERE clause. It seems that Crystal does not recognize the WHERE clause as a clause at all. Any suggestions?