I had the same problem long back. I used hidden item to solve this issue. You can create a hidden item on the page as below
Source Type: SQL Query (return single value)
where application_id = :APP_ID
and page_id = :APP_PAGE_ID
and upper(region_name) = upper('TEST REGION') //TEST REGION- Name of your region.
It will work.
1 person found this helpful
You are right.
I created the hidden item and changed the code from:
$a_report('734879922768742332', '1', '5000', '5000');
'P6_REPORT_ROUTE_ID'), '1', '5000', '5000');//734879922768742332