What if the lookups is too big and changable , then i cant make it constant condition,   for example the CASEMGMT.REF_TABLE_VALUE contains parents and childs lookups like attached image , then how to select the description automatically ?    It's hard to code it to case X_RT_ECONOMIC_CD ="4_203" then 'some text description here'   Can i write innser select inside VA expression like below : define X_KYC_ECONOMIC_CODE='2_0'; select VALUE_DESC from CASEMGMT.REF_TABLE_VALUE where REF_TABLE_NM='X_RT_ECONOMIC_CD1' AND VALUE_CD='&X_KYC_ECONOMIC_CODE'; ... View more

Hi Sam,   We tried this option "Expand Clipped Content" .   kindly check the attach file (Exported as PDF file) , first page displayed correctly but other pages have a problem it's not acceptable view at all ... View more