Report Filter

Andy Davis shared this question 48 days ago
Answered

Is it possible to create a report variable that shows a name but when you run the report it will pass a numerical ID. For example. ID = 20 Display Name = "Display Name"

The user will see the Display name but the value is 20

Comments (3)

photo
1

Hi Andy,


Thanks for your message.


It sounds like Reference Codes will get you the functionality you desire. Reference Codes give you the ability to format certain values in the way that you are attempting to in your example, as well as create a custom order if that is what you require. You will need to open the Column Formatting page, where you can then create a global Reference Code for the column.


/0abfaf556077b07061990856fa0b6342


Let me know if you have any further questions.


Kind regards,

Simon

photo
1

Hi Andy,


I'm just messaging to let you know that I will be marking this as answered.


If have any further questions, please don't hesitate to reach out and I will get back to you shortly.


Kind regards,

Simon

photo
1

TY,

I have not had a chance to try the reference code yet but I think that is what I need.