I'm working on creating my very first report in Crystal Reports, and have gotten caught up trying to display text in an object based on an underlying if statement.

Hopefully I'm not way off base, but it is my understanding that I'll have to use a Formula Field in order to get it to display.

I've created one with the following code:

StringVar stat;
If {EventMeetingsReportView.MeetingStatus} = "Cancelled" Then
    stat = "Has Been Cancelled"
Else 
    stat = {RoomsReportView.Building} & ", room " & {RoomsReportView.RoomNumber};

I have a text object with the field in it, but when preview the form all it displays is "False".  Any insight would be greatly appreciated - thanks!

If you are using Crystal syntax "=" is used only for comparison. The statement
   stat = "Has Been Cancelled"
is false (stat does not equal "Has been Cancelled"). If you want to assign a value to a variable use ":=" instead:

If {EventMeetingsReportView.MeetingStatus} = "Cancelled" Then
    stat := "Has Been Cancelled"
Else 
    stat := {RoomsReportView.Building} & ", room " & {RoomsReportView.RoomNumber};

This one catches me out all the time, I often switch to Basic syntax instead which does not have this problem.

Actually, if the variable stat is not needed for further calculations in the formula you can leave it out and do this:

If {EventMeetingsReportView.MeetingStatus} = "Cancelled" Then
    "Has Been Cancelled"
Else 
    {RoomsReportView.Building} & ", room " & {RoomsReportView.RoomNumber};




Edited by rvink - 12 Oct 2010 at 1:23pm