title: Crystal Reports C# formula returning false only
body: <p>I have created one crystal report where I want to write a formula.</p>
  
  <pre><code>my formula:
  IF {Sp_Get_DailyReport;1.Job_Status} = 'Workshop' 
  THEN {Sp_Get_DailyReport;1.Department_Name}
  </code></pre>
  
  <p>but, this formula doesn't returning a value.
  i have edited my formula, now i'm getting as 'false' instead of Dept-name.</p>
  
  <pre><code>stringvar text := "";
  IF {Sp_Get_DailyReport;1.Job_Status} = "Workshop" 
  THEN text = "{Sp_Get_DailyReport;1.Department_Name}"
  </code></pre>
  
  <p>In ReportFooter i have created one column for workshop where i want to display department name n unit name whose units are in workshop and i'm placing this formula field in ReportFooter where its returns only one value,
  instead of each condition where its true &amp;
  why its returning 'false' i dont know, instead of dept name.
  I want to select all those records whose jobstatus is workshop n display it in the reprotfooter.
  Can anyone please help me...</p>
  
  <p>Thanks</p>