Download Spool Converter User Guide

Worked Example: Using report definitions and maps
SUPER SUN SEEDS – Customer Order Report
This worked example used the dummy SUPER SUN SEEDS company and the
Customer Order Report DM_ORDRPT1. This demo report is supplied with
CoolSpools as a stream file and it located in the IFS at
/ariadne/CoolSpoolsV6R1/samples/DM_ORDRPT1.SPL
It can be restored to you system as a spooled file by running:
COOLSPV6R1/RSTSPLF
FROMSTMF(‘/ariadne/CoolSpoolsV6R1/samples/DM_ORDRPT1.SPL')
NEWOWN(*CURRENT)
A sample report definition called DM_ORDRPT1 corresponding to this dummy report
is supplied with CoolSpools.
The steps below explain how to create a report definition which describes the
structure and semantic content of a report so that report can be used to generate
meaningful XML and complex Excel files. We suggest you follow the steps below
either against the demo DM_ORDRPT1 Customer Order Report or a report of your
own. You can check and compare what you do against the DM_ORDRPT1 report
definition supplied with CoolSpools.
1. Create the Report Definition
Run WRKRPTDFN (Work with Report Definitions) and press F6=Create or use the
CRTRPTDFN (Create Report Definition) command, e.g.
CRTRPTDFN
REPORTNAME(CUSTOMER_ORDERS)
TEXT('Customer Order Report')
DATFMT(*MDY)
DATSEP('/')
CURSYM('$')
DECPOINT('.')
THOUSANDS(',')
This creates a new report definition called CUSTOMER_ORDERS. You can now
specify the layout of the report either by adding lines to it with ADDRPTLIN or by
specifying lines on screen using DSNRPTDFN (Design Report Definition). We’ll do
things on screen in this example.
2. Design the Report Definition
Run WRKRPTDFN (Work with Report Definitions) and take option 11 against report
definition DM_ORDRPT1 or use the DSNRPTDFN (Design Report Definition)
command e.g.
DSNTRPTDFN
REPORTNAME(CUSTOMER_ORDERS)
You now need to select a sample spooled file or the right type to use as the base for
specifying the report layout. By default, you will be prompted with a list of spooled
CoolSpools Spool Converter User Guide V6R1
www.ariadnesoftware.co.uk
Page: 331