Hi, I was wondering if anyone knows if it's possible to add a dynamic field heading to a table of data? for instance if I wanted to find out the total value of deposits at the end of the week then I would want the heading to be "Actual Balance ". Then when running the report a week later I would want the heading to be "Actual Balance " etc?
Kayleigh - You can change the name of columns/fields using Field Organiser or Validate Data blocks, but the names are inputs and not dynamically determined from the data set. You can evaluate an expression to test if it is equal an existing column name using the REFVAL function, but the column/field name the expression is looking for must already exist in the loaded Report data set.