Samples Product Information Home Page Download Pricing


There is a Print Preview button on almost every form in CleverCat which allows you to preview the current category but, for greater control of printing options, start your print job from the Printing Menu.

The Printing Menu has a Category Selection List where you can select individual categories or any number of categories for printing.

Select categories by clicking the Checkbox in the Print? column. Click the Master Select checkbox above the Print? text to select or de-select all categories.

If you assigned categories to a Category Group on the Category Editor form, you will see the Group Selector below the Selection List.

If you have a large number of categories, the Category Group selector may make it easier to select groups of related categories for printing.

Currently, Category Group is used only for organizing categories for printing but it's function may be enhanced in future versions of the software.

When you click the Print Preview button, only the first selected category in the list will be previewed. In the first example above, that is the Saws category.

Starting a print job from a Preview is often the preferred and most flexible method as it gives you access to the full range of printing options. This screenshot is of the Ribbon in Office 2007 or higher. In Office 2003, the same functions will be available on the File and View menus on the Menu Bar.
On the Ribbon, if you click the Print button you can then select a different printer or control options for the printer itself, such as Paper Tray, Printing Resolution and so on.

If you click the Print button on the Printing Menu, the selected category or categories will be sent as separate print jobs to the default printer using it's currently defined settings, in the order specified in the TOC (Table of Contents) column.

When printed to a physical printer, the fact that categories print as separate print jobs will not be noticed because they will all be queued together. When printed to a PDF, each category will be printed as a separate file and you can use the PDF writing software installed on your PC to compile all the files into one single file.
Depending on your PDF Writer, you may have to name each file as they are created or perhaps your software may be configured to append each file to the last with a single click. View the PDF Utilities tutorial for more information.

Compact Option

The Compact option offers an exception to the separate print jobs rule as described above.

When this option is selected, all categories print as if they belonged to a single category. To do this, they use the template assigned to the first selected category.
Without the Compact option, each new category starts printing at the top of a new page. With the option, new categories can start printing mid-page, following the last item in the previous category.

In this example, the HVAC category has started printing where the Saws category ends on the second row and the template being used is the one assigned to the Saws category.

When the Category Label option is used, the name of the category which starts the page is shown in the Header.

Categories will still print in the order specified in the TOC column.


Printing Options

The AutoNumber option gives you the flexibility to change the Starting Page number. There are a variety of situations where this might be used.
When multiple categories are selected for printing, page numbering is sequential across categories. If the first category were to end of page 7, the next would begin printing as page 8. However, many users insert other introductory pages before the catalog content so it is common to change to Autonumber Starting Page to something other than 1. Also, if it is necessary to reprint a single category in the middle of the catalog, you can change the Autonumber Starting Page to the correct value.

The Number Categories Using TOC Number option is useful if you know the starting page number or have already used the Rebuild Index function to generate these numbers.
You can also manually edit the values in the T.O.C. column in the Selection List and these will print as the Starting Page number for each category.
Some users will insert an introductory page or perhaps even a blank page before the first page of every category. In this case, using the TOC Numbering option will enable you to print all categories at once but still get the correct page numbering for later insertion of the additional pages.

The Rebuild T.O.C. / Index After Printing option will be discussed in the next chapter, Index Page and Table of Contents.

The Option Text prints in the Page Footer, opposite from the Page Number, if that option is chosen in the Template design.

Select one of the pre-defined options for the Option Text or enter any other text. The same selection control is also on the Category Editor form. However, if selected on that form, it applies only to the current category. If selected here, it applies to every category and overrides any entry on the Category Editor form.

The Currency Symbol option allows you to change the default symbol prefixed to fields which have been formatted as Currency on the Template Editor.
Your PC's default Currency Symbol can be changed in the Windows Control Panel, under the Regional and Language section or you can override that value by setting it here, on the Printing Menu.
Some users may prefer a space between the symbol and the numbers. For example $ 1.99 versus $1.99. You can add a space on the Windows Control Panel by simply typing a space character but, in a database, trailing spaces are automatically deleted so you must enter the special Non-Breaking Space character.
Hold down the Alt key on your keyboard and type 0160 using the Numeric Keypad. Release the Alt key to create a special character which will print as a space.


Duplex Printing Options

Duplex printing is a function of your printer or print driver software and CleverCat does not control this. What CleverCat does is to format the page elements for Duplex printing.

In this example, the elements in the Page Header - the Company Banner and the Category Label alternate sides with alternating pages. If a Page Number and Option Text are used in the Page Footer, they will alernate sides as well.
This screenshot also shows the effect of the Duplex Data option. The Product Photos as well as the text elements in the Product Display Unit can alternate sides in Grid and Dynamic style templates.


The Price Markup changes the printed values of fields which have been defined as Number or Currency on the Template Designer.

This function does not change the recorded values in the database. It only changes the printed value. Enter a Discount value as a Negative. For example, enter -10 for a 10% discount.

A Markup or Discount value can also be set on the Category Editor form and then the Individual option can be selected to use that value. The Global option applies to all categories.
If the Blank option is selected, prices will not be printed. However, if the price is a column in a Detail Table, the column will still be there. If the Hide option is selected, the column itself will not be printed and the widths of the other columns will be adjusted proportionally to fill the empty space. This last option only works correctly if the Price column is the right-most column in a Detail Table.


The Change Default Printer button changes the default printer for all Windows applications. This has the same effect as changing the default printer on the Windows Control Panel.

If you are using the Professional version of CleverCat, you will see two additional buttons for HTML/PHP and Dynamic PDF files. These files will be created in the folder specified next to the buttons. More information on creating these files can be found in the HTML / PHP Tutorials.

Dynamic PDF is not the same thing as a standard PDF file printed from your PC. Dynamic PDFs are created On-Demand directly from a mySQL database on your webserver. Use the Print Preview or Print buttons at the top of the form to create standard PDF files.

Return to Tutorial Selection or Continue to the next chapter: Index Page and Table of Contents