Galax E Solutions
Last activity: 29 Oct 2018 16:46 EDT
Single Text of CSV values to be filtered for Report defintion of Joined Table
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 ...............
TAB 2 STRUCTURE
ID VALUE ..................................
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 ?