Editing Report Builder Tutorial
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
SME uses a tool called Report Builder to customize the report/document forms. | SME uses a tool called Report Builder to customize the report/document forms. | ||
− | |||
<br>The tutorial, available from the following link will familiarize you with the necessary steps required to create, modify, or customize existing reports however it cannot be attached to your SMP data. | <br>The tutorial, available from the following link will familiarize you with the necessary steps required to create, modify, or customize existing reports however it cannot be attached to your SMP data. | ||
− | <br><span> </span>"http://www.digital-metaphors.com/download/ | + | <br><span> </span>"http://www.digital-metaphors.com/download/learning_reportbuilder.html"<span><span> |
− | |||
− | |||
− | |||
+ | '''Customizing Reports with Report Builder''' | ||
− | |||
This tutorial assumes that you are modifying an existing report, where the settings under Customize Report are correctly set. If you wish to modify those details, read Customizing Reports. | This tutorial assumes that you are modifying an existing report, where the settings under Customize Report are correctly set. If you wish to modify those details, read Customizing Reports. | ||
+ | |||
+ | |||
To access the Report Builder, go to Customize Reports under the Reports tab in SME and click the Open Report Designer button. | To access the Report Builder, go to Customize Reports under the Reports tab in SME and click the Open Report Designer button. | ||
− | + | ||
− | + | ||
− | + | '''Adding New Text Fields''' | |
− | + | ||
− | + | In this tutorial, the Standard Purchase Order report will have phone, fax, and due date fields added to it. | |
− | + | ||
− | + | Step 1: making room for the new fields. Phone and fax information are only listed once per page, so they belong in the Header or Group Header. Drag the Group Header down to free up space. To move the headings for the details down, drag a box around them and drag them down to be right above the Group Header ribbon. | |
+ | |||
+ | |||
+ | Step 2: adding new non-repeating fields. Phone and fax information can be found under the Customer table, in the Data Tree on the right side of the screen. Select the Customer table, then the Phone and Fax fields, and drag them onto an empty spot on the report. | ||
+ | |||
+ | |||
+ | Step 3: adding repeating fields. Because Due Dates show up on every item, that field belongs in the Detail tab. In this report, the details are in a SubReport. Click on the tabs on the bottom of the screen to move between the main report and subreports. The DueDate field is in the PurchaseOrders table, so select it then drag DueDate to where you want it. | ||
+ | |||
+ | Once you're finished arranging the text fields, save the report and make sure the Filename is specified as the new report file in the Details and Settings section of Customize Report. | ||
+ | |||
+ | |||
+ | '''Formatting: Page Breaks''' | ||
+ | |||
+ | This tutorial is useful for if you only want to print one item or one customer per page, and the report is not set to page break on a change in that field. Placing a field in either the header or group header space will result in only one value being displayed. Placing the field in the details space will display all values in the table. | ||
To print one main field (customer, item, location, etc) per page: | To print one main field (customer, item, location, etc) per page: |