Question

1
Replies
47
Views
BhargavP0539 Member since 2017 6 posts
Galax E Solutions
Posted: 1 year ago
Last activity: 1 year 10 months ago
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 Interface
Moderation Team has archived post
Share this page LinkedIn