47
CoolSpools Spool Converter User Guide V6R1
Page:
351
www.ariadnesoftware.co.uk
Specifies the value against which the test occurs. The value of the data item is
compared to the value specified here.
Often the special *PRV value will be needed. This denotes the previous value of
the data item. For example, in the Customer Order Report, a new section starts
when the region code changes, which is specified as:
*IF REGION_CODE *NE *PRV
Included lines
List the line types which form part of this section.
Press F4 to select from a list. Multiple selections can be made by inputting 1 against
each line type to be included in the section.
Saving the item definition
When you have finished defining the section press F9 to save your changes.
You will be returned to the main screen.
Repeat the above steps until all sections in the report for which you wish to process
data have been correctly defined to and identified by CoolSpools.
Press F14 to display the section associated with a line.
Command-line alternative
You can also add sections to a report definition using the ADDRPTSCT command.
Report sections can be changed with CHGRPTSCT, removed with RMVRPTSCT,
copied with CPYRPTSCT, displayed with DSPRPTSCT and renamed with
RNMRPTSCT.
6. Create a Report-to-XML Map
Now that you have created a report definition, CoolSpools knows how the
information in your report is structured, so when it processes your report as the input
to a conversion, it knows where to find the information the report contains and how
the various parts of the report relate to one another. Now you can use your report as
the input to the CVTSPLXML (Convert Spooled File to XML) and CVTSPLXL
(Convert Spooled File to Excel) commands in order to generate complex XML and
Excel files, but first you must tell CoolSpools how you want to structure the output
you create, i.e. the XML documents and Excel spreadsheets you create.
First, we’ll create a report
-to-XML map to create some XML. A sample Report-to-
XML map for the demo Customer Order Report DM_ORDRPT1 is supplied with
CoolSpools. A report-to-XML map tells CoolSpools how to map between a report
and a definition.
Source code for all commands shown below can be found in demo source file
DM_CLSRC supplied with CoolSpools.
Run WRKRPTXML (Work with Report-to-XML Maps) and press F6=Create or use
the CRTRPTXML (Create Report-to-XML Map) command to create a new map, e.g.
CRTRPTXML
MAPNAME(CUSTOMER_ORDERS)
REPORTNAME(CUSTOMER_ORDERS)
DFTUSEAUT(*ALLOWED)