In this session, we’ll continue looking at using formulae within your reports, focusing on CASE statements.

We’ll be covering:

  • Simple Concatenation, allowing you to join two or more strings of data together
  • Concatenation with a separator, to ensure that if you have a ‘NULL’ value in your string, you still see an output
  • Using Group Concatenation to join values from multiple different rows