We have a customized SSRS report which is based on the view. Also, there is a query to enable user to add ranges before running the report. The data source of this query is the view. Recently I have added a new field named "Code" to the view which needs another join to the customized table named "RequestTable". I have appended this field to the query ranges as well. When user wants to select criteria for this field the lookup shown duplicate values. I thought the values which are shown in the lookup should come from root table. For example when I add vendor account field from purchTable although purchTable has duplicate vendor account the lookup shown values from vendTable (i.e, the value are not duplicate).
Code field which is in RequestTable comes from CodeTable. There is no duplicate value for Code in CodeTable and also it is index (primary key).
As you know this lookup is shown automatically and there is no code for that. I want to know which steps are important to correct the lookup considering EDT, Table relations, Auto Lookup field groups and so on. Maybe something is missing in setting CodeTable or RequestTable properties.
