This content has been marked as final. Show 6 replies
You can create a html region above the tabular form and add the relevant fields and then edit the query of the report to include those fields.
Thanks for your answer. But I still didn't understand, how should I do with the html region? How to add the fields and then....
There are couple of ways to do this, but the simplest would be to add a textbox for search values and a button. Give the button a dynamic action triggering on click which refreshes the tabular form region. Then, in the region definition for the tabular form, where you get a sql expression for what rows to return, put in a where clause that filters based on the value in the search box.1 person found this helpful
This won't get you quite to interactive reports, but it's a step up. To my knowledge there is not a way (without essentially rewriting interactive reports) to get that flexibility of reporting with the ability to do inline editing.
thanks very much for your answer. It is really helpful.
There is still a question:
how can I let the tabular form after the search show all the data? Because If I click a button without text in textbox, then I get no rows from the tabular form
modify query in the tabular report. Assuming your query contains
, modify it to
This assumes your search item is null when no value is passed.
where x=:P_SEARCH or :P_SEARCH is null
edit your where clause to hold an empty text field into account
WHERE UPPER(xx) LIKE '%'||UPPER(:P1_SEARCH_FIELD)||'%' OR :P1_SEARCH_FIELD IS NULL