Choosing Report Output

Screen ID:

Screen Title:

Panel Number:

CU*BASE Report Builder (Query)

Choose Output (Print, Display, or File)

QRYOUTFM

$images\qryoutfmg_shg.gif$
Click here to magnify

This screen appears when you choose the Choose output” option on the Report Builder Main Menu.

Check out the video related to this topic: Printing the Results (More videos below!)

Helpful Resources

Learn how to print Query results.

Screen Overview

This screen is used to choose what will be produced when you run your custom report. You can choose to display the report on the screen as an online inquiry, print the report, or create a new database file from the report data.

CU*TIP: The database file option is most commonly used when creating a file to be downloaded to a PC, such as for a mass marketing mailing, for selective statement inserts, to provide to a third-party vendor, etc. You can also create a database file, then create another custom report using that file as the data source. This can be helpful if you have a very complex report to build. The first report can pull records using basic criteria, then the second report can work only with those records for more complex selection criteria.

When ready, use Enter to save changes. For the “Display on screen” option, there are no additional screens. For the “Printer” option you will proceed to the Printer Output screen next. For the “Database File” option you will proceed to the Database File Output screen next.

Field Descriptions

Field Name	Description
Send report output to	Choose one of the following options to choose what will be produced when your custom report is run: Display (1) - Use this to display this report on the screen whenever it is run. Printer (2) - Use this to send this report to a printer queue when it is run. (On subsequent screens you will be given the chance to choose the printer name page headings, and whether you want to delay the printing of the report so that you may have a chance to preview the printed report before it prints.) Database file (3) - Use this to produce a separate file containing all of the records selected by your report. (Used for downloading data to a PC, or to create more complex custom reports.)
Report should include	Choose one of the following: Detail (2) - To print the entire report, including each record and all totals/sub-totals. Summary Only (2) - To print the summary totals and sub-totals only, without any actual records.
Use line wrapping	This feature is helpful for printed reports, when there is too much information to fit across the page on one line. Check this box to “wrap” data to additional lines on the report. Be sure to also complete the Wrapping width and Keep single record together on one page fields. HINT: This feature can also be very helpful if you are displaying the results on the screen and want to avoid having to scroll left and right repeatedly to see all data. For this situation, a Wrapping width of 70 usually works well. Choose No and the system will not print any text that extends beyond the width of the page. HINT: If using line wrapping for a printed report, you may also want to double-space the report to make it easier to read. This option will appear on the next screen.
Wrapping width	Enter a number of characters from 1 to 378 to indicate the desired width of the report. Records will “wrap” to a new line when that width is reached. (Generally, individual fields will not be split between lines; if there is not room for a field on one line, the entire field wraps to the next line.) To be sure that the width is adequate for all fields and column headings, use Layout (F13) periodically to check the result.
Keep single record together on one page	Check to prevent wrapped lines from being split across pages of the printed report. Leave unchecked and a wrapped record may begin on one page and extend across the page break to the next page.

Additional Video Resources

Check out these additional video resources!

View more Query videos.

Visit the CU*BASE video library.