Jump to content


  • Content Count

  • Joined

  • Last visited

  1. I keep getting an error when running the report that has a calculated fieldwith a sql case statement. I'm trying to pull a value from another table based on the current record on the datapage. I'm using the following: Each record has a field called "Phase" with the values in the 'when' clause. Trying to pull from a table of agreements that has the amount of funding for each of these phases based on a project ID. What am I doing wrong? The Verify button says it's all good, but when I preview the report it says there's an error. CASE WHEN [@field:Phase]="CON"
  • Create New...