Basic Reports - Show Build Children

A Show Build Children option is available on Basic Reports setup for the Sales Invoice, Delivery Note and Picking Ticket reports. The Indent Children checkbox available for Picking / Despatch Note reports indents child items if the Show Parent and Show Child options are used.

This option can be set from [ System Operations | Basic Reports Setup ] dialog and is off by default. When the option is active , these reports use the DBSkBuildChild data pipe to display various child item fields associated with the build:

The "Don't Print Child Items" stock option set against the parent stock item should also be unticked.

• stock_code: Child Stock Code
• short_desc: Child Stock Description
• child_qty: Child Qty (as defined in relationship)
• calc_child_qty: Calculated child total qty (parent qty * child qty)
• calc_child_qty_string: Calculated child qtys string in format "child qty x parent qty"

The above data should be displayed on a subreport placed on the existing Details subreport.

All newly created reports will automatically include this new section, so no further setup is needed (apart from layout tweaks). However existing reports will not display this data automatically, as saved templates cannot be updated automatically. In that situation manual reconfiguration is necessary.

When printing the Picking Ticket the child items will show indented below the parent item.

Assistance with reconfiguring existing reports can be provided on a chargeable basis.

Adding Stock Build Children section manually

The Stock Build Children section can be used on the:

• Sales Invoice report
• Picking Ticket report; and
• Delivery Note reports.

In the case of existing (saved templates) reports, the new section has to be added manually, otherwise build children will not be displayed when the "Show Build Children" option is active (i.e. ticked).

Report Builder Designer is an Advanced User feature.

The following action should be taken on each of the reports to display the new section:

1. Follow the menu route [ System Operations | Basic Reports Setup ] to open the "Basic Reports Setup" dialog.
2. From the dialog's [ Reports List ] tab, double-click on "Invoice Report".
3. Press the button to edit the report template using Report Builder Designer.
4. Click on the srDetails: DBDetails tab at the bottom of the screen.
5. Resize (make larger) the Detail section so it can contain the new subreport.
6. Click on the on the Advanced Components Toolbar to add a new region below the last previous element and configure it as follows (see Figure 1 below):
   1. UserName: rgSkBuildChildren.
   2. Left, Width - as required (ie 6, 160).
   3. ShiftRelativeTo: the bottom most element (i.e. eCatalogueRef).
   4. Stretch: tick.
   5. Caption: (set it blank).
7. Click on the on the Advanced Components Toolbar and then click in the Region created above to insert a new Subreport into the region and set it up as follows (see Figure 2 below):
   1. DataPipeline: DBSkBuildChild.
   2. UserName: srSkBuildChildren.
8. Click on the SubReport1: srSkBuildChildren tab at the bottom of the screen.
   
9. Remove Summary section by clicking on the [ Report ] on the menu and selecting Summary (unless desired to space from the following parent stock items).
10. Remove Title section by clicking on the [ Report ] on the menu and selecting Title (unless desired to space from the following parent stock items).
11. Place required elements to be displayed, viz:
    1. Click on the on the Data Components Toolbar.
    2. Click in the Detail area and position the first DBText field (see Figure 3 below).
    3. Set the UserName to stock_code.
    4. Set the DataField to stock_code.
    5. Click in the Detail area and position the second DBText field.
    6. Set the UserName to stock_desc.
    7. Set the DataField to stock_desc.
    8. Click in the Detail area and position the third DBText field.
    9. Set the UserName to calc_child_qty_string.
    10. Set the DataField to calc_child_qty_string.
        Note: these are the fields in the standard template.
    11. Space them in a required way (ie 0.3mm from the top, set widths and lefts).
    12. Shrink Detail section to desired height.
12. Save the report template.
13. In the Report tab tick the Show Build Children option.
14. Click on 'OK' to close the Report setup dialog.
15. Test the layout of the report and make any adjustments as required.

Figure 1

Figure 2

Figure 3

You may wish to tweak the layout of the DBText fields after testing. In the image below they are displayed vertically, but usually they are displayed horizontally.

See Also

• Basic Reports
• Report Builder Designer