Report Designer - Editing Column Heading Text

SOLVED

I have no experience in Report Designer and it's totally foreign to me. I can't seem to find any instructions on how to do some basic editing to a report. I want to edit the text to a column heading. I click on the column heading and it changes to xxxxxxxx. How do I edit the content of the heading?

  • 0
    verified answer

    The "xxxxx" indicates that the field you clicked is a TEXT field, probably a formula.  When you click on the field, the identity of the field will appear in the lower left corner of the Report Designer window, with the name of the field and the formula name appearing in parentheses.  Then go to Tools > Formulas > Design Formulas if the field is a Design Formula, click on the formula name, and then click "Change" in the options buttons to the right.  Make the changes required and click OK.  Be sure to observe the syntax for a text field: it must be enclosed in Quotation Marks (" ").