create table in report

Create Table in Report.

Srw.do_sql (sqlstatement char);


    SRW.USER_EXIT('FND SRWINIT');

  srw.do_sql('create table xxg4_y(ename varchar2(10))');

  return (TRUE);

Setting Format Attributes:

Function age_mask return Boolean is

Begin

If :age < 25 then

Srw.set_text_color(‘Red’);

Srw.set_font_face(‘Impact’) ;

Srw.set_font_weight(‘’srw.bold_weight) ;

Srw.set_font_style(‘srw.italic_style’);

Srw.set_fill_pattern(‘solid diamond’);

End if;

End;

Restricting data:

the srw.set_maxrow procedure sets the max number of records that can be retrieved for a 

specific query.

In the BEFORE REPORT trigger, you could use the srw.set_maxrow procedure to ensure that only 

the required num of records are fetched.

begin

                                    if :p_dname = 'RESEARCH' then

                                                srw.set_maxrow ('Q_2', 2);

                                                end if;

                                    end;

Running nested reports:

For running one report from another report the user has to use SRW.RUN_REPORT

Go to layout editor, create a button and label it as ‘Click this button’

Open the property palette of the button and set the Button Behaviour: Type=pl/sql: Pl/sql 

Trigger= provide the code

procedure U_ButtonButtonAction is

begin

  srw.run_report('module=C:\Documents and Settings\Administrator\Desktop\POXDETIT.rdf 

destype=Screen');

end;