Rename a Row or Column

Change the column title to provide a more meaningful name. By default, when you run a report, the column title is taken from one of the following:

• if defined, the Label property of the data item

• if defined, the label of the data item in the model

• the Name property of the data item

Consequently, the column title you see in the layout may not be the column title you see when you run the report. For example, if you modify the Name property of the data item, the column title in the layout will change to the new name. However, when you run the report, the column title that appears will be, if defined, the data item label in the report or the data item label in the model. If neither of these are defined, only then will the modified name be used as the column title.

Steps

1. Click the column heading you want to change.

2. In the Properties pane, click the Source Type property and click the source type you want to use for the column title:

   • To use a static text item, click Text, and then type the name you want in the Text property that appears.

   • To use a data item value, click Data Item Value, and then click the data item you want to use in the Data Item Value property that appears.

     Using a data item value is useful when you have a master detail relationship. For example, you create a list with sections using a master detail relationship , and you want the section name to appear in the column title of one of the columns. Insert the data item used as section headings into the column title, and specify the source type as Data Item Value. When you run the report, for each section, the column title will contain the section heading combined with the data item label or name.

   • To use a label that is different from the label in the model, click Data Item Label, click the data item you want to use in the Data Item Label property that appears, and type the name you want in the Label property.

     Tip: The Label property is under the Data Item group.

   • To use a report expression, click Report Expression, double-click the Report Expression property that appears, type the expression you want, and click OK.

3. Press Enter.