The Access Charity CRM Report Builder contains a set of advanced options that can manipulate the data in the report or flag certain data.
To add expression columns to reports:
In the report builder, add the fields you need to report on.
Click Add Expression.
Enter a Caption.
This will be the column name.
Click Insert Expression and select the expression that matches what you need to do.
In the expression text box highlight A or B and click Insert Field.
Select the Field you want to use in the expression.
Repeat steps 5 and 6 for the other letter.
Click OK to add the expression column to the report.
After adding the expression, we recommend refreshing the report to see if it is displaying the values you would expect.