Hello Team,
I have 2 controls in my report which have different dataset . In both dataset I have 2 common fields id and name . For first control we are using name as control value. How can I apply dependent values for 2nd control which has common field (name ) in its dataset.
Hi @rnikam,
Can you expand on your scenario a bit further in depth?
In terms of the ‘show relevant values only’ option in controls, this can only be applied to controls that are linked to the same dataset. However there is a way to get around this depending on how you have things setup/how your datasets are designed.
So some questions to assist further:
So you have two controls, one is ‘Name’, what is the second control? Is the ‘Name’ field located in both datasets? If not, how does the information within each dataset link up to each other? Do you have the name field present in the dataset being used for the second control?
If ‘Name is in both datasets, is the field name the same in both datasets? Are the values the same?
1st control (name) has value name and 2nd control (managed name) also has same value as name.
Do you have the name field present in the dataset being used for the second control ? YES
Are the values the same? Yes the values are same.
There is common field ID as well which can be considered as link between these 2 datasets
Hi @rnikam,
Since both controls operate off the same field: ‘Name’ and have the same values, I would suggest using a parameter instead.
Set up a parameter for ‘Name’, link it to your Name field (in either dataset) so that your control has the correct values in the dropdown. Then you can use that single dropdown to filter/control visuals from each dataset.
Here’s some additional information about parameter usage; let me know if you have any additional questions or if this works for your case: