Skip to Content
author's profile photo Former Member
Former Member

Displaying a linked field in Parameters

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?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Sep 14, 2015 at 01:21 PM

    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

    Img.PNG (21.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 14, 2015 at 06:59 PM

    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.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.