PIPER-Rx - Report Lessons

PIPER-Rx
Oracle E-Business Suite Resource Centre

Report Lessons

Creating and using TOADŽ Reports Manager Reports

Reports in TOADŽ Reports Manager format need a licenced copy of TOADŽ for Oracle to proceed. TOADŽ for Oracle can be obtained from your local Quest Software distrubutor or the Quest Software site.

All lessons posted to this site are provided FREE, that's right FREE, no charge, gratis, to all OEBS professionals who agree to our terms and conditions. Please also refer to our Legal Notice and Disclaimer. Remember all risk is yours alone!

TOAD Reports Manager lessons PRECIS and DOWNLOADS
Lesson 1:

How to Create TOAD Reports Manager reports

This lesson will take you through the steps required to create a set of custom report templates that you can then use to create your own reports. In this lesson, we will create both a portrait and landscape template and use the portrait template to create a simple report listing the number of self service page requests for a given day by user.
Lesson 1 - How to Create TOAD Report Manager reports (pdf) (1.2 Mb)
Lesson 1 - Templates and example reports - TRD format (zip)
Lesson 2:

How to Create TOAD Reports Manager reports that call PLSQL packages

This lesson will take you through the steps required to create a report that uses the output from a stored procedure rather than straight SQL. This process can be used for more complex reports and for reports where you want to wrap the SQL.
Lesson 2 - A step by step guide to calling a stored procedure from a TOADŽ Report (pdf)
Lesson 2 - Stored procedure and example report - TRD format (zip)
Lesson 3:

How to Create a TOAD Reports Manager reports chart

This lesson will take you through the steps required to create a simple line chart. This should you show the basics that you need to know to continue to experiment with the TOAD Report Manager chart objects.
Lesson 3 - A step by step guide to Create a TOAD Reports Manager reports chart (pdf) (4 Mb)
Lesson 3 - Example reports - TRD format (zip)
Lesson 4:

How to change a TOAD Reports Manager report name and / or category

This lesson will take you through the steps required to change a TOAD report name or the category the report is in.
Lesson 4 - A step by step guide for changing a TOAD Reports Manager reports name and or category (pdf) (300 Kb)
Lesson 5:

How to hide empty report rows in TOAD Reports Manager reports

This lesson will take you through the steps required to hide empty rows with no data.
Lesson 5 - How to hide empty report rows in toadŽ report manager reports (pdf) (700 Kb)
Lesson 5 - patches report - TRD format (zip)
Lesson 6:

How to change the colour of report text based on the text’s value

This lesson will take you through the steps required to change report text colour based on the value of the text.
Lesson 6 - How to change the colour of report text based on the text’s value (pdf) (900 Kb)
Lesson 6 - Example reports - TRD format (zip)
Lesson 7:

How to add a simple dialog box

This lesson will take you through the steps required to add a simple dialog box at the beginning of a report of the text.
Lesson 7 - How to add a simple dialog box value (pdf) (900 Kb)
Lesson 7 - Example reports - TRD format (zip)
Lesson 8:

How to create a dual scale bar and line chart

There are many instances when you wish to chart two values with vastly different scales; in this case you require a dual scale chart. This lesson will take you through the steps required to create a dual scale bar and line chart.
Lesson 8 - How to create a dual scale bar and line chart (pdf) (1.5 Mb)
Lesson 8 - Example reports - TRD format (zip)
Lesson 9:

How to preserve report headings when "No data found"

TOAD Reports Manager reports tend to not format very well when no data is found for the report unless you take action to address this. This lesson will take you through the steps required to create TOAD reports that cater for the "No data found" scenario.
Lesson 9 - How to preserve report headings when "No data found" (pdf) (0.4 Mb)
Lesson 9 - Example reports - TRD format (zip)
Lesson 10:

How to use standard and custom colours in a toad reports manager report

In this lesson we will cover the use of standard and custom colours in TOAD Report Manager reports including:

RGB and HEX colour codes
TOAD Reports Manager TColor codes
Using non-standard colours in your reports and report code

As an example we will show you how to create a report where the colour scheme changes depending on whether the instance is production or non-production environment.

Lesson 10 - How to use non-standard colours (pdf) (500 Kb)
Lesson 10 - Example report - TRD format (zip)

If you require assistance regarding using TOAD® TRD (Toad Report Definition) format here is a document on How to Import, Export & Delete TOADŽ Reports.

We are keen for your feedback on any of the lessons so if you found these useful or you have any feedback please contact us at reports@piper-rx.com.