Adding Another Column to a Report

Adding a new column to a report is not quite as straight forward as it should be. The good news is it is not very difficult if you follow the instruction below.

• Open your report in the designer
• Select the data set that is going to be updated
• Update the data sets sql
  • In this example the Region and BirthDate fields will be added
• Make sure to click the Refresh Fields after adding the new columns
  • If you do not do this the new fields will not be available to use
• Back on the main designer form right click -> Insert -> Textbox at the location the new field should be displayed
• Select the newly created text box and in the properties windows click the ... button on the value property
• Now in the value property you can enter the field that should be displayed
  • This example is adding the Region field ={Region}
• Now preview the report and you can see the new data

Visual Overview

Open your report

Select the data set that is going to be updated

Update the data sets sql. In this example the Region and BirthDate fields (not shown in screenshot) will be added.

Back on the main designer form right click -> Insert -> Textbox at the location the new field should be displayed

Select the newly created text box and in the properties windows click the ... button on the value property

Now in the value property you can enter the field that should be displayed

Displaying the text box value set to the Region field

Now preview the report and you can see the new data