Filter shows key instead of value

Stimulsoft Ultimate discussion
Post Reply
MKA
Posts: 5
Joined: Thu Mar 09, 2023 9:10 am

Filter shows key instead of value

Post by MKA »

Dear

I have the an issue with a filter on a report. Repro steps:
  • I have added a data source a view with a column DEPNR (Department number) --> Query: 'Select * from View where DEPNR = @Department'
  • I added another table (DEPARTMENTS) which I want to use as user defined filter. Two columns: DEPNR and NAME
  • I define a variable @Department
Department Variable.png
Department Variable.png (24.18 KiB) Viewed 7616 times
  • In the report I see a filter with all the department names to choose from. So far so good
Filter dropdown.png
Filter dropdown.png (22.42 KiB) Viewed 7616 times
  • Once one value chosen, the key value is used in the report. BUT, the key value is also shown in the filter
Filter choice.png
Filter choice.png (12 KiB) Viewed 7616 times
This is very annoying, because the user does no longer know which one he choose. Is there a possibility to always show the value instead of the key and only use the key in background for querying?

Beste regards
MKA
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Filter shows key instead of value

Post by Lech Kulikowski »

Hello,

Please remove the "Allow User Values" option for the variable.

Thank you.
MKA
Posts: 5
Joined: Thu Mar 09, 2023 9:10 am

Re: Filter shows key instead of value

Post by MKA »

Dear Lech

Thank you very much for your help! It works.

Best regards
MKA
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Filter shows key instead of value

Post by Lech Kulikowski »

Hello

We are always glad to help you!
Post Reply