NCR, Report Structure

NCR, Report Structure Changes

Previous Top Next

Also see: Converting an Existing Report.

Points of interest:

Do NOT place any controls in the page HEADER.
Do NOT place any controls in the page FOOTER.
Do NOT place any controls in the page FORM.

Ok, now you're wondering how you get a header and a footer and a form in your reports.... The report structures provided include new "detail" bands appropriately named: ReportHEADER, ReportFOOTER and ReportFORM. These are DETAIL bands which replace the CW "black box" bands.

As noted in the example structure below, all controls which where originally placed in the HEADER are now located in the ReportHEADER DETAIL band. The controls associated with the standard FOOTER and FORM are placed in their respective counter parts.

These new detail bands are printed only once during the report generation..... So, how do you get page numbers? NCR, with the help of RPM, will renumber the pages as required using the page renumbering built into RPM.

The existing CW HEADER, FOOTER and FORM bands are still used however, so don't delete them. The resulting position of the new ReportHEADER, ReportFOOTER and ReportFORM bands are determined by the position (X and Y coordinates) of the respective counter parts. In other words, wherever the HEADER band is positioned is where the ReportHEADER band will print in the final report.

EXAMPLE:

Report REPORT,AT(500,1500,10000,6250),PAPER(1),PRE(RPT),LANDSCAPE,THOUS
       HEADER,AT(500,500,10000,1000),USE(?cwHEADER)
       END
ReportHEADER DETAIL,AT(,,,1000),USE(?ReportHEADER),ABSOLUTE
         STRING(@D17),AT(0,0),USE(ReportRunDate),TRN,LEFT
         STRING(@T7),AT(604,0),USE(ReportRunTime),TRN,LEFT
         STRING('Pg:'),AT(8844,0),USE(?PagePrompt),TRN
         STRING('PageNumber##'),AT(9083,0),USE(?String1),TRN
         STRING('Newspaper Column Report'),AT(3438,323),USE(?String5)
         LINE,AT(156,875,9635,0),USE(?Line1),COLOR(00H)
       END
Detail DETAIL,USE(?Detail)
         STRING(@s25),AT(156,0),FONT(,8,,),USE(PEO:NAME)
         STRING(@s13),AT(3396,0),FONT(,8,,),USE(PEO:PHONE)
         STRING(@s25),AT(1760,0),FONT(,8,,),USE(PEO:CITY_STATE)
       END
ReportFOOTER DETAIL,AT(,,,250),USE(?ReportFOOTER),ABSOLUTE
         LINE,AT(198,125,9604,0),USE(?Line2),COLOR(00H)
       END
ReportFORM DETAIL,AT(,,,7500),USE(?ReportFORM),ABSOLUTE
       END
       FOOTER,AT(500,7750,10000,250),USE(?cwFOOTER)
       END
       FORM,AT(500,500,10000,7500),USE(?cwFORM)
       END
     END

As in any report, the detail AREA should be set as you would normally set it to indicate the location to include all of YOUR detail bands. The new ReportHEADER, ReportFOOTER and ReportFORM bands, as described above, use the ABSOLUTE attribute to position themselves where required independent of the detail area you use for your report body.

Hint: To create your report with accurate report formatter previews, develop the report with the appropriate controls in the HEADER, FOOTER and FORM bands, then drag these controls into the appropriate counter part bands before saving the report.

Important: Each detail band MUST have a USE() field equate and the following bands MUST be provided a FILTER:

ReportHEADER	Filter: FALSE	(never prints)
ReportFOOTER	Filter: FALSE	(never prints)
ReportFORM	Filter: FALSE	(never prints)

These bands are printed by the extension template when needed, you should NEVER print these yourself. These filters are set under Report Properties, Detail Filters.