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: Report property setting
Next Topic: Checkbox and Radio Button on Reports-6i
Goto Forum:
  


Current Time: Wed Dec 07 08:52:50 CST 2016

Total time taken to generate the page: 0.11106 seconds