Refresh Lookup on a TIER Report

Overview

This topic is directed to users who are new to designing TIER reports.

Details

After a report has been finished, you find that your users would like to see additional information. You go in and add additional items to a lookup, but the new fields are not available on the design of the report. Below are the steps to take to refresh the fields in the data pipeline so that they appear in the design of a report.S

Steps

1. Modify your lookup to include the additional fields. This action is similar to how you would modify any TIER Lookup to add new fields. In the example below, NPI_ID was added to the lookup.

2. Next, refresh the Field Editor by right-clicking on the TierppDBPipeline1 that is linked to your lookup and selecting the Fields Editor.

3. Reset the fields listed in the Fields Editor. First open the Fields Editor window, then click the Reset button to retrieve any additional fields added.

Before

After

4. Open the Report Designer (TierppReport1). The newly added field appears.