Sage 200 Report Designer - Dynamic Help

1. From within Sage 200 2013 or above run the report to preview.
2. Select Edit from the top of the preview.

You have opened the required document in Sage Report Designer and can now use the Dynamic Help pane to make any changes.

TIP: If the title What would you like to do? doesn't appear at the top of the Dynamic Help pane, click a blank area on the report or layout. If the title still doesn't appear, within the Dynamic Help pane click Back until it appears.

1. From the Dynamic Help pane, click Set the report name or description.
2. In Report name, enter the name for your document.
3. In Report description, if required, enter a more detailed description of the document.
4. To confirm the changes, click OK.

You have now amended the name and description of the document.

TIP: If the title What would you like to do? doesn't appear at the top of the Dynamic Help pane, click a blank area on the report or layout. If the title still doesn't appear, within the Dynamic Help pane click Back until it appears.

To add a new text field

1. From the Dynamic Help pane, click Add text or data field, then click Add text.
2. In Enter text, enter the text you want to appear on your document.
3. If you want to format the text using one of the preset styles, from the Style drop-down menu choose the required style. Alternatively, choose the format, alignment and border options you require.
4. To continue, click Next.
5. From the Add text to section drop-down menu, choose the section of the document where you want your text to appear.
   
   

   TIP: When you choose a section, the section title is highlighted in the report area.

6. Select where you want to position the text as follows:
   
   

   Add text after the last item in the section	To add the text after the last item in the chosen section, select this option.
   Add text as a label or title for another item in the section	If your text is a label or title for another item on the document, select this option then from the drop-down menu choose the relevant item and set the required position options.
   Align the text within the section	To align the text in relation to the section, select this option then choose the vertical and horizontal alignment options as required.

7. To add the text to the document, click Add to report.

You have now added a new text field to your document. If required, you can click and drag to change its position or dimensions.

To amend an existing text field

1. On the document, click the text field you want to amend.
2. In the Dynamic Help pane, in the Edit text box change the text as required.
3. Make any style, format, alignment or border changes as required.
   
   

   TIP: If you have added extra text, you may also need to resize the text box on the report to show the new text.

You have now amended an existing text field.

TIP: If the title What would you like to do? doesn't appear at the top of the Dynamic Help pane, click a blank area on the report or layout. If the title still doesn't appear, within the Dynamic Help pane click Back until it appears.

To add a new data field

1. From the Dynamic Help pane, click Add text or data field, then click Add a data field.
2. In the Select the data to add section, from the first drop-down menu choose the table that contains the variable, or data field, you want to add, for example, SLCustomerAccounts. From the second drop-down menu choose the variable, or data field, you want to add, for example, CreditLimit.
3. If required, to suppress the printing of the variable, select the Do not print (suppress printing) check box.
4. If required, to use Active Complete to add headings and totals for the variable, select the Use Active Complete check box.
   
   

   NOTE: For further information about Active Complete, please click here.

5. From the Add data field to section drop-down menu, choose the section of the document where you want your variable to appear.
   
   

   TIP: When you choose a section, the section title is highlighted in the report area.

6. Select where you want to position the text as follows:
   
   

   Add data field after the last item in the section	To add the data field after the last item in the chosen section, select this option.
   Position data field relative to another item in the section	If the variable position should be relative to another variable on the document, select this option, then from the drop-down menu choose the relevant item and set the required position options.
   Align the data field within the section	To align the text in relation to the section, select this option then choose the vertical and horizontal alignment options as required.

7. To add the variable to the document, click Add to report.

You have now added a new data field to your document. If required, you can click and drag to change its position or dimensions.

To amend an existing data field

1. On the document, click the variable you want to amend.
2. In the Dynamic Help pane, in the Change the data field section, from the drop-down menus choose the required table and variable.
3. If required, amend the Do not print (suppress printing) setting.

You have now amended an existing data field.

TIP: If the title What would you like to do? doesn't appear at the top of the Dynamic Help pane, click a blank area on the report or layout. If the title still doesn't appear, within the Dynamic Help pane click Back until it appears.

NOTE: In order to add an image to your document, you must first check where the image file is stored on your PC or network.

To add a new image

1. From the Dynamic Help pane, click Add an image or logo.
2. In the Select the image from your PC or network section, click Browse.
3. In the Open window, browse to and select the image file you want to add, then click Open.
   
   

   TIP: You can add images with the file types .bmp, .gif, .jpg, .jpeg, .png, .ico, .emf and .wmf.

4. In the Appearance and printing options, select any options as required.
5. In the Choose the image position section, from the Add image to section drop-down menu choose the section of the document where you want the image to appear.
   
   

   TIP: When you choose a section, the section title is highlighted in the report area.

6. Choose the vertical and horizontal alignment options as required, then click Add to report.

You have now added a new image to your document. If required, you can click and drag to change its position or dimensions.

To amend an existing image

1. On the document, click the image you want to amend.
2. In the Dynamic Help pane, to select a different image file click Browse, browse to and select the image file you want to add, then click Open.
3. Amend the Appearance and printing options as required.

You have now amended an existing image.

TIP: If the title What would you like to do? doesn't appear at the top of the Dynamic Help pane, click a blank area on the report or layout. If the title still doesn't appear, within the Dynamic Help pane click Back until it appears.

To add a new line or box

1. From the Dynamic Help pane, click Add a line or box, then click Draw a line or Draw a box as required.
2. Click Draw line or Draw box as required, then to draw the line or box, on the report area click and drag the mouse pointer.
3. In the Dynamic Help pane, amend the Appearance, Printing and Alignment settings as required.

To amend an existing line or box

1. On the document, click the line or box you want to amend.
2. In the Dynamic Help pane, amend the Appearance and Printing options as required.

TIP: If the title What would you like to do? doesn't appear at the top of the Dynamic Help pane, click a blank area on the report or layout. If the title still doesn't appear, within the Dynamic Help pane click Back until it appears.

NOTE: A report filter applies automatically every time you run the document. Report criteria can be set at the point you run the document.

To add or amend a report filter

1. From the Dynamic Help pane, click Restrict the information included in the report, then click Set report filters.
2. From the Report filter section click Edit report filter, then create or amend the filter as required.
   
   For further information about creating filters, please click here.
   
   
3. To confirm the changes, click OK.

To add or amend report criteria

1. From the Dynamic Help pane, click Restrict the information included in the report, then click Set report criteria.
2. From the Report criteria section click Edit report criteria, then add or amend criteria as required.
   
   For further information about amending criteria, please click here.
   
   
3. To confirm the changes, click OK.

TIP: If the title What would you like to do? doesn't appear at the top of the Dynamic Help pane, click a blank area on the report or layout. If the title still doesn't appear, within the Dynamic Help pane click Back until it appears.

1. From the Dynamic Help pane, click Sort information in the report, then in the Sorts section click Edit report sorts.
2. In the Sorts window, add or amend the sorts as required.
   
   

   NOTE: For further information about adding sorts, please refer to article .

3. To confirm the changes, click OK.

TIP: If the title What would you like to do? doesn't appear at the top of the Dynamic Help pane, click a blank area on the report or layout. If the title still doesn't appear, within the Dynamic Help pane click Back until it appears.

• From the Dynamic Help pane, click Set up email, then select one of the following options:
  
  

  Set up Report Designer to use my email account	To enter your default email account details for all documents, click this option then follow the on-screen steps.
  Set up how this report is sent by email	To enter other email settings specific to this document, click Set up how this report is sent by email then follow the on-screen steps.

NOTE: For further information about entering email settings, please refer to article .

1. To save the changes, open the File menu and choose Save As. From the Save As window, in the File name box, enter a file name for your amended document. If required, browse to the required location for your document then click Save.
   
   

   NOTE: For further information about how to deploy your report, please click here.

2. To close Sage Report Designer, open the File menu and choose Exit.

You have now saved your amended document.

TIP: If you have any difficulty finding a recently saved document, you can open it from the Report Designer Recent files list and save it to the required location. To open a recently viewed report, from the Sage 200 2013 menu bar, choose Report Designer then from the Recent files list, click your required report.