Report Sections

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.4.
For the latest version of this help file can be found here.

< Previous section  |  Table of Contents  |  Index  |  Next section >

The window associated with a report organizes options into sections.

Grouping and Sorting: Let you control how the report is organized. For example, suppose you're printing information on work orders. The Grouping options will divide the report into sections. For example, you might group your work orders by the location where the work will take place. Inside each group, you can specify subgroups if you wish.

The Sorting options tell how to sort records each each group and subgroup. For example, if you are grouping work orders by location, you might sort each group section by the date the work orders are supposed to begin. You can specify additional sorting options as well. For example, if you are sorting group sections by starting date, within each such date, you might choose to sort by expected duration; in this way, shorter jobs would be listed before longer ones.

For both Grouping and Sorting, you can specify either ascending or descending order. For example, if you sort records by date, you can go from earliest to latest or vice versa. Often, specifying Grouping options means that you don't have to specify Sorting options.

Some reports do not have a Grouping section. This is because these particular reports have a built-in grouping, or something that serves a similar purpose to grouping.

Each grouping/sorting option is followed by three buttons:


These let you change the position of the option within the list of options or delete the option entirely.

Grouping options break a report into sections. Each section has headings to indicate the start of the section, and may have footers as well. If a section has more than five entries, the total number of entries will be shown in parentheses after the group heading. Sorting options sort information within each section; they do not result in headings.

If a particular group has no elements, the group will not appear in the report. For example, suppose you're printing information about inventory items, grouped by item category. If a particular category has no items in it, that category will be omitted from the report.

If you group by some information field that has exactly the same value in all records, the column for the field will be omitted from the report.

Filters: A report filter lets you select which records you do and don't want in the report. For example, you might want to restrict a report about units to units in a particular category or range of unit IDs. Filter sections let you specify such restrictions.

Field Selection: Lets you specify what information should be included in the report. The section lists all the pieces of information that may be included in the report. Each possibility has a checkbox beside it; if you checkmark the checkbox, the information will appear in the report. Otherwise, it won't.

The first time you go to a print window during a MainBoss session, a default set of checkboxes will be checkmarked. If you change any of these, MainBoss will remember your changes throughout the rest of the session. However, when you quit MainBoss, everything gets set back to the defaults. You can save settings from one session to another; for more information, see Customized Table Settings.

For some reports, the Field Selection window may have special checkboxes. For example, some reports have a Suppress Costs checkbox; if you checkmark this checkbox, any money amounts that would otherwise be printed will be omitted from the report.

If an information field contains no data for any records in the report, the column will be omitted even if you checkmark the associated checkbox.

Some print windows will have a number of checkboxes at the bottom of the page under the heading Show Child Records. These checkboxes let you choose extra optional information that may be included in the report.

The columns in a report are made wider or narrower, depending on how many pieces of information you've asked for. Asking for many different data fields will shrink the width of each column and may make the report difficult to read. Printing a report in landscape format rather than portrait may improve readability. Another option is to export the report to Microsoft Excel; if you do that, you can avoid the problems that arise from trying to cram a lot of information onto a limited piece of paper. One other solution is to use the "Report width in pages" option discussed below.

Advanced: Lets you specify a title for the report when it is printed, the fonts to be used, and additional information.

In some reports, Advanced options let you obtain summaries. A summary typically gives totals and sub-totals of monetary amounts for the groups and sub-groups of the report. In some cases, the summary may also give you averages (e.g. the average lifespan of a particular kind of equipment). If you do not specify Grouping section options, summaries may not give you much information.

Report width in pages: By default, reports are one page wide (where the page width is dictated by your current printer settings). If a report contains many fields, you can set the value of this field to a number higher than 1; for example, if you set the field to 2, each line in the report will be two pages wide. This allows more space for the information you want to see.

When a report is more than one page wide, the effects vary depending on whether you look at the report on your monitor screen or whether you actually print it out. In a screen preview, you can simply use the usual scroll bars to look at lines that are too wide to fit on the screen. In a printed report, each line of the report will be the given number of pages wide. For example, if the report width is 2 pages, each line will be two printed pages wide. You could then tape pages together to get a more readable report.

In general, "Report width in pages" should be set to 1, unless you actually need wider lines. If you specify a large page-width when you don't need it, the report will look worse than if you use the default width. In addition, a large page-width is likely inappropriate when you're printing single work orders for workers or purchase orders for vendors—the results will probably be harder to read than the default format.

Preview: Displays a preview of the report—a version of what you'd see if you actually printed the report on paper. Preparing such a preview may take some time, since MainBoss may have to process a lot of data; therefore, you might have to wait while MainBoss creates the preview.

The Preview section has buttons that let you specify which printer you want to use, the size of page margins, and other printing details. Another button lets you export data from the report (e.g. to Microsoft Excel). Finally, the Preview section has a button that will actually print the report.

Depending on the contents of your database, certain combinations of options in Grouping, Sorting, Filters, Field Selection and Advanced may result in a report with little or no useful information. You are encouraged to experiment with the options to find combinations that are particularly helpful to your work.

For more details on any of the standard buttons in a print window, see Report Buttons.

< Previous section  |  Table of Contents  |  Index  |  Next section >