TOADŽ for Oracle 9.0 and above provided a report writing module called "Reports Manager". One of the best features of this module is that you can
create a report, export it and share it with another TOADŽ user.
This means all those great scripts and reports we have all written over the years to help us
in managing our Oracle E-Business Suite applications have the potential to be standardised as reports
using the TOADŽ for Oracle Reports Manager and shared for FREE throughout the TOAD OEBS user community through
sites like this one.
Reports in TOADŽ Report 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
Quest Software site.
All report examples on this site are provided in PDF format. To view or download a file you must first agree to our terms and conditions and then if you wish to
download a file rather than just view the source you will need to right click on the download link and select "save link as"
All lessons posted to this 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!
- Lesson 1 - How to Create TOAD Report 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)
Templates and example reports - TRD format (zip)
- Lesson 2 - How to Create TOAD Report 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 Report 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 Report Manager reports chart (pdf) (4 Mb)
Lesson 3 - example reports - TRD format (zip)
- Lesson 4 - How to change a toadŽ report 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 Report Manager reports name and or category (pdf) (300 Kb)
- Lesson 5 - How to hide empty report rows in toadŽ report 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 texts 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 texts 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)
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.
or send us a tweet
