Client: 213W Wine Imports

Project: Custom FileMaker Pro Database System

Subject: Build x11

Date: 8/08/2011

There is 1 agenda items addressed in this Build x10 Summary Document . . .

1. The "% & L" Layout [Orders Line Items] Does Not Display Correct Data

1.1 Issue.

Frank . . .

> i have another issue and it refers to % & L in the

> <orders line items; when i run this routine in the

> modules that i gave you in the beginning...i get the

> following readout; what it does is categorize by percent

> alcohol the line items for each order and list them.

1.2 Resolution.

The Layout titled [% & L] assigned to the [OrdersLN] Table (ie Sales Orders Line Items) requires (1) sorting the found set of records by the field titles [ItemAlcohol%] and (2) viewing the result in Preview Mode.

The follow modifications have been made:

1) changed the position of the objects on the layout (ie fields and field titles) and added horizontal lines so:

a) the report displays the Alc % by groups as the 2 sub-summary parts on the layout are intended, AND

b) so the report can be printed on letter size paper or saved as a PDF document.

2) added the field [Inventory::ml] which was shown in an earlier modified template file.

3) changed the calculation formula for the field [TotalLitres] which uses the Inventory::ml related field in the formula.

1.3 Screenshots.

1) Layout (Previous Position of Objects)

2) Layout Sub-Summary Sort Field

3) Layout (Revised Position of Objects)

4) Report Sorted by Alcohol % Field (Preview Mode)

5) Revised Calculation Forumula for Field [TotalLitre] = Calc (Number)