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
-
In the Classic client, on the Tools menu, click Object Designer.
-
In Object Designer, click Report, select the report to which you want to add a hidden field, and then click Design.
-
On the View menu, click Sections.
-
To create a new hidden field, on the View menu, click Toolbox, and then click Text Box. In Section Designer, add a text box.
-
Select the text box that you created in step 4 or select an existing hidden field. On the View menu, click Properties.
-
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.
-
In the ForeColor field, enter 65535 to specify that the color in Section Designer is yellow.
-
In the Visible field, select No from the drop-down list.
-
In the Width field, specify a small width, such as 150.
-
On the File menu, click Save.
-
In the Save window, select the Compiled check box, and then click OK.