Home » Developer & Programmer » Reports & Discoverer » How to Erase (or) Reset The User Parameters?
icon5.gif  How to Erase (or) Reset The User Parameters? [message #282378] Wed, 21 November 2007 14:14
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
Member
Hi all,

My requirement is something similar to this.

I need to display the records in a typical Emp table where the user parameters will be job_type which could be 'Manager'
or 'Clerk'. I had created two user parameters called Manager and Clerk and gave LOV's to both parameters as 'Y' and 'N'. The records will be retreived based on whichever value is 'Y'. For that I created a before report trigger like this.

IF :MANAGER='Y' AND :CLERK='N' THEN
:P_JOB_TYPE:='MANAGER';
ELSIF :MANAGER='N' AND :CLERK='Y' THEN
:P_JOB_TYPE:='CLERK';
ELSIF :MANAGER='Y' AND :CLERK='Y' THEN
:P_JOB_TYPE:='MANAGER OR CLERK';
ELSE -- where both the parameters are set to 'N'
SRW.MESSAGE(1,'YOU MUST SELECT ATLEAST ONE JOB TYPE');
END IF;

WHERE P_JOB_TYPE is a lexical parameter is passed to the query.

After the message prompt, its displaying all the records for manager and clerk whereas I want to reset the given parameters and prompt for the user to enter 'Y' for atleast one parameter. How can I implement this?
Any advice is appreciated.
Thanks.


Previous Topic: Checkbox and Radio Button on Reports-6i
Next Topic: Fatal pl/sql error occurred
Goto Forum:
  


Current Time: Wed Aug 23 12:46:36 CDT 2017

Total time taken to generate the page: 0.04890 seconds