Hi Atul kumar
1. How can a report be editied after its generation in previewer at
runtime?
Which object you wanna to edit or modify .............
2. In After_Parameter_Form trigger, we check no of records to be displayed
and if it is zero then we are able to display a customised message "Records
not exist". After this this trigger is failed. Now the problem is that
Report Builder is giving message "REP-0771: After Form Trigger Failed". We
don't want this message. How can we suppress this message "REP-0771: After
Form Trigger Failed"?
Solution:- You can write After_Parameter_Form trigger
BEGIN
SELECT count(*)
INTO lv_count
FROM hr_people
WHERE country_code =:p_country_code
;
IF lv_count = 0 THEN
srw.message(20, 'No reocrd found');
raise srw.program_abort;
END IF;
EXCEPTION
when OTHERS then
srw.message(30, 'Error in reports.');
raise srw.program_abort;
END;
3. In the previewer we have a main-menu item "File". Under this few
sub-menu
items are displayed like "Page Setup", "Print", "Mail", "Distribute" and
"Generate to File". How can we hide these sub-menu items?
you have to run R30RUN32.EXE Mode
Hope this will help you.
Nitheesh .
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pullikol Kumar
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
