1 Building and Running a Report 2 Defining a Template 2 Creating a template=tmp_crttemp>howto 3 Adding items and objects to a template=tmp_addobj>howto 3 Modifying margin, header, or trailer objects=tmp_modify>howto 3 Modifying the color, pattern, or border of body objects=tmp_modify_body>howto 2 Applying a template to a report=tmp_applytemp>howto 2 Adding a template to the predefined templates list=tmp_addtemppre>howto 3 Working with Parameters 4 Using a pre-defined system parameter=c_sysparm>howto 4 Creating a user parameter=c_userparm>howto 4 Creating a list of values (LOV) for a parameter=c_parmlov>howto 4 Validating a parameter value at runtime=c_valparm>howto 3 Using PL/SQL in a Template 4 Creating links for Web Reports Using PL/SQL 5 Creating links for HTML Output 6 Creating HTML Headers and Footers 7 Creating an HTML document header=c_plsqlbefrptesc>howto 7 Creating an HTML document footer=c_plsqlaftrptesc>howto 7 Creating an HTML page header=c_plsqlbefpgesc>howto 7 Creating an HTML page footer=c_plsqlaftpgesc>howto 7 Creating an HTML Parameter Form header=c_plsqlbeffrmesc>howto 7 Creating an HTML Parameter Form footer=c_plsqlaftfrmesc>howto 6 Adding navigation controls for HTML page-streamed output using PL/SQL=c_plsqlnavctrls>howto 6 Creating a hyperlink=c_plsqlhyperlink>howto 6 Creating a bookmark=c_plsqlbookmk>howto 6 Creating a hyperlink destination=c_plsqllinktag>howto 5 Creating links for PDF Output 6 Creating a hyperlink=c_plsqlhyperlink>howto 6 Creating a bookmark=c_plsqlbookmk>howto 6 Creating an application command line link=c_plsqlaction>howto 6 Creating a hyperlink destination=c_plsqllinktag>howto 4 Creating or Editing Template-Level PL/SQL 5 Creating or Editing a Template-Level Program Unit 6 Creating a local program unit=c_clpu>howto 6 Creating a stored program unit=c_cspu>howto 6 Editing a program unit=c_edtpu>howto 6 Deleting a program unit=c_delpu>howto 6 Importing source code from a text file=c_impsc>howto 4 Creating a report trigger=c_crtrt>howto 4 Deleting a report trigger=c_delrt>howto 4 Creating a button to execute PL/SQL=c_cbutt>howto 4 Saving source code to a file=c_savsc>howto 4 Creating or Editing Object-Level PL/SQL 5 Creating or editing a format trigger=c_crtedtfrmtrg>howto 5 Creating or editing an action trigger=c_crtedtacttrg>howto 3 Running a program unit in the PL/SQL Interpreter=c_run>howto 3 Moving a program unit between client and server=c_movecs>howto 4 Creating or Editing an External PL/SQL Library 5 Creating an external PL/SQL library=c_crtlib>howto 5 Adding a program unit to an open library=c_apu2l>howto 5 Removing a program unit from an open library=c_rempu>howto 5 Editing a program unit in an open library=c_epul>howto 5 Attaching a library=c_attach>howto 4 Compiling Program Units in a Template or Open Library 5 Compiling all program units=c_compall>howto 5 Compiling a single program unit=c_compone>howto 3 Searching and replacing text in a program unit=c_frtsc>howto 2 Building a Report 3 Displaying a section layout view=c_displayview>howto 3 Building a standard report=c_crtrpt>howto 3 Setting properties for a section=c_setpropsect>howto 4 Building a multi-query group above report=c_crptgamq>howto 4 Building a nested matrix report=c_crptnstmatx>howto 4 Building a multimedia report=c_crptmultimed>howto 4 Building an OLE2 report=c_crptole2>howto 3 Defining a Query :Include qbuilder.cnt 3 Creating a local query=c_crtqry>howto 3 Creating an external (shareable) query=c_crtextq>howto 3 Creating a break group=c_crtbrkgrp>howto 3 Creating a cross-product (matrix) group=c_crtxgrp>howto 3 Creating a data link=c_crtlink>howto 2 Creating a default layout for a report=c_deflay>howto 2 Creating a default layout for a section=c_crtlaysect>howto 2 Preparing a report for the World Wide Web=c_crtwww>howto 2 Setting properties for an ASCII (character-mode) report=c_crtascii>howto 2 Converting a bit-mapped report to ASCII (character mode)=c_convbm>howto 2 Preparing a multi-platform report=c_crtmulplat>howto 2 Preparing a report for translation into other languages=c_crtnls>howto 2 Running and Dispatching a Report 3 Distributing a report to multiple destinations=c_distmultdest>howto 3 Running and dispatching a bit-mapped report=c_runbm>howto 3 Running and dispatching an ASCII report=c_runcm>howto 3 Running a report from the command line=runcmdlin>howto 3 Running a report using a command file=runcmdfil>howto 3 Running a report to a remote Reports Server=c_runrptsrv>howto 3 Running a report from Form Builder or Graphics Builder=c_runofog>howto 3 Viewing Report Output 4 Displaying output in the Live Previewer=viewlprev>howto 4 Displaying output in the Runtime Previewer=viewprev>howto 4 Displaying output in your Web browser=diswebbrw>howto 4 Displaying individual pages of HTML report output=c_indivpgs>howto 3 Printing a Report 4 Printing a report on a pre-printed form=c_runppform>howto 4 Printing a report from the Runtime Previewer=printprev>howto 4 Printing a report from your Web browser=printhtml>howto 3 Emailing a Report via MAPI 4 Emailing a report in batch mode=c_mapibatch>howto 4 Emailing a report from Report Builder=c_mapinobatch>howto 2 Changing orientation=c_orient>howto 2 Switching the printer tray=printtray>howto 2 Adding Items and Objects to a Report 3 Creating a Total, Formula, or Placeholder Column 4 Creating a summary column (for total or subtotals)=c_crtcolsum>howto 4 Creating a formula column=c_crtcolfor>howto 4 Creating a placeholder column=c_crtcolplc>howto 3 Creating Page Numbers or Date/Time Stamps 4 Creating page numbers=c_crtlopgno>howto 4 Resetting page numbers=c_pgnoreset>howto 4 Creating a date and/or time stamp=c_crtlotmdt>howto 3 Creating links for Web Reports 4 Creating links for HTML Output 5 Creating HTML Headers and Footers 6 Creating an HTML document header=c_befrptesc>howto 6 Creating an HTML document footer=c_aftrptesc>howto 6 Creating an HTML page header=c_befpgesc>howto 6 Creating an HTML page footer=c_aftpgesc>howto 6 Creating an HTML Parameter Form header=c_beffrmesc>howto 6 Creating an HTML Parameter Form footer=c_aftfrmesc>howto 6 Adding navigation controls for HTML page-streamed output=c_navctrls>howto 4 Creating a hyperlink=c_hyperlink>howto 5 Creating a bookmark=c_bookmk>howto 5 Creating a hyperlink destination=c_linktag>howto 5 Selecting an image URL from the database=c_selurl>howto 5 Linking an image object to a URL=c_crtbpurl>howto 5 Adding HTML Tags to a Report 6 Creating a boilerplate text object for HTML tags=c_txthtml>howto 6 Linking an HTML object to a file=c_filhtml>howto 6 Selecting HTML tags from the database=c_dbhtml>howto 4 Creating links for PDF Output 5 Creating a hyperlink=c_hyperlink>howto 5 Creating an application command line link=c_action>howto 5 Creating a bookmark=c_bookmk>howto 5 Creating a hyperlink destination=c_linktag>howto 3 Creating a Graphics, Video, Sound or OLE2 Object 4 Creating a drawing object=c_crtlodraw>howto 4 Creating a Graphics Builder chart=c_crtchart>howto 4 Embedding an existing Graphics Builder display=c_embedchart>howto 4 Creating an Image Object 5 Selecting an image from the database=c_selimgdb>howto 5 Selecting an image URL from the database=c_selurl>howto 5 Linking an image object to a file=c_rdimgfil>howto 5 Linking an image object to a URL=c_crtbpurl>howto 5 Importing an image=c_impgraph>howto 5 Creating a button for an image object=c_crtbutimg>howto 4 Creating an OLE2 Object 5 Selecting an OLE2 object from the database=c_seloledb>howto 5 Linking an OLE2 object to a file=c_rdolefil>howto 4 Creating a Sound and/or Video Object 5 Selecting a sound or video object from the database=c_selsvdb>howto 5 Creating a button for a sound or video object=c_crtbutimg>howto 3 Creating a large image and/or sound object=c_crtcollgis>howto 3 Importing and exporting a drawing, color palette, or image=c_impgraph>howto 3 Creating a Page or Group Header or Footer 4 Creating a text heading=c_crtmarg>howto 4 Creating a heading that includes database values=c_crthddbv>howto 4 Creating a group header or footer=c_crthdft>howto 3 Creating an Object in the Margin, Header Page, or Trailer Page 4 Creating a margin object=c_crtmarg>howto 4 Creating a header page or trailer page object=c_crthdtrlr>howto 2 Creating a barcode=c_barcode>howto 3 Creating a Text Object 3 Creating a boilerplate object for text=c_crtlobp>howto 3 Typing text directly in the report=c_crtlotxtdir>howto 3 Referencing a field in boilerplate text=c_crtlotxtref>howto 3 Linking a text object to a file=c_rdimgfil>howto 3 Importing text into a boilerplate object=c_imptxtbp>howto 3 Creating a Layout Object 3 Creating a field=c_crtfld>howto 3 Creating a frame or repeating frame=c_crtframe>howto 2 Modifying a Report 3 Modifying a query=c_chgqry>howto 3 Modifying Text 4 Editing text=c_editbptxt>howto 4 Changing text attributes=c_chgtxtattr>howto 4 Applying conditional formatting to an object=c_condform>howto 4 Wrapping text in a field=c_wraptxt>howto 3 Modifying Object Borders 4 Changing object border attributes=c_attbrdr>howto 4 Showing or hiding object borders=c_chgbrdr>howto 3 Changing Colors and Patterns 4 Changing colors=c_chgcolor>howto 4 Changing patterns=c_chgpattern>howto 4 Applying conditional formatting to an object=c_condform>howto 3 Assigning a Format Mask 4 Applying a format mask to a numeric object=c_applymask>howto 4 Applying a format mask to a date object=c_applydate>howto 3 Moving Objects 4 Moving multiple objects=c_mvobjs>howto 4 Moving an object outside its parent=c_mvoutpar>howto 4 Adjusting parent borders automatically=c_adjparbord>howto 4 Moving a column in report output=c_movcol>howto 4 Aligning objects=c_algnlo>howto 4 Moving an anchor=c_moveanch>howto 4 Changing object layering=c_moverel>howto 4 Rotating a boilerplate object=c_rotbp>howto 3 Resizing Objects 4 Adjusting parent borders automatically=c_adjparbord>howto 4 Resizing an object=c_resizso>howto 4 Making multiple objects the same size=c_multsamsiz>howto 2 Adjusting margins=c_adjmarg>howto 3 Changing Spacing 4 Changing column widths=c_colwidth>howto 4 Changing spacing within a field=c_fldspac>howto 4 Changing the default layout spacing=c_deflaywhite>howto 4 Changing the space between all rows=c_chgspcrec>howto 4 Adding blank lines between groups of rows=c_addlines>howto 2 Adding a page break=c_crtpgbrk>howto 2 Anchoring objects together=c_crtloanch>howto 2 Working with Parameters and the Parameter Form 3 Displaying the Parameter Form at runtime=c_dispf>howto 3 Using a pre-defined system parameter=c_sysparm>howto 3 Creating a user parameter=c_userparm>howto 3 Creating a list of values (LOV) for a parameter=c_parmlov>howto 3 Creating a default Parameter Form=c_crtdefpf>howto 3 Validating a parameter value at runtime 4 Validating a parameter value at runtime=c_valparm>howto 4 Creating HTML Parameter Form input and select events=c_pf_validation>howto 3 Modifying the Parameter Form 4 Selecting parameters to include in the Parameter Form=c_selparms>howto 4 Adding more pages to the Parameter Form=c_addpgpform>howto 3 Creating a field=c_crtfld>howto 4 Adding and Modifying Text 5 Creating a boilerplate object for text=c_crtlobp>howto 5 Typing text directly in the editor=c_crtlotxtdir>howto 5 Importing text into a boilerplate object=c_imptxtbp>howto 5 Referencing a field in boilerplate text=c_crtlotxtref>howto 5 Editing text=c_editbptxt>howto 5 Changing text attributes=c_chgtxtattr>howto 5 Wrapping text in a field=c_wraptxt>howto 4 Adding Graphics 5 Creating a drawing object=c_crtlodraw>howto 5 Importing and exporting a drawing, color palette, or image=c_impgraph>howto 3 Showing or hiding object borders=c_chgbrdr>howto 4 Changing colors and patterns 5 Changing colors=c_chgcolor>howto 5 Changing patterns=c_chgpattern>howto 4 Moving Objects 5 Moving multiple objects=c_mvobjs>howto 5 Aligning objects=c_algnlo>howto 5 Changing object layering=c_moverel>howto 5 Rotating a boilerplate object=c_rotbp>howto 4 Resizing Objects 5 Resizing an object=c_resizso>howto 5 Making multiple objects the same size=c_multsamsiz>howto 4 Changing spacing within a field=c_fldspac>howto 2 Using PL/SQL in a Report 3 Creating links for Web Reports Using PL/SQL 4 Creating links for HTML Output 5 Creating HTML Headers and Footers 6 Creating an HTML document header=c_plsqlbefrptesc>howto 6 Creating an HTML document footer=c_plsqlaftrptesc>howto 6 Creating an HTML page header=c_plsqlbefpgesc>howto 6 Creating an HTML page footer=c_plsqlaftpgesc>howto 6 Creating an HTML Parameter Form header=c_plsqlbeffrmesc>howto 6 Creating an HTML Parameter Form footer=c_plsqlaftfrmesc>howto 6 Adding navigation controls for HTML page-streamed output using PL/SQL=c_plsqlnavctrls>howto 4 Creating a hyperlink=c_plsqlhyperlink>howto 5 Creating a bookmark=c_plsqlbookmk>howto 5 Creating a hyperlink destination=c_plsqllinktag>howto 4 Creating links for PDF Output 5 Creating a hyperlink=c_plsqlhyperlink>howto 5 Creating a bookmark=c_plsqlbookmk>howto 5 Creating an application command line link=c_plsqlaction>howto 5 Creating a hyperlink destination=c_plsqllinktag>howto 2 Using a built-in package=c_builtin>howto 3 Creating or Editing Report-Level PL/SQL 4 Creating or Editing a Report-Level Program Unit 5 Creating a local program unit=c_clpu>howto 5 Creating a stored program unit=c_cspu>howto 5 Editing a program unit=c_edtpu>howto 5 Deleting a program unit=c_delpu>howto 5 Importing source code from a text file=c_impsc>howto 3 Creating a report trigger=c_crtrt>howto 3 Deleting a report trigger=c_delrt>howto 3 Creating a button to execute PL/SQL=c_cbutt>howto 3 Exporting source code to a text file=c_savsc>howto 3 Creating or Editing Object-Level PL/SQL 4 Creating or editing a group filter=c_crtedtgrpfil>howto 4 Creating a formula column=c_crtcolfor>howto 4 Creating a placeholder column=c_crtcolplc>howto 4 Creating or editing a format trigger=c_crtedtfrmtrg>howto 4 Creating or editing an action trigger=c_crtedtacttrg>howto 4 Applying conditional formatting to an object=c_condform>howto 2 Running a program unit in the PL/SQL Interpreter=c_run>howto 2 Moving a program unit between client and server=c_movecs>howto 3 Creating or Editing an External PL/SQL Library 4 Creating an external PL/SQL library=c_crtlib>howto 4 Adding a program unit to an open library=c_apu2l>howto 4 Removing a program unit from an open library=c_rempu>howto 4 Editing a program unit in an open library=c_epul>howto 4 Attaching a library=c_attach>howto 3 Compiling Program Units in a Report or Open Library 4 Compiling all program units=c_compall>howto 4 Compiling a single program unit=c_compone>howto 4 Compiling all uncompiled program units=c_compunc>howto 2 Searching and replacing text in a program unit=c_frtsc>howto 2 Debugging a Report 3 Running a program unit in the PL/SQL Interpreter=c_run>howto 3 Changing the Object Navigator display settings=c_custon>howto 3 Tracing report execution=c_trace>howto 3 Tracing report distribution=c_tracedist>howto 3 Setting a breakpoint=c_sbk>howto 3 Setting a debug trigger=c_sdt>howto 3 Inserting a Navigator pane in the Interpreter=c_insnav>howto 3 Stepping through the code=c_step>howto 3 Examining or changing local variables=c_exvar>howto 3 Disabling or enabling a debug action=c_disen>howto 3 Editing a debug action=c_eda>howto 3 Deleting a debug action=c_rda>howto 2 Integrating with Other Products :Include xrq.cnt 2 Building a user exit=c_userexit>howto 2 Building a procedure call=c_callintfce>howto 2 Accessing non-Oracle datasources=c_openint>category 2 Administering Report Builder 3 Allowing and disallowing access to a report=c_grntrvkdoc>howto 3 Setting a database role=c_dbroles>howto