Choosing Report Output

Screen ID: 

Screen Title: 

Panel Number:

images\kb_closed_shg.gif

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.

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

View more Query videos.

Visit the Show Me the Steps video library to view more videos!

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#qryoutfmg.htm