In the image below, the table on the left shows Touchpoint Responses and the Program they were taken in. The table on the right includes the Program Name from the Enrollment folder. Notice that Response # 480 is repeated 3 times. This is because the person to whom #480 belongs is enrolled in all three Programs and the object of [Program Name] is not connected in any way to the Program where the Touchpoints were taken.
Instead, the object associated with responses in a particular program is the [Completing Program Unique Identifier].
This object is NOT a string value, but rather the Identifier (number) of the Program. There are two recommended ways to get the correct Program name to display in your Report. Choose the method that meets your needs:
For this method, you will correlate the Completing Program Unique Identifier of the Touchpoint with the Program Unique Identifier form the Enrollment folder.
Set up a "requery" in the filter so that the only Touchpoint responses that are returned in the report, are those that share the same Identifier as the Program Unique Identifier. You can also use the Program Name object in the filter as a User Prompt:
This will require the inclusion of a second query in the report.
Filtering on Program Name
In circumstances where you wish to have a user prompt on a Program Name, you will need to add a second query from the Standard Reference Universe:
This universe contains reference data only, including the Program Name and associated Identifiers.
In the Results Objects of the new query, add the [Program Name] and the [Program Site Identifier]
Now, add the Program Name to the Query Filter and set it as a Prompt:
Go to the original query and pull the [Completing Program Identifier] into the Query Filter. From the Bullet List, Select "Results from another query" and then select [Program Site Identifier] from the list.
Your original data query will now be restricted to only those Program Names where the Touchpoint was taken.
To be able to see the Program Name as a string value, you must created a "detail variable."