I want to implement a functionality where I have an interactive report which comes with default Search / Filter option , but I also want to have additional filters which are drop-downs in this case and based on the values selected from the drop-down lists , report displays the values ! How can I implement this functionality where after selecting a value from the drop-down list and then further using interactive report filter to retrieve the results.
Below is my SQL
select * from Atoms_FULL
WHERE (:P6_ANO IS NULL OR ANO = :P6_ANO )
OR (:P6_ATYPENAME IS NULL OR ATYPENAME = :P6_ATYPENAME)
When I implemented this , only the interactive report filters are working but not the customized filters WHICH ARE :P6_ANO AND :P6_ATYPENAME (Drop-down Lists)
I hope I have made the question clear. Let me know if you need any more clarifications.
Would really appreciate if anyone can help in this issue asap.
You have to set the session state of page items, this can be achieved by adding your items as comma seperated into the Page Items to Submit attribute, This attribute is available under Interactive Report region source, Dynamic Actions etc.