Hi,

I have created a report using a "SELECT" statement using OI7.2. The report works fine with the "FOOTER" that I created for it. What I would like to do is have the footer appear directly below the report at the end, not on the bottom of every page. The reports can range from a couple of pages to only 1/2 page in size. The footer consists of some literal text. How can I do this?

TIA,

Marty

Marty,

Are you using run_report or set_printer/OIPI or ?

Hi Erik,

Thanks for the response. I have created a command line (actually a number of command lines that I concant together to form one command. So I am using "RList(Command)."

Snippet:

CMD1=LIST SCHEDULE ID-SUPP MATT_TWIN COLHEAD "3/3 MAT " JUSTLEN R4 COLFONT "Times New Roman,8" '

CMD2=BOX_TWIN COLHEAD "3/3 BOX " JUSTLEN R4 COLFONT "Times New Roman,8" COLSHADE 10% '

CMD3=MATT_TWINXL COLHEAD "3/3XLMAT " JUSTLEN R4 COLFONT "Times New Roman,8" '

.

.

.

.

CMD47=FTRFONT "Courier New,8,B,I" '

CMD48=COLHDRFONT "Times New Roman,7,B" FONT "Times New Roman,8" ID-SUPP NOT-DET-SUPP NOT-COL-HDR-SUPP NOT-HDR-SUPP NOT-DBL-SPC BOX GRID CENTER PAPERSIZE Letter LANDSCAPE SCREEN MARGINS ".25,.25,.25,.25" '

CMD=CMD1:CMD2:CMD3:CMD4:CMD5:CMD6:CMD7:CMD8:CMD9:CMD10:CMD11:CMD12:CMD13:CMD14:CMD15:CMD16:CMD17:CMD18:CMD19:CMD20:CMD21:CMD22:CMD23:CMD24:CMD25:CMD26:CMD27:CMD28:CMD29:CMD30:CMD31:CMD32:CMD33:CMD34:CMD35:CMD36:CMD37:CMD38:CMD39:CMD40:CMD41:CMD42:CMD43:CMD44:CMD45:CMD46:CMD47:CMD48

Call RList(CMD)

This will produce the desired report, but the footer is at the very bottom. I would like the data that is included in the footer to appear directly below the last page of the report.

Doing it this way allows me to use user input variables and to have better control over the placement of the report data than using REPORTER.

Marty

Marty,

A FOOTER by design is placed on each page. What you are looking for is an END PAGE functionality. This does not exist in Run_Report or RList.

You may want to change your RList reports to Run_Report reports. Run_Report will display to the preview window and allow the user to view or print or save the contents to a file.

If you need an End Page you would need to use the Set_Printer command and its messages and build the body of the report and then create your custom end page.

Sean

Hi Sean,

Thanks for the response. I have never tried SET_PRINTER but I am doing so now. It is a little more effort but I like the results a lot better. Thanks for the heads up.

Marty

View this thread on the forum...