I have a field on my report that I want to return like this...Here is my SQL code If I were to do it in SQL.  How can I return the same thing on my report in Crystal Syntax?

SUM(CASE KILSHEET.Contract WHEN 1 THEN ((TOT_CARC_WEIGHT / 100) * 1.75) ELSE 0 END)


Edited by o9z1 - 07 Feb 2008 at 10:23am

I am getting the following error:

Error in formula <Running Total Condition Formula>
'Global Numbervar ContractTotal;

The field name is not known

Yes, I am using crystal syntax

that was just how the error shows:

'error'

To be honest, I don't know what is going on with your reports. I looked at both posts you have on the forum and the code I give you works fine on my computer. Yet you get strange errors when you run it. There is something odd happening, but I have no idea where the problem is.

Anyway, another way to do you SELECT statement is to create a formula with only the IIF() statement.

IIF({KILSHEET.Contract}=1, (TOT_CARC_WEIGHT / 100) * 1.75, 0);

And add that to your report in the Details section. Then right-click on it and select Insert > Summary. That will give you a total at the end of the report.