Skip to Content
0
Jun 20, 2018 at 04:19 AM

Display column values based on referencing to another column in crosstab for text box

223 Views

Hi, I have a crosstab below capture from a datasource in SAP Design Studio 1.6, which display due entry for employees timesheet.

How can i use similar queries as below to display the string which are not null for the person. For example, EMP_1 textbox will displayed "charles.lee" and the EMP_TD_1 textbox should displayed the string value of either "More than 3 Days" which is 2018-06-13, or if the column for more than 3 days is an empty string, it would display the string value in the "Within 3 Days" column which is reference to the person I chosen.

Final results should be like this:

EMP_1.textbox : charles.lee

EMP_TD_1.textbox: 2018-06-13

EMP_2.textbox = yuenpeng.yap

EMP_TD_2.textbox = 2018-06-19

Attachments

1.png (8.7 kB)
2.png (19.1 kB)