APEX

Hiho,

i have a page where i pull a ppr report from a different page using htmldb_get like described in Carls excellent examples. The first page also contains a textfield to set a where condition in the report, for examle to search a streetname..

Now i need a way to reset the pagination of the report using javascript.

Example:

I search for street_name_1 and the report returns 100 rows, 10 rows on each page. Now i use the pagination links to switch throught report pages to page 5.

Now i search for street_name_2 and the report returns 5 rows, so this would only be one page in the report. But the report pagination still is on page 5, so no results are shown. And no pagination buttons either.

What can i do to reset the pagination before i pull the report without submitting the page?

Thanks for help,
DIrk