topleft1.gif (9199 bytes)

Upgrade to 7.2
topleft2.gif (7412 bytes)

Macon Systems, Inc.
PO Box 1388,  Colorado Springs, CO  80901
Phone: (719) 520-1555    Fax: (719) 576-7626
Email: msi@maconsys.com

 

sharedborder150.gif (1798 bytes)

Up

sharedborder150.gif (1798 bytes)

 

CHARTS IN REPORTS (6.1)

Charts can be printed in reports. Any quantity that is available to any type of section can be displayed in the chart, including table fields, formulas, and statistics. A chart displayed in a Detail section will print for each record on the report, showing values specific to each record. A chart in a Group Header Section or Group Footer Section can display summary statistics for the records contained in that group break. Likewise, a chart in the Report Header Section or the Report  Footer Section can display summary statistics for all the records in the report. There are 16 different chart types supported with a great deal of control over the details of formatting the chart. The chart types include: Line Chart, Bar Chart (Including Horizontal, and stacked charts), Spline (Curve-fitting Chart), Point Chart, Pie Chart, Area Chart (Including stacked charts), Pareto Chart (Statistical Chart), Scatter Chart, Hi-Low-Close or Candlestick Chart, Surface Charts, Polar Charts, Cube Charts, and Doughnut Charts. These charts can be displayed in either 2D or 3D.

RIGHT JUSTIFY TEXT (6.1)

Text in a text control can now be aligned both left and right at the same time, ie. newspaper style where the right edge of the paragraph is smooth.

SQL LEFT OUTER JOIN (6.1)

When data is selected from two tables in a report  with a link which uses one of the relationships =, >=, <=, <>, >, or <, there must be records in both tables which satisfy this relationship for records to appear on the report. Example: table A is the CUSTOMER table. Table B is the INVOICE table. We want a report that lists all   customers with a line for each of their invoices. If the link between table A and table B is A.custID=B.custID, this outputs a record to the report generator for every invoice record, but no record will be output for a customer that has no invoices, since the link is not satisfied. In this case, we can now use a LEFT OUTER JOIN, which is listed as *= on the list of possible relationships. Using *=, we will get a record for each matching invoice record, and for customers that have no matching invoice records, we will get one record with the invoice data fields equal to blank or zero.