I simply created a interactive report based on the oracle table and set a Hidden Page Item called P1_contrain_parameter to receive the value passed from another page. The P1_contrain_parameter is used in the where clause as follow:
(Column_name = :P1_contrain_parameter)
But it does not work in this way. I tried to set the page item as Display only and found that the value has been successfully passed to the current report. I also tried to set the where clause as
(Column_name = 'actual_value')
It also works. However, it just do not what when I pass the actual value to P1_contrain_parameter to construct the dynamic where clause. Can anybody tell what might be wrong here?