Hi I am Try to achieve Following Requirement.

There are Two Tables TAB1 and TAB2 joined with Common Column in report Definition.

TAB2 has a Column Name VALUES with Text Data Type has a Value like (1,2,3) or (2,3,4) or (5,4,6)See Structure below.

TAB1 has a Column ID with Text DATA (1)or (2) or (3) or (4) See Structure below

Now I need Dropdown values if TAB2 VALUES column is (1,2,3), then Dropdown Should have (1,2,3) options from TAB1 or corresponding values of other Column of TAB1 See Explanation below

If TAB2 VALUES column is (2,3,4,5), then Dropdown Should have (2,3,4,5) options or Corresponding values of other column of TAB1 See Explanation below

Dropdown Source is Datapage with Report definiton Reference.

TAB 1 STRUCTURE

ID OPTION ...............
1 ABC
2 XYZ
3 UVW
4 PQR

TAB 2 STRUCTURE
ID VALUE ..................................
1 1,2,3
2 2,3,4
3 3,4,5

Explanation

If VALUE column in TAB2 is (1,2,3)

drop down should reflect (ABC/XYZ/UVW)

f VALUE column in TAB2 is (2,3,4)

drop down should reflect (XYZ/UVW/PQR)

f VALUE column TAB2 is (2,3)

drop down should reflect (XYZ/UVW)

How to Achieve this ?

Thank you