APEX

Hi All:

I am using APEX 4.0.6 and I have a page that have 4 regions and each of region is showing a classic report whose SQL is very similar to each other:

e.g.

For region 1, the SQL looks like select * from history where status = 'A';
For region 2, the SQL looks like select * from history where status = 'B';
For region 3, the SQL looks like select * from history where status = 'C';
For region 4, the SQL looks like select * from history where status = 'D';

For best database performance, I like to create a page item called p_status_value on this page and using the following binding syntax for SQL statement for all 4 regions:

select * from history where status = :p_status_value;

however, I need this page item value is dynamically change for each region:

For region 1, p_status_value = 'A';
For region 2, p_status_value = 'B';
For region 3, p_status_value = 'C';
For region 4, p_status_value = 'D';

Also, I need hide this page item on this page.

Can anyone show me how to do this?

Thanks in advance!

Kevin

Edited by: Kevin Zhang on May 10, 2011 1:03 PM