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