Question

1
Replies
59
Views
Close popover
Bhargav Pokala (BhargavP0539)
Galax E Solutions

Galax E Solutions
IN
BhargavP0539 Member since 2017 6 posts
Galax E Solutions
Posted: October 24, 2018
Last activity: October 29, 2018
Closed

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 ...............
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

Reporting User Experience
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.