Displaying a linked field in Parameters

[Former Member]

I have a FacilityID field in my database. I want the user to be able to select records in a parameter based on Facility, but I want to show the Facility Name in the parameter rather than the FacilityID which is stored on all of the records. How would I go about doing that?

Thanks,

Brian

[former_member226669 · Accepted solution]

Hi Brian,

If you are using Report Level parameter, you can create a parameter with the Description.

Add FacilityId under the Value and Facility Name under Description.

Change the option Prompt With Description Only: to True.

- Nrupal

[Former Member · Accepted solution]

This worked. Thank you! I figured it was something simple i had just not done in CR previously.

Brian

[DellSC]

If you don't have the table that includes the Facility Name included in your report, add it.  Then you'll base the parameter off of this table and not any of the tables that include just the Facility_id.  You should now be able to do what Nrupal describes in terms of setting the value and the description fields for the parameter.

-Dell