If you have hidden fields on a report, we recommend that you mark them so that they are easy to identify. After you create a client report definition (RDLC) layout for a report, you may need to move hidden fields to a different location in the layout to avoid problems with formatting.

For example, you can use hidden fields if you need to reference a data-bound field from the header of a report. For more information, see Understanding Headers and Footers.

You can also use hidden fields if you have an option on a request form, such as whether to show values in the local currency (LCY).

To add and identify a hidden field

  1. In the Classic client, on the Tools menu, click Object Designer.

  2. In Object Designer, click Report, select the report to which you want to add a hidden field, and then click Design.

  3. On the View menu, click Sections.

  4. To create a new hidden field, on the View menu, click Toolbox, and then click Text Box. In Section Designer, add a text box.

  5. Select the text box that you created in step 4 or select an existing hidden field. On the View menu, click Properties.

  6. If this is a new hidden field and you want to use the value of a field elsewhere in the report, in the Properties window, then specify the value in the SourceExpr field.

  7. In the ForeColor field, enter 65535 to specify that the color in Section Designer is yellow.

  8. In the Visible field, select No from the drop-down list.

  9. In the Width field, specify a small width, such as 150.

  10. On the File menu, click Save.

  11. In the Save window, select the Compiled check box, and then click OK.

See Also