Creare fisier XLS din Oracle Reports

1. se ataseaza biblioteca RPT2XLS

2. In functia Before Report se creaza Antetul si capul de tabel
Ex:
-- antetul cu numele raportului si parametrii de rulare
RPT2XLS.put_cell(1, 'Titlu', FontSize => 12, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC+RPT2XLS.UNDERLINE);
RPT2XLS.new_line;
RPT2XLS.put_cell(1, :cf_principal, FontSize => 12, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC+RPT2XLS.UNDERLINE);
RPT2XLS.new_line;
RPT2XLS.put_cell(1, 'Client:', FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.put_cell(2, :p_nume, FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.new_line;
RPT2XLS.put_cell(1, 'Nr. :', FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.put_cell(2, :p_Numar, FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.new_line;
RPT2XLS.put_cell(1, 'Valuta:', FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.put_cell(2, :p_valuta, FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.new_line;
RPT2XLS.put_cell(1, 'Emise de la ', FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.put_cell(2, to_char(:p_dela, 'dd.mm.yyyy'), FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.put_cell(3, ' - ' , FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.put_cell(4, to_char(:p_la, 'dd.mm.yyyy'), FontSize => 9, FontColor => 3, FontStyle => RPT2XLS.BOLD+RPT2XLS.ITALIC);
RPT2XLS.new_line;

-- Capul de tabel
RPT2XLS.put_cell(1, 'Client', FontStyle => RPT2XLS.BOLD, BgrColor => 15);
RPT2XLS.put_cell(2, 'Tip', FontStyle => RPT2XLS.BOLD, BgrColor => 15);
RPT2XLS.put_cell(3, 'Stare', FontStyle => RPT2XLS.BOLD, BgrColor => 15);
RPT2XLS.put_cell(4, 'Nr.', FontStyle => RPT2XLS.BOLD, BgrColor => 15);
RPT2XLS.put_cell(5, 'din Data', FontStyle => RPT2XLS.BOLD, BgrColor => 15);
RPT2XLS.put_cell(6, 'Agent', FontStyle => RPT2XLS.BOLD, BgrColor => 15);
RPT2XLS.put_cell(7, 'Valuta', FontStyle => RPT2XLS.BOLD, BgrColor => 15);
RPT2XLS.put_cell(8, 'Valoare', FontStyle => RPT2XLS.BOLD, BgrColor => 15);
RPT2XLS.put_cell(9, 'Detaliu contract', FontStyle => RPT2XLS.BOLD, BgrColor => 15);
RPT2XLS.new_line;

3. In Layout la Edit Margin

- Se defineste un buton cu eticheta XLS cu actiunea:
procedure U_Excel1ButtonAction is
begin
RPT2XLS.Run;
end;

4. La procedura AFTER REPORT se adauga comanda:
RPT2XLS.release_memory;

5. La un grup repetiv de nivel cel mai de detaliu se adauga liniile ce se exporta in XLS
RPT2XLS.put_cell(1, :client_nume);
RPT2XLS.put_cell(2, :tip);
RPT2XLS.put_cell(3, :stare);
RPT2XLS.put_cell(4, :numar);
RPT2XLS.put_cell(5, :din);
RPT2XLS.put_cell(6, :agent);
RPT2XLS.put_cell(7, :valuta);
RPT2XLS.put_cell(8, :cf_valoare);
RPT2XLS.put_cell(9, :cf_detaliu);
RPT2XLS.new_line;

6. Se ruleaza raportul in format Runtime cu optiunea de meniu:
View / Runtime Preview

Atentie: Butonul de XLS nu poate fi actionat in modul „Preview”

7. Se ruleaza raportul cf. pct. 6 si se verifica datele transmise in Excel daca sunt conforme cu cele afisate in raport

8. Se genereaza raportul si se cere confirmarea de la utilizator.

 

Oracle Report FormatTrigger


if :text1 is null then
return(FALSE);
else
if :text_bold2 ='D' then
srw.attr.mask := srw.weight_attr;
srw.attr.weight := srw.bold_weight;
srw.set_attr (0, srw.attr);
end if;

if :text_italic2='D' then
srw.attr.mask := SRW.STYLE_ATTR;
srw.attr.style := SRW.italic_STYLE;
elsif :text_underline2='D' then
srw.attr.mask := SRW.STYLE_ATTR;
srw.attr.style := SRW.underline_STYLE;
else
srw.attr.mask := SRW.STYLE_ATTR;
srw.attr.style := SRW.plain_STYLE;
end if;
srw.set_attr (0, srw.attr);

return (TRUE);
end if;

function AfterPForm return boolean is
begin

if :p_dela is null then
srw.message(21000, 'Este necesara specificarea unei date initiale');
return false;
end if;
if :p_pana_la is null then
srw.message(21000, 'Este necesara specificarea unei date initiale');
return false;
end if;
return (TRUE);
end;


 

Is Oracle Role to User


FUNCTION Is_Role_To_User(Name_Role VARCHAR2) RETURN boolean IS
BEGIN
return (DBMS_SESSION.Is_Role_Enabled(Name_Role) OR set_the_role(Name_Role));
END;

FUNCTION set_the_role(fp_rname VARCHAR2)
RETURN BOOLEAN
IS
/* ORA-1979: Missing or invalid password... */
wrong_password exception;
pragma exception_init(wrong_password, -1979);

/* ORA-1919: Role does not exist */
role_does_not_exist exception;
pragma exception_init(role_does_not_exist, -1919);
BEGIN
/*
** Call the Stored Procedure to perform the SET ROLE
*/
DBMS_SESSION.Set_Role(fp_rname);
RETURN(TRUE);
EXCEPTION
/*
** Handle the two probable errors
*/
WHEN others THEN
RETURN(FALSE);
END;


 

Citeste XLS in FORMS


DECLARE
application OLE2.OBJ_TYPE;
workbooks OLE2.OBJ_TYPE;
workbook OLE2.OBJ_TYPE;
worksheets OLE2.OBJ_TYPE;
worksheet OLE2.OBJ_TYPE;
cell OLE2.OBJ_TYPE;
args OLE2.OBJ_TYPE;
wRow NUMBER(12);
wCol NUMBER(5);

wfirma varchar2(250);
wcod_centru varchar2(32);
wtotal number;
filename varchar2(100);
al number;
cursor c(vnm in varchar2) is select 1 from table_test
where perioada=:perioade.perioada and firma like :butoane.firma
and nume=vnm;
wnr number:=0;
er number:=0;
i number:=0;

PROCEDURE OLEARG IS
args OLE2.OBJ_TYPE;
BEGIN
args := OLE2.CREATE_ARGLIST;
ole2.add_arg(args,wRow); -- row value
ole2.add_arg(args,wCol); -- column value
cell := ole2.GET_OBJ_PROPERTY(worksheet,'Cells',args); -- initializing cell
ole2.destroy_arglist(args);
END;

BEGIN

filename :=GET_FILE_NAME(:cale, File_Filter=>'Excel Files (*.xls)|*.xls|'); -- to pick the file
if filename is null then
message('Nu se mai importa fisierul',no_acknowledge);
else
message ('Asteptati importul fisierului',no_acknowledge);
SET_APPLICATION_PROPERTY(CURSOR_STYLE,'BUSY');
SYNCHRONIZE;

application := OLE2.CREATE_OBJ('Excel.Application');
ole2.set_property(application,'Visible','false');
workbooks := OLE2.GET_OBJ_PROPERTY(application, 'Workbooks');

args := OLE2.CREATE_ARGLIST;
ole2.add_arg(args,filename);
workbook := ole2.GET_OBJ_PROPERTY(workbooks,'Open',args);
ole2.destroy_arglist(args);

worksheets := OLE2.GET_OBJ_PROPERTY(workbook, 'Worksheets');

args := OLE2.CREATE_ARGLIST;
ole2.add_arg(args,1);
worksheet:=ole2.get_obj_property(worksheets,'Item',args);
ole2.destroy_arglist(args);

wRow := 2; --row number
wCol := 1; -- column number

LOOP

OLEARG;
wfirma := ole2.get_char_property(cell,'Value'); --cell value of the argument
wCol := wCol+1;
OLE2.RELEASE_OBJ(Cell);
EXIT WHEN nvl(length(wfirma),0)=0 or wfirma='';
OLEARG;
wcod_centru := ole2.get_char_property(cell,'Value'); --cell value of the argument
wCol := wCol+1;
OLE2.RELEASE_OBJ(Cell);
OLEARG;
wRow := wRow + 1;
wCol := 1;

END LOOP;

ole2.invoke(workbooks,'close');

OLE2.RELEASE_OBJ(cell);
OLE2.RELEASE_OBJ(worksheet);
OLE2.RELEASE_OBJ(worksheets);
OLE2.RELEASE_OBJ(workbook);
OLE2.RELEASE_OBJ(workbooks);
OLE2.INVOKE(application,'Quit');
OLE2.RELEASE_OBJ(application);

SET_APPLICATION_PROPERTY(CURSOR_STYLE,'DEFAULT');
SYNCHRONIZE;
if er=1 then
rollback;
raise form_trigger_failure;
else
commit;
message ('Fisierul s-a importat cu succes ',no_acknowledge);
end if;
end if;
exception
when others then
ole2.invoke(workbooks,'close');

OLE2.RELEASE_OBJ(cell);
OLE2.RELEASE_OBJ(worksheet);
OLE2.RELEASE_OBJ(worksheets);
OLE2.RELEASE_OBJ(workbook);
OLE2.RELEASE_OBJ(workbooks);
OLE2.INVOKE(application,'Quit');
OLE2.RELEASE_OBJ(application);
SET_APPLICATION_PROPERTY(CURSOR_STYLE,'DEFAULT');
SYNCHRONIZE;
set_alert_property('OK',alert_message_text,'Eroare '||sqlerrm);
al:=show_alert('OK');
rollback;
raise form_trigger_failure;
END;

go_block('table_test');
execute_query;


 

Print Report 10G on WEB

:parameter.ID_OFERTA

PROCEDURE print_oferta(p_id_oferta number) IS
I integer;
W_PRET number;
W_VALOARE number;
W_TVA number;

v_report_id Report_Object;
vc_reportserverjob varchar2(200);
vc_reportserver varchar2(200);
vc_rep_status varchar2(200);
v_job_id varchar2(200);
v_param varchar2(4000);
m varchar2(1000);
alert_button number;
BEGIN
v_report_id:=find_report_object('print_oferta');
vc_reportserver:='rep_server-app-01_app';
set_report_object_property(v_report_id, REPORT_SERVER,vc_reportserver);
set_report_object_property(v_report_id,report_comm_mode,SYNCHRONOUS);
if get_application_property(USER_INTERFACE)='WEB' then
set_report_object_property(v_report_id,report_destype,CACHE);
else
set_report_object_property(v_report_id,report_destype,SCREEN);
end if;
set_report_object_property(v_report_id,report_desformat,'PDF');
v_param := ' OFERTA='||to_char(p_id_oferta)||
' TIP_OFERTA='||replace(:ctrl.TIP_OFERTA,' ','_')||
' paramform=no';

set_report_object_property(v_report_id,report_other,v_param);

vc_reportserverjob:=RUN_REPORT_OBJECT(v_report_id);
vc_rep_status:=report_object_status(vc_reportserverjob);

v_job_id:=substr(vc_reportserverjob,length(vc_reportserver)+2,length(vc_reportserverjob));
vc_rep_status:=report_object_status(vc_reportserverjob);

if vc_rep_status='FINISHED' then
web.show_document('/reports/rwservlet/getjobid'||v_job_id||'?server='||vc_reportserver,'_blank');
elsif
vc_rep_status not in ('RUNNING','OPENING_REPORT','ENQUEUED') then
message('Report failed with error message '||vc_rep_status);
end if;
END;


 

Open Print Close MS Word Document from Forms without Showing Anything on Screen

Doc ID: Note:117638.1
Subject: Open Print Close MS Word Document from Forms without Showing Anything on Screen
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 16-AUG-2000
Last Revision Date: 30-OCT-2002

PURPOSE
––-
How to create a button on a form that will open a MS WORD document, print the document and close the file without displaying the Microsoft Word program on the screen. Also, they do not want to have to click on any messages displayed about saving the document when close the file or any messages stating that the document will not be printed if Word is shut down. This will mean that the MS Word document gets printed without any programs or messages being displayed on the screen.
SCOPE & APPLICATION
––––––-
This is for Forms application developers who want to interface Forms with MS Word documents.
OPEN PRINT CLOSE MS WORD DOCUMENT FROM FORMS WITHOUT SHOWING ANYTHING ON SCREEN
––––––––––––––––––––––––––-
There are three things that need to be taken into consideration.
1) Not displaying the MS Word program on the screen.
2) Not displaying any do you want to save messages.
3) Not displaying any messages that the document cannot be printed. The first step is to create a form that will contain a button and a WHEN-BUTTON-PRESSED trigger. Inside the trigger will be code to perform the open, print and close of the MS Word document(s) that you want printed. A normal opening of MS Word will contain the following code:
application := ole2.create_obj(‘Word.Basic’);
ole2.invoke(application, ‘AppShow’);
The first line creates a handle for Word, the second will display the MS Word program on the screen. If this line of code is not written, then MS Word will not display. Next we need to open an existing MS Word document. The following code will open a file located in C:\TEMP, called TEST.
args := ole2.create_arglist;
ole2.add_arg(args, ‘C:\temp\test.doc’);
ole2.invoke(application, ‘FileOpen’, args); ole2.destroy_arglist(args);
Now we need to print the document. The following line of code will do this:
ole2.invoke(application, ‘FilePrint’, args);
Then the file should be saved and closed. The next section has code that will perform these functions:
args := ole2.create_arglist;
ole2.add_arg(args, ‘C:\temp\test.doc’);
ole2.invoke(application, ‘FileSave’, args); ole2.destroy_arglist(args);
args := ole2.create_arglist;
ole2.add_arg(args, 2);
ole2.invoke(application, ‘FileClose’, args); ole2.destroy_arglist(args);
Next, MS Word should be exited so that the process does not stay in memory and the object handle released.
ole2.invoke(application, ‘FileExit’, args);
ole2.release_obj(application);
Now if we put all this together in the trigger and run the form, we will find that because the code is so fast, that MS Word is shut down before we can get the document printed. This usually results in a message displayed to the screen. In order to avoid this message the document should not be printed in the background. The following code will perform this function:
args := ole2.create_arglist;
ole2.add_arg(args, 0);
– 0 means no background printing,
– 1 means background printing
ole2.invoke(application, ‘FilePrint’, args);
ole2.destroy_arglist(args);
So now with all the code put together into a trigger, it should look this this:
DECLARE
application ole2.obj_type;
args ole2.list_type;
BEGIN
application := ole2.create_obj(‘Word.Basic’);
args := ole2.create_arglist;
ole2.add_arg(args, ‘C:\temp\test.doc’);
ole2.invoke(application, ‘FileOpen’, args);
ole2.destroy_arglist(args);
args := ole2.create_arglist;
ole2.add_arg(args, 0);
ole2.invoke(application, ‘FilePrint’, args);
ole2.destroy_arglist(args);
args := ole2.create_arglist;
ole2.add_arg(args, ‘C:\temp\test.doc’);
ole2.invoke(application, ‘FileSave’, args);
ole2.destroy_arglist(args);
args := ole2.create_arglist;
ole2.add_arg(args, 2);
ole2.invoke(application, ‘FileClose’, args);
ole2.destroy_arglist(args);
ole2.invoke(application, ‘FileExit’, args);
ole2.release_obj(application);
END;

 

Oracle Forms OLE2 Open DOC


IF :emp.job = 'MANAGER' THEN
SHOW_DOC('d:\aks\MANAGER.doc') ;
ELSIF :emp.job = 'CLERK' THEN
SHOW_DOC('d:\aks\CLERK.doc') ;
ELSIF :emp.job = 'PRESIDENT' THEN
SHOW_DOC('d:\aks\PRESIDENT.doc') ;
END IF ;

Create a procedure SHOW_DOC

Procedure SHOW_DOC
==================

PROCEDURE SHOW_DOC(InDoc IN VARCHAR2) IS

-- Declare the OLE object
application OLE2.OBJ_TYPE;

-- Declare handle to the OLE argument list
args OLE2.LIST_TYPE;

DocContent VARCHAR2(30);

BEGIN

-- Start WordBasic and make Word visible
application:=OLE2.CREATE_OBJ('Word.Basic');
OLE2.INVOKE(application, 'AppShow');

-- Open a Word document
args:=OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(args, InDoc);
OLE2.INVOKE(application, 'FileOpen', args);
OLE2.DESTROY_ARGLIST(args);

OLE2.INVOKE(application,'EditSelectAll');

DocContent :=OLE2.INVOKE_CHAR(application, 'Selection$');
:emp.disp := DocContent ;

-- Release the OLE object
OLE2.RELEASE_OBJ(application);

END;


 

Oracle Form OLE2 New Word Save as


DECLARE

-- Declare the OLE objects
MyApplication OLE2.OBJ_TYPE;
MyDocuments OLE2.OBJ_TYPE;
MyDocument OLE2.OBJ_TYPE;
MySelection OLE2.OBJ_TYPE;

-- Declare handle to the OLE argument list
args OLE2.LIST_TYPE;

BEGIN

-- Create the Word.Application object and make Word visible
-- by setting the 'Visible' property to true
MyApplication:=OLE2.CREATE_OBJ('Word.Application');
OLE2.SET_PROPERTY(MyApplication, 'Visible', 1);

-- get a handle on Documents collection
MyDocuments:=OLE2.GET_OBJ_PROPERTY(MyApplication, 'Documents');

-- Add a new document to the Documents collection
Mydocument :=OLE2.INVOKE_OBJ(MyDocuments,'Add');

-- get a handle on Selection object
MySelection:=OLE2.GET_OBJ_PROPERTY(MyApplication, 'Selection');

-- Insert the text 'Hello Word97!' into word document
OLE2.SET_PROPERTY(MySelection, 'Text', 'Hello Word97!');

-- Save the document to the filesystem as EXAMPLE.DOC
args:=OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(args, 'D:\temp\EXAMPLE.DOC');
OLE2.INVOKE(MyDocument, 'SaveAs', args);
OLE2.DESTROY_ARGLIST(args);

-- Close the document
OLE2.INVOKE(MyDocument, 'Close');

-- Release the OLE objects
OLE2.RELEASE_OBJ(MySelection);
OLE2.RELEASE_OBJ(MyDocument);
OLE2.RELEASE_OBJ(MyDocuments);
OLE2.RELEASE_OBJ(MyApplication);

END;

PROCEDURE wrd IS

app OLE2.OBJ_TYPE;
arg OLE2.LIST_TYPE;

BEGIN

app:=OLE2.CREATE_OBJ('Word.Basic');
OLE2.INVOKE(app, 'AppShow');

--creates a file

OLE2.INVOKE(app, 'FileNew');

--inserts text to the file
arg:=OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(arg, 'Text');
OLE2.INVOKE(app,'Insert', arg);
OLE2.DESTROY_ARGLIST(arg);

--saves the file to disk
arg:=OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(arg, 'e:\insis\proba\myfile.doc');
OLE2.INVOKE(app, 'FileSaveAs', arg);
OLE2.DESTROY_ARGLIST(arg);

OLE2.RELEASE_OBJ(app);

END;


 

Reports package SRW2

===============
RWECAT
===============

This user exit concatenates strings, appending source to the end of destination.

Syntax

SRW.USER_EXIT('rwecat source destination');

where:

source Is the string to be concatenated.
destination Is the name of the Oracle Reports object into which the string will be placed.


===============
RWEATS
===============

This user exit converts an attribute value, stored in Oracle Reports’ internal format,
to an associated string retrieved from the Oracle Reports message file.
This user exit is used by Oracle Reports when documenting your reports stored in the database
using File –> Administration –> Report Doc.

Syntax

SRW.USER_EXIT('rweats source destination attribute_num');

where:

source Is the table.column value to be converted.
destination Is the name of the Oracle Reports object into which the converted value will be placed.
attribute_num Is the attribute number of the Oracle Reports database table column.


Table Column Attributes Description
----------------------------------------------------------------------------------
SRW2_LAYOUT UNITS 1 Report Unit of Measurement

SRW2_PARAM_FORM UNITS 1 Parameter Form Unit of Measurement

SRW2_LAYOUT ORIENT 2 Panel Print Order

SRW2_LAYOUT RUN_FLAGS 3 Use Character Units in Designer

SRW2_LAYOUT RUN_FLAGS 4 Use Character Units in Browser

SRW2_LAYOUT RUN_FLAGS 5 Disable Host

SRW2_LAYOUT RUN_FLAGS 6 Disable Split

SRW2_LAYOUT RUN_FLAGS 7 Disable Zoom

SRW2_LAYOUT RUN_FLAGS 8 Start in Zoom

SRW2_LAYOUT RUN_FLAGS 9 Show Browser Title

SRW2_LAYOUT RUN_FLAGS 10 Show Browser Hint Line

SRW2_LAYOUT RUN_FLAGS 11 Show Browser Status

TOOL_PLSQL TYPE 12 Report Trigger Type

SRW2_LAYOUT SETTINGS 13 Display Settings-Report Section

SRW2_LAYOUT SETTINGS 14 Display Settings-Field Display

SRW2_LAYOUT SETTINGS 15 Display Settings-Show Comment Icons

SRW2_LAYOUT SETTINGS 16 Display Settings-Show Names

SRW2_LAYOUT SETTINGS 18 Display Settings-Show Field Outlines

SRW2_LAYOUT SETTINGS 19 Display Settings-Show Boilerplate Outlines

SRW2_LAYOUT SETTINGS 20 Display Settings-Show Frame Outlines

SRW2_LAYOUT SETTINGS 21 Display Settings-Show Page Break Icons

SRW2_LAYOUT SETTINGS 22 Display Settings-Show Page Protect Icons

SRW2_LAYOUT SETTINGS 23 Display Settings-Show Keep w/

Anchoring Icons
–––––

SRW2_LAYOUT SETTINGS 24 Display Settings-Show Anchors

SRW2_COLUMN SOURCE_ID 25 Column Source

SRW2_COLUMN COMPUTE_ID 25 Column Compute

SRW2_COLUMN RESET_ID 25 Column Reset

SRW2_FRAME GROUP_ID 25 Repeating Frame Group

SRW2_FIELD SOURCE_ID 25 Field Source

SRW2_FIELD PGN_RESET 25 Field Page Numbering Reset Repeating Frame

SRW2_COLUMN DATA_TYPE 26 Column/Parameter Datatype

SRW2_COLUMN FILE_TYPE 27 Column Format Type

SRW2_BOILERPLATE GRAPH_TYPE 27 Boilerplate Format Type Plate

SRW2_FRAME FORMATFLAG 28 Frame/RFrame Region

SRW2_FIELD FORMATFLAG 28 Field Region

SRW2_BOILERPLATE FORMATFLAG 28 Boilerplate Region

SRW2_OG_DOCUMENT FORMATFLAG 28 Oracle Graphics Document Region

SRW2_FRAME FORMATFLAG 29 Frame/RFrame Vertical Sizing

SRW2_FIELD FORMATFLAG 29 Field Vertical Sizing

SRW2_BOILERPLATE FORMATFLAG 29 Boilerplate Vertical Sizing

SRW2_OG_DOCUMENT FORMATFLAG 29 Oracle Graphics Document Vertical

Sizing
–––––

SRW2_FRAME FORMATFLAG 30 Frame/RFrame Horizontal Sizing

SRW2_FIELD FORMATFLAG 30 Field Horizontal Sizing

SRW2_BOILERPLATE FORMATFLAG 30 Boilerplate Horizontal Sizing

SRW2_OG_DOCUMENT FORMATFLAG 30 Oracle Graphics Document Horizontal Sizing

SRW2_FRAME FORMATFLAG 31 Frame/RFrame Print Condition Type

SRW2_FIELD FORMATFLAG 31 Field Print Condition Type

SRW2_BOILERPLATE FORMATFLAG 31 Boilerplate Print Condition Type

SRW2_OG_DOCUMENT FORMATFLAG 31 Oracle Graphics Document Print Condition Type

SRW2_FRAME FORMATFLAG 32 Frame/RFrame Print Condition Object

SRW2_FIELD FORMATFLAG 32 Field Print Condition Object

SRW2_BOILERPLATE FORMATFLAG 32 Boilerplate Print Condition Object

SRW2_OG_DOCUMENT FORMATFLAG 32 Oracle Graphics Document Print Condition Object

SRW2_FRAME FORMATFLAG 33 Frame/RFrame Print Condition Default

SRW2_FIELD FORMATFLAG 33 Field Print Condition Default

SRW2_BOILERPLATE FORMATFLAG 33 Boilerplate Print Condition Default

SRW2_OG_DOCUMENT FORMATFLAG 33 Oracle Graphics Document Print Condition Default

SRW2_FRAME FORMATFLAG 34 Frame/RFrame Page Break Before

SRW2_FIELD FORMATFLAG 34 Field Page Break Before

SRW2_BOILERPLATE FORMATFLAG 34 Boilerplate Page Break Before

SRW2_OG_DOCUMENT FORMATFLAG 34 Oracle Graphics Document Page Break Before

SRW2_FRAME FORMATFLAG 35 Frame/RFrame Page Break After

SRW2_FIELD FORMATFLAG 35 Field Page Break After

SRW2_BOILERPLATE FORMATFLAG 35 Boilerplate Page Break After

SRW2_OG_DOCUMENT FORMATFLAG 35 Oracle Graphics Document Page Break After

SRW2_FRAME FORMATFLAG 36 Frame/RFrame Page Protect

SRW2_FIELD FORMATFLAG 36 Field Page Protect

SRW2_BOILERPLATE FORMATFLAG 36 Boilerplate Page Protect

SRW2_OG_DOCUMENT FORMATFLAG 36 Oracle Graphics Document Page
Protect

SRW2_FRAME FORMATFLAG 37 Frame/RFrame Keep w/Anchoring

Object
–––––

SRW2_FIELD FORMATFLAG 37 Field Keep w/Anchoring Object

SRW2_BOILERPLATE FORMATFLAG 37 Boilerplate Keep w/Anchoring Object

SRW2_OG_DOCUMENT FORMATFLAG 37 Oracle Graphics Document Keep w/ Anchoring Object

SRW2_FIELD ALIGNMENT 38 Field Justification

SRW2_BOILERPLATE ALIGNMENT 38 Boilerplate Justification

SRW2_QUERY MAX_ROWS 39 Query Maximum Rows

SRW2_GROUP GLF_TYPE 40 Group Filter

SRW2_GROUP CROSS_PROD 41 Group Cross Product

SRW2_GROUP PRODUCT_ID 42 Group Within Cross Product

SRW2_COLUMN FLAGS 43 Column Use in Break

SRW2_COLUMN FLAGS 44 Column Read from File

SRW2_COLUMN OPERATOR 45 Column Function

SRW2_FRAME DIRECTION 46 Repeating Frame Print Direction

SRW2_FRAME DIRECTION 47 Repeating Frame Column Mode

SRW2_FIELD FORMATFLAG 48 Field Hidden

SRW2_FIELD PGN_FLAGS 49 Field Page Numbering Include Header

SRW2_FIELD PGN_FLAGS 50 Field Page Numbering Include Body

SRW2_FIELD PGN_FLAGS 51 Field Page Numbering Include Trailer

SRW2_BOILERPLATE TYPE 52 Boilerplate Type (Character-mode)

SRW_DISPLAY_TAG FONTSTYLE 53 Font Style

SRW_DISPLAY_TAG FONTWEIGHT 54 Font Boldness

SRW_DISPLAY_TAG FONTSIZE 55 Font Size

SRW_DISPLAY_TAG DASHSTYLE 56 Dash Appearance

SRW_DISPLAY_TAG CAPSTYLE 57 Capital Letter Style

SRW_DISPLAY_TAG JOINSTYLE 58 Joined Line Style

SRW_DISPLAY_TAG LINEPAT 59 Line Pattern

SRW_DISPLAY_TAG FILLPAT 59 Fill Pattern


SRW2_LAYOUT
===========

Name Null? Type Comment
--------------------------------------------------------------------------------------------------------------------------------------------
OWNER NOT NULL VARCHAR(30) Report Owner

MODID NOT NULL DECIMAL(10) Report ID

ITEMID NULL DECIMAL(10) Layout ID

SETTINGS NULL DECIMAL(10) Display Settings

ZOOMPOWER NULL DECIMAL(5) Magnification

UNITS NULL DECIMAL(2) Units of Measurement

ORIENT NULL DECIMAL(2) Orientation, Page Print

Order
–––

UNITS_WID NULL DECIMAL(10) Width in Units

UNITS_HGT NULL DECIMAL(10) Height in Units

CHAR_WID NULL DECIMAL(10) Character Width

CHAR_HGT NULL DECIMAL(10) Character Height

BODY_WID NULL DECIMAL(10) Body Width

BODY_HGT NULL DECIMAL(10) Body Height

PAGE_WID NULL DECIMAL(10) Page Width

PAGE_HGT NULL DECIMAL(10) Page Height

PRINT_WID NULL DECIMAL(10) Printable Area Width

PRINT_HGT NULL DECIMAL(10) Printable Area Height

X_PANELS NULL DECIMAL(10) X-Coordinate

Y_PANELS NULL DECIMAL(10) Y-Coordinate

HEADERS NULL DECIMAL(5) Number of Header Pages

TRAILERS NULL DECIMAL(5) Number of Trailer Pages

WINDOW_X NULL DECIMAL(10) Horizontal Window Location

WINDOW_Y NULL DECIMAL(10) Vertical Window Location

WINDOW_WD NULL DECIMAL(10) Window Width

WINDOW_HT NULL DECIMAL(10) Window Height

RUN_FLAGS NULL DECIMAL(5) Runtime Flags

TITLE NULL VARCHAR(250) Previewer Title

HINT NULL VARCHAR(250) Previewer Hint

STATUS NULL VARCHAR(250) Previewer Status

MAXHEADERS NULL DECIMAL(5) Maximum Header Pages

MAXTRAILERS NULL DECIMAL(5) Maximum Trailer Pages

MAXBODY_ACR NULL DECIMAL(5) Maximum Body Width

MAXBODY_DWN NULL DECIMAL(5) Maximum Body Height

INTERN_VER NULL DECIMAL(2) SRW Development

INTERN_VER2 NULL DECIMAL(4) Future Expansion

APPLSTATE NULL DECIMAL(6) Future Expansion

UIFLAGS NULL DECIMAL(10) Painter Settings Flag

GRIDINTC NULL DECIMAL(10) Grid Spacing

GRIDSNPC NULL DECIMAL(10) Number of Snap Points Per Grid Spacing

HALIGN NULL DECIMAL(1) Horizontal Alignment

VALIGN NULL DECIMAL(1) Vertical Alignment

RRECTCNR_WD NULL DECIMAL(10) Horizontal Corner Radius of Rounded Rectangle

RRECTCNR_HT NULL DECIMAL(10) Vertical Corner Radius of Rounded Rectangle

SPACING NULL DECIMAL(10) Line Spacing Setting

JUSTIFIC NULL DECIMAL(5) Justification Setting

ARROWSTYLE NULL DECIMAL(1) Arrow Style Setting

UITAG NULL DECIMAL(10) Painter Settings Display Tag

NEXTLISTID NULL DECIMAL(10) Next List ID

IDROLESLIST NULL DECIMAL(10) ID of Roles List

SRW2_DATA_MODEL
===============

Name Null? Type Comment
--------------------------------------------------------------------------------------------------------------------------------------------
OWNER NOT NULL VARCHAR(30) Report Owner

MODID NOT NULL DECIMAL(10) Report ID

ITEMID NULL DECIMAL(10) Data Model ID

SETTINGS NULL DECIMAL(10) Display Settings

DFLT_TYPE NULL DECIMAL(5) Default Type

ZOOMPOWER NULL DECIMAL(5) Magnification

WINDOW_X NULL DECIMAL(10) Horizontal Window

Location
–––

WINDOW_Y NULL DECIMAL(10) Vertical Window Location

WINDOW_WD NULL DECIMAL(10) Window Width

WINDOW_HT NULL DECIMAL(10) Window Height

UIFLAGS NULL DECIMAL(10) Painter Settings Flag

GRIDINTC NULL DECIMAL(10) Grid Spacing

GRIDSNPC NULL DECIMAL(10) Number of Snap Points Per Grid Spacing

HALIGN NULL DECIMAL(1) Horizontal Alignment

VALIGN NULL DECIMAL(1) Vertical Alignment

DECURREF_ID NULL DECIMAL(10) Reference ID Counter

LINKEDFILE NULL VARCHAR(250) Link File


SRW2_COLUMN
===========

Name Null? Type Comment
--------------------------------------------------------------------------------------------------------------------------------------------
OWNER NOT NULL VARCHAR(30) Report Owner

MODID NOT NULL DECIMAL(10) Report ID

ITEMID NULL DECIMAL(10) Column ID

NAME NULL VARCHAR(30) Column Name

TAG NULL DECIMAL(10) Display Tag

DISP_ORDER NULL DECIMAL(5) Column Display Order

GROUP_ID NULL DECIMAL(10) Group ID

SOURCE NULL DECIMAL(2) Column Source Name

SOURCE_ID NULL DECIMAL(10) Column Source ID

COMPUTE_ID NULL DECIMAL(10) Compute Group (% of Totals)

RESET_ID NULL DECIMAL(10) Reset Group ID

PROD_ORDER NULL VARCHAR(250) Product Order

NULL_VALUE NULL VARCHAR(250) Value if Null

INPUT_MASK NULL VARCHAR(250) Format Mask

OPERATOR NULL DECIMAL(2) Aggregation Function

DATA_TYPE NULL DECIMAL(2) Column Datatype

FILE_TYPE NULL DECIMAL(2) File Type/Read rom File

WIDTH NULL DECIMAL(10) Maximum Value Width

FLAGS NULL DECIMAL(5) Column Flags

PRECISION NULL DECIMAL(5) Value Precision

SCALE NULL DECIMAL(5) Value Scale

X NULL DECIMAL(10) X-Coordinate

Y NULL DECIMAL(10) Y-Coordinate

WD NULL DECIMAL(10) Column Width

HT NULL DECIMAL(10) Column Height

DFLT_LBL NULL VARCHAR(250) Default Column Label

DFLT_WID NULL DECIMAL(5) Default Column Width

DFLT_HGT NULL DECIMAL(10) Default Column Height

DEREF_ID NULL DECIMAL(10) Development Environment ID

ODATA_TYPE NULL DECIMAL(2) ORACLE Datatype

PARA_TYPE NULL DECIMAL(2) Parameter Datatype

PLOV_RTYPE NULL DECIMAL(2) List of Values Type

PLOV_SLISTID NULL DECIMAL(10) LOV Listid

PLOV_SELECT NULL VARCHAR(250) LOV SELECT Statement

PLOV_COL NULL VARCHAR(250) LOV Column

REFDTYPE NULL DECIMAL(2) Reference Datatype