Click on a header to jump to the corresponding section.<\/p>\n
- \n
- Accessing the Report Designer<\/strong><\/a><\/li>\n
- Modifying a Report<\/strong><\/a><\/li>\n
- Report Designer Tabs<\/strong><\/a><\/li>\n
- Editing the Form<\/strong><\/a><\/li>\n
- Adding a Field<\/strong><\/a><\/li>\n<\/ul>\n
<\/a>Accessing the Report Designer<\/h3>\n
There are two different ways you can access the report designer. From the “Tool Bar<\/strong>,” click on “Reports<\/strong>,” then “Report Designer<\/strong>.”<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-02_15h41_32.png\")
<\/a><\/p>\nOr, from the “Main Menu<\/strong>,” click on “Reports<\/strong>.”<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-02_15h42_02.png\")
<\/a><\/p>\nClick on the “Report Designer<\/strong>” button.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-02_15h42_30.png\")
<\/a><\/p>\nEither way, you’ll end up at the following screen.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-02_15h45_06-1.png\")
<\/a><\/p>\nThis screen contains all reports, both built-in and custom-made.<\/p>\n
<\/a>Modifying a Report<\/h3>\n
Built-in reports cannot be modified, but a copy can be made to edit. Highlight the report you want to edit and press Alt and F3 on your keyboard to copy the record. Edit the copy instead of the original record.<\/strong><\/span><\/p>\n
Click on “Edit Form<\/strong>.”<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-02_15h45_53.png\")
<\/a><\/p>\nYou’ll need to rename this form before you can save the form and start working on it. <\/span><\/strong>To do so, click on the “Report<\/strong>” tab and “Summary<\/strong>” option within the Report Designer.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-02_15h57_06.png\")
<\/a><\/p>\nRename the “Report Name<\/strong>” and “Report Title<\/strong>” as you see fit. Click “OK.<\/strong>“<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-02_15h58_06.png\")
<\/a><\/p>\n\u00a0<\/p>\n
<\/a>Report Designer Tabs<\/h3>\n
At the top of the report designer are different tabs to choose from. These tabs contain dropdown fields that allow you to modify or adjust the report.<\/p>\n
File<\/h4>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-03_08h29_08.png\")
<\/a><\/p>\nClose: <\/strong>You may exit the report designer by clicking “close<\/strong>” (or the red “X<\/strong>” on the top right of the report designer screen).<\/p>\n
Page Setup:\u00a0<\/strong>This allows you to control the overall size of the report.\u00a0<\/p>\n
- \n
- Paper Size<\/strong><\/li>\n<\/ul>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-03_08h40_10.png\")
<\/a><\/p>\nThis is the size of the paper your report will print onto. The default size is set to US-Letter, 8.5 x 11 inches, which is the standard printing paper size. Keep in mind how many fields, columns, and so on you’re including in the report, as smaller paper types might cut off information if the margins aren’t properly adjusted.<\/p>\n
- \n
- Orientation<\/strong><\/li>\n<\/ul>\n
This determines if the report will print vertically (portrait) or horizontally (landscape). You’ll notice as these options are toggled, the width, height, and margins automatically adjust.\u00a0<\/p>\n
- \n
- Margins<\/strong><\/li>\n<\/ul>\n
These are the boundaries of the report–the space between the text and the edge of the page. We recommend leaving these fields alone. However, if you need more or less space, adjust the boundaries incrementally until you have the results you want.\u00a0<\/p>\n
Import Subreport:\u00a0<\/strong>This allows you to select a report from your computer to combine with this report.<\/p>\n
\nEdit<\/h4>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-03_08h59_35.png\")
<\/a><\/p>\nMost of these fields are self-explanatory. For example, “Undo<\/strong>” will remove the previous change you made, while “Redo<\/strong>” will restore that change.\u00a0<\/p>\n
- \n
- Delete Selected Fields<\/strong><\/li>\n<\/ul>\n
This is handy if you need to delete more than one field. Hold shift on the keyboard and click with your mouse to select more than one field to delete.<\/p>\n
- \n
- Delete Group<\/strong><\/li>\n<\/ul>\n
This option will only be accessible if the field selected is classified as a “group<\/strong>” field.<\/p>\n
- \n
- Delete Section<\/strong><\/li>\n<\/ul>\n
This option will only be accessible if the field selected is classified as a “section<\/strong>” field.<\/p>\n
\nInsert<\/h4>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-03_10h46_05.png\")
<\/a><\/p>\nThis tab lets you add fields to the form, from text, to columns, to images, and more. We’ll go over how this tab functions in detail later.\u00a0<\/p>\n
\nFormat<\/h4>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-03_10h48_06.png\")
<\/a><\/p>\nThis tab includes additional ways you can edit a field.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_10h56_27.png\")
<\/a><\/p>\n- \n
- Format Field<\/strong><\/li>\n<\/ul>\n
Adjust the text’s font, size, and other characteristics, such as bold, italic, and underline.\u00a0<\/p>\n
- \n
- “Word Wrap<\/strong>”\u00a0\u00a0<\/li>\n<\/ul>\n
Checking this field off means the text will move down to the next line once it reaches the edge of the text box.<\/p>\n
- \n
- “Comma Wrap<\/strong>“<\/li>\n<\/ul>\n
Checking this field off means that any time a comma is used in the text box, the text after that will go to the next line.<\/p>\n
- \n
- “Grow Vertically to Fit Content<\/strong><\/li>\n<\/ul>\n
Automatically adjusts the text box to expand downward as necessary.<\/p>\n
Information on “Format<\/strong>” and “Translate Names<\/strong>” will be included in this article soon.<\/em><\/span><\/p>\n
Bar Code Format<\/strong><\/p>\n
- \n
- Bar Code Type<\/strong><\/li>\n<\/ul>\n
We recommend leaving this section alone unless instructed by our tech support team.<\/p>\n
Align<\/strong><\/p>\n
The alignment causes the text or barcode to be flush left, right, or center within the field itself.<\/p>\n
Color<\/strong><\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_13h19_42.png\")
<\/a><\/p>\nYou may pick a swatch with the color dropper tool to update the text’s color. Or, you may use the other tabs for more control over mixing hues.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_13h20_04.png\")
<\/a><\/p>\nInversing colors will switch the foreground colors to the background, and vice versa. Be mindful of your printer’s color capabilities and the color paper you’re printing on.<\/p>\n
Border<\/strong><\/p>\n
This tab contains all parameters for a field’s border. A “count” set to “none” will not show a border line. You may have up to three lines on each side in a solid, dot, or dash style.\u00a0<\/p>\n
Examples:<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_13h13_29.png\")
<\/a> ![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_13h15_01.png\")
<\/a><\/p>\n
\nDatabase<\/h4>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_11h16_45.png\")
<\/a><\/p>\nThe database tab contains the “Table Linker<\/strong>.” The table linker connects report fields to Artisan code, which affects what appears on your report. We recommend leaving this section alone unless instructed by technical support.\u00a0<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_11h15_05.png\")
<\/a><\/p>\nThis tab also includes “SQL Query<\/strong>.” This is particularly helpful when identifying any problems within the report. The staff might ask to see this information when repairing a report, which you can copy and paste into a support ticket.\u00a0<\/p>\n
\nReport<\/h4>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_11h31_35.png\")
<\/a><\/p>\nThe first few tabs contain shortcuts to run or view the report, export or save a copy on your computer, or send it over email. The other sections contain options to sort, select, and view additional report information.<\/p>\n
Run<\/strong><\/p>\n
You may run the report without having to exit out of the report designer area. Enter any parameters you wish, such as keywords, date range, and location, if applicable. Press “View Report<\/strong>” to open the report on your computer or “Print<\/strong>” to print a copy. When you’re finished, Artisan will return to the report designer.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_11h19_03.png\")
<\/a><\/p>\nExport<\/strong><\/p>\n
This screen lets you save the report from a variety of fields, such as .PDF or .XLS.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_11h20_59.png\")
<\/a><\/p>\nChoose a location to save this copy of the report and press “Save<\/strong>.”<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_11h21_09.png\")
<\/a><\/p>\nEmail<\/strong><\/p>\n
Easily send the report right from Artisan. Enter the email address you’re sending to. Adjust the subject and text field as you see fit. When you’re finished, press “Send<\/strong>.”<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_11h23_59.png\")
<\/a><\/p>\n<\/a>Editing the Form<\/h3>\n
You may edit already existing fields or add new fields. When editing a field, the border around the field turns blue.<\/p>\n
Adjusting Placement<\/strong><\/p>\n
If you need to adjust the field’s placement, use the arrow keys on your keyboard to shift the field from left to right. For more control, right-click and select “Position and Size<\/strong>.” We’ll go over this screen in a moment.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_09h08_10-2.png\")
<\/a><\/p>\nHide:\u00a0<\/strong>This screen allows you to hide a field if necessary. We recommend not altering this screen without instructions from the support staff.\u00a0<\/p>\n
Delete:\u00a0<\/strong>Selecting this option will remove\/erase the selected field.<\/p>\n
Replace Field Source:\u00a0<\/strong>Selecting this option causes any field that is placed on the form (using the “Insert<\/strong>” option or “Field Picker<\/strong>“) to assume the position, size, border, and format of this field.<\/p>\n
Position and Size:\u00a0<\/strong>This screen lets you edit the field’s position on the page, as well as the overall size of the field. The “Y<\/strong>” axis is the vertical position while the “X<\/strong>” axis is where the field is placed horizontally. Adjusting the “X<\/strong>” axis moves the field up and down while adjusting the “Y<\/strong>” axis moves the field left to right. For example, this field is currently at a Y-Axis of 0.0 and an X-Axis of 7.0.\u00a0<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_09h16_55.png\")
<\/a><\/p>\nInputting a new Y-Axis number, 10, moves the field down.\u00a0<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_09h20_03.png\")
<\/a><\/p>\nNotice how the field moved from its original position.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_09h20_41.png\")
<\/a><\/p>\nSections<\/h4>\n
As well as headers, footers, and columns, you may also organize information via sections and groups.\u00a0<\/p>\n
A “detail<\/strong>” is any section between the headers and footers. If you have more than one detail section, Artisan will name the sections Detail (a), Detail (b), and so on.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-07_15h15_16.png\")
<\/a><\/p>\nTo create a section, right-click and select either “Insert Section Above<\/strong>” or “Insert Section Below<\/strong>.”<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-07_15h14_28.png\")
<\/a><\/p>\nYou may manually adjust the height of these sections by pulling on the lines separating each section.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/Adjusting-section-height.gif\")
<\/a><\/p>\nAdditional Tools<\/h4>\n
Right-clicking on the form reveals additional tools.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_13h33_45.png\")
<\/a><\/p>\nSuppress<\/strong><\/p>\n
Selecting this option opens the “Suppression” window. This is used to tell the report designer to ignore certain codes (information) on the report.\u00a0<\/p>\n
Background Color<\/strong><\/p>\n
This will change the background of the section of the report you’re editing. Remember that all printers will not print colors accurately, and be mindful that dark text on a dark background is difficult to read.<\/p>\n
Before:<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_13h42_32-1024x315.png\")
<\/a><\/p>\nAfter:<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_13h42_44.png\")
<\/a><\/p>\nNew Page Before<\/strong><\/p>\n
This will cause the report, when viewed or printed, to have a blank page before the first page.<\/p>\n
Shrink to Fit<\/strong><\/p>\n
This will cause the section to compress around whatever information is in the section, eliminating unnecessary blank space above and below the field.<\/p>\n
Before:<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-07_15h23_51.png\")
<\/a><\/p>\nAfter:<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-07_15h24_12.png\")
<\/a><\/p>\nSelect All In Section<\/strong><\/p>\n
This grabs everything in the section, which is especially helpful if you want to move more than one field at a time, or adjust the field’s font, size, etc.<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-07_15h27_08.png\")
<\/a><\/p>\n<\/a>Adding a Field to a Report<\/h3>\n
To add a field to a report, click on “Insert<\/strong>” and “Database Field<\/strong>.”<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_08h39_14.png\")
<\/a><\/p>\nThis opens up all fields that will pull data from Artisan to generate information for your report. Sort by section to find the field you’re looking for. In this example, we want to add a column that includes the date customers joined a loyalty program. So, we’ll click on the “Loyalty Club Summary<\/strong>” and look for “Date Joined<\/strong>.”<\/p>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_08h40_05.png\")
<\/a><\/p>\nDrag the field to the report by holding down on your mouse and moving the field onto the report designer, where you want it to be placed.<\/p>\n
- Bar Code Type<\/strong><\/li>\n<\/ul>\n
- “Grow Vertically to Fit Content<\/strong><\/li>\n<\/ul>\n
- “Comma Wrap<\/strong>“<\/li>\n<\/ul>\n
- “Word Wrap<\/strong>”\u00a0\u00a0<\/li>\n<\/ul>\n
- Format Field<\/strong><\/li>\n<\/ul>\n
- Delete Section<\/strong><\/li>\n<\/ul>\n
- Delete Group<\/strong><\/li>\n<\/ul>\n
- Delete Selected Fields<\/strong><\/li>\n<\/ul>\n
- Margins<\/strong><\/li>\n<\/ul>\n
- Orientation<\/strong><\/li>\n<\/ul>\n
- Modifying a Report<\/strong><\/a><\/li>\n
![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/Adding-a-field2.gif\")
<\/a><\/p>\n![\"\"](\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/06\/2022-06-06_09h03_46.png\")
<\/a><\/p>\n