ARCHIVED: How do I add an indicator to a table in SSRS?

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

To add an indicator to an existing table report:

  1. In the upper-left corner of Report Builder, click the red ribbon button. If your report is in the "Recent Documents" column, click the report name; otherwise, click Open, navigate to your report library on your server, select a table report from the list of reports, and click Open.
  2. In your table, right-click the last column, and choose Insert Column and then Right. A new column will be added to the end of the table.
  3. On the Insert tab, click Indicator. The cursor will turn into a diamond shape with a plus sign.
  4. Click inside a cell in the new column to place the indicator into the cell. Select the indicator type and click OK.
  5. Right-click the indicator, and select Indicator Properties....
  6. Click Value and States. In the "Value:" drop-down list, choose a measure from your dataset to be represented in this indicator. Adjust indicator properties as desired, and then click OK.
  7. To test the table with the indicator, in the ribbon, click Run. To return to the report layout, click Design.
  8. To save the table with the indicator, click the floppy disk icon in the upper-left corner of the screen.

This is document bcqu in the Knowledge Base.
Last modified on 2021-09-20 15:13:36.