Stimulsoft Business Intelligence System | Forum

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

• In the report I see a filter with all the department names to choose from. So far so good

• Once one value chosen, the key value is used in the report. BUT, the key value is also shown in the filter

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

Hello,

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

Thank you.

Dear Lech

Thank you very much for your help! It works.

Best regards
MKA

Hello

We are always glad to help you!