This must be formatted as HTML in Crystal Reports and set to auto-expand

Line Item Subtotal

TransDetail.SubTotalPrice

Suppressed based on options

Line Item Number

TransDetail.LineItemNumber

Order Created Date

TransHeader.OrderDate

Company Name

Account.CompanyName

Salesperson

Employee.FirstName + “ ” + Employee.LastName

Group By Main Report:
The following groups are static in the
|| Description || Level || Optional || Group ID field || Group Display Field || Notes ||

Division

1

No

TransHeader.DivisionID

Division.DivisionName

Order

2

No

OrderLevel.ID

OrderLevel.OrderNumber

LineItem

3

No

LineItemLevel.ID as formatted by @LineItemSort

PartsList Subreport:
grouped by Station.StationName ShipmentView subreport
grouped first by Shipments.ShipmentNumber and second by TransDetail.LineItemNumber
Sort Options
The data within a group will always been sorted by the non-optional fields below and (if present) the user is given options to sort by the other fields.
|| Description || Sort Text || Level || Optional || Notes ||

Order

TransHeader.OrderNumber

1

No

Line Item

TransDetail.LineItemNumber

2

No

Line Item Station

TransDetail.LineItemNumber

3

No

This Sort would only seem to apply to the subreport; therefore delete.

Part Type

Part.PartType

4

No

Not previously done in the subreport! delete?????

Part Name

Part.ItemName

5

No

Not previously done in the subreport! delete?????

There are no user defined sort of options in this report.
User Filter Options
The following options need to be implemented to filter the data and/or provide information to reconfigure the report display.
|| Description || Parameter Name || Default || Data Filter || Notes ||

Show Line Item Totals

True

n/a

Hide or Display the SubTotalPrice on the individual line item.

Show Service Ticket Stub

True

Print Images

True

If present, show thumbnails for each Line Item

Show Parts Information

True

If true, shows the parts subreport

Show Shipping Information

True

If true, shows the shipment subreport

Summary Fields

There are no summary fields for this report.

Export

The TransDetail data should export into clean comma-delimited/Excel data.