Thread: Previous/Next Option

This question is not answered. Helpful answers available: 5. Correct answers available: 1.


Permlink Replies: 4 - Pages: 1 - Last Post: Dec 10, 2008 11:59 AM Last Post By: vitodc
vitodc

Posts: 527
Registered: 12/18/00
Previous/Next Option
Posted: Dec 9, 2008 7:00 AM
 
Click to report abuse...   Click to reply to this thread Reply
Hello,

I have two pages, one is a report with a link to a page which is a form.
My report page contains filter fields for the report.
What I want to do is:

Once the report is run and the user clicks on the link to go to the form, I want the user to be able to user PREVIOUS/NEXT buttons on the form to navigate within the resultset of the report.

I hope this is somewhat clear.

Thanks in advance.

VC
Dan McGhan

Posts: 2,249
Registered: 03/01/06
Re: Previous/Next Option
Posted: Dec 9, 2008 7:29 AM   in response to: vitodc in response to: vitodc
 
Click to report abuse...   Click to reply to this thread Reply
VC,

You want the next/previous buttons to populate form with the next/previous values in the report correct?

This "sounds" possible but the implementation could vary depending on the requirements. What is the sort order of the report? Can the report be filtered?

Regards,
Dan

http://danielmcghan.us
http://sourceforge.net/projects/tapigen
vitodc

Posts: 527
Registered: 12/18/00
Re: Previous/Next Option
Posted: Dec 9, 2008 7:30 AM   in response to: Dan McGhan in response to: Dan McGhan
 
Click to report abuse...   Click to reply to this thread Reply
Hi Dan,

The sort order will always be the last name of the employee, but I may want to be able to give the end user the ability to change this.
Yes the report can be filtered.

Thanks
VC
Dan McGhan

Posts: 2,249
Registered: 03/01/06
Re: Previous/Next Option
Posted: Dec 9, 2008 12:58 PM   in response to: vitodc in response to: vitodc
 
Click to report abuse...   Click to reply to this thread Reply
VC,

The filtering will make it hard. What kind of report, standard or interactive? If it's interactive then it would be VERY difficult if not impossible. If it's standard then you'll need to write some on submit procedures on the form page: Increment ID and Decrement ID. They will fire depending on which button was pressed next or previous and will update the item that hold the value for the current record's id.

Each one will have to have a cursor based on the query from the report and each will have to apply the same filter used on the report. Then you'll iterate through the cursor until you get the ID you're looking for. It sounds like it'll require a bit of effort but should work.

Regards,
Dan

http://danielmcghan.us
http://sourceforge.net/projects/tapigen
vitodc

Posts: 527
Registered: 12/18/00
Re: Previous/Next Option
Posted: Dec 10, 2008 11:59 AM   in response to: Dan McGhan in response to: Dan McGhan
 
Click to report abuse...   Click to reply to this thread Reply
thank you Dan for your input.
I will give it a try.
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums