Hi. I am trying to get a count of records from a SQL table to display a summary on my CR report. I added a SQL Expression Field and put this SQL statement:

When I try to check the syntax CR gives an error box saying "Error in compiling SQL Expression: ' ". I tried changing the single quote to a double one but that didn't work. If I remove the WHERE section it correctly returns and displays the total number of records.

Can someone tell me what I am doing wrong? I've search the net with no luck. I know you can do summary's using groups but I don't want my report to be displayed in groups.

Thanks,
Jason