You can only use an IF statement if your database will process it. The command that you enter is parsed by the database, not by Crystal so you can't use Crystal syntax.
You can do this two ways:
1. Create a formula and have Crystal process the logic. Use this logic on the report.
2. Use a Case statement in whatever format your database syntax requires - if your database type will parse Case statements. For Oracle and MS SQL Server, it looks something like this:
Case reg
when 2 then 1.4
when 3 then 1.5
when 4 then 1.2
end
or like this:
Case
when reg=2 then 1.4
when reg=3 then 1.5
when reg=4 then 1.2
end
For both of these you can include an "else" statement after the last when to set a specific default value. If you don't use the else, the default value is null.
-Dell
IP Logged
