Reputation: 1434
I need to add extra parameter to the interactive report for searching criteria. and I need it to be processed when I press the Go button in the interactive report. what I have is the text box but when searching the values entered never reflects in the report when I press the Go button. Any Help?
Upvotes: 1
Views: 272
Reputation: 60312
If you have a text item, e.g. :P1_SEARCH, you can refer to it in the query in your interactive report, e.g.
SELECT ...
FROM mytable t
WHERE INSTR(UPPER(t.mycolumn), UPPER(:P1_SEARCH)) > 0;
To have the report pick up the value whenever it is refreshed (e.g. from the Go button), make sure to add the item name to the Page Items to Submit attribute, i.e. P1_SEARCH
.
Upvotes: 1