SQL/MX Report Writer Guide

Selecting Data for a Report

HP NonStop SQL/MX Report Writer Guide—527194-002

3-3

Locating the Data

The detail lines are to be ordered by supplier with a break on SUPPLIER.SUPPNUM,

SUPPLIER.SUPPNAME, SUPPLIER.CITY, and SUPPLIER.STATE. These values are

printed in the break title. No SELECT data is needed for the page footing or report

footing.

Figure 3-1. Plan for Report Content

‘

VST0301.vsd

Supplier Parts Summary

Date:

date Time:

time

Part

Number

Available

Units

Unit Cost

(dollars)

Total Cost

(dollars)

Estimated

Profit

suppnum, suppname, city, state

nnnn

nnnn.nn

nnnnnnn.nn

nnnnnnnnn.nn nnnnnnnn.nn

suppnum, suppname, city, state

nnnn

nnnn.nn

nnnnnnn.nn

nnnnnnnnn.nn

nnnnnnn.nn

nnnnnnnn.nn

nnnnnnnnn.nn

nnnnnnnnnnn.nn

nnnnnnnn.nn

End of Summary

Page nnn