Oracle Reports (MOSC)

MOSC Banner

Before Report Trigger

edited May 26, 2010 11:53PM in Oracle Reports (MOSC) 3 commentsAnswered
function M_2FormatTrigger return boolean is
begin
-- Automatically Generated from Report Builder.
if (:code = '05')
then
return (TRUE);
end if;

return (FALSE);
end;

I have this function in a Before Report  Trigger in a report

which when the code is 05 a Frame M2 Displays in the report with the data that goes with this option.

How do i Modify the function above to allow code 04 to display a frame M5 in the report with specific data that goes with the code and

same for code 06.

The report has the query below as its source.
SELECT DISTINCT  :p_entered_value, SUBSTR (acv.check_stock_name, 1, 2) code,acv.check_id,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center