where to insert the IF statement???

[bloomlight]

I am writting a report using Crystal Report. And I don't know where or how to insert the IF statement. I have fields on the report with emp last name. Now, I need to make a report with:

If lastname start with 'B' then go to "Group-1"
else
go to "group-2"

any idea how to make IF statement to the query? where to instert the IF statement? I went to "Record Selection Formula Editor", but don't know where to put IF statement. Any help will be appreciated.

 

[MCuthill]

bloomlight,

You need a new Formula Field, which can then be used to define a Group within your report.

The syntax for specific inquiry is as follows:

IF Left({Table.LastName},1)="B" THEN "Group 1" ELSE "Group 2"

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[bloomlight]

It worked. Thanks Mike!!!!!