I have developed a oracle custom report(rdf) as XML Publisher Report through a RTF template on Account Recievable(R12).
Report having a parameter called sort_by. User can select either TRANSACTION_NUMBER or CUSTOMER_NUM as run time..
When user select Parameter as TRANSACTION NUMBER: Data should sort on TRANSACTION NUMBER as primary and CUSTOMER NUM as secondary
When user select Parameter as CUSTOMER NUM, data should sort on CUSTOMER NUM as primary and on TRANSACTION NUMBER as secondary .
I have built below logic in the before report trigger through a palce holder
if p_order_by='TRX_NUMBER' then
order_by:= ' Order by to_number(trx_number),to_number(customer_num);
order_by:= ' Order by to_number(customer_num),to_number(trx_number);
I am experiencing an issue on data sorting like, report is sorting only on TRANSACTION NUMBER and not performing the sorting on CUSTOMER NUM when parameter is CUSTOMER NUM.
Anyone having any suggestion/solution on it..
Please share your valuable inputs for the same.
At present I am not able to do the test case with place holder, but I experienced the same problem while ordering with user parameters.
To solve the issue, I have given initial value for user parameters then it worked fruitfully. So try user parameters with initial value instead of place holders.