1 Reply Latest reply: Dec 7, 2012 12:27 PM by VC RSS

    Interactive Report with additional search filters

    Rads
      Hi all,

      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.

      Thanks,
      Rads