Records not populating in report

Skolnick

Developing a report based on Sales Header and Sales Lines.

1. Used Wizard to set up using Sales Header. Choose fields and formatting.
2. Added Sales Line as a DataItem indented and then linked to Sales Header.
3. In "View Sections" added Sales Line Header. Added three fields (Amount, Description and No.).
4. Moved all three items to Sales Header and Body and changed SourceExpres (Example: "Sales Line"."No.").
5. In Sales Line Properties, added all three items to CalcFields.

Ran the report, for the Sales Line fields, no results for No. and Description and Amount returns only 0. What am I missing?

Thx!

BernardJ

Add a GroupFooter section for Sales Lines, and put the 3 fields there.

Assuming that you would like to have totals per No., add the field No. to the GroupTotalFields, and the field Amount to TotalFields.
Also select a key for the Sales Lines that begins with Orderno. and No.
There is no need to put any field in CalcFields, since there are actually no Flowfields you want to calc.

Regards

Skolnick

Thank you for the info. No, I am not totalling the columns. I want to list values for the records.

Ord Date Quote No. REP Customer Name Amount ITEM No. Description
10/08/07 SQ-0000011 BH ABCDE COMPANY 0.00
11/07/07 SQ-0000012 JR DEFGH COMPANY 0.00
07/14/08 SQ-0000021 BH GHIJK COMPANY 0.00
07/15/08 SQ-0000022 MG ABCDE COMPANY 0.00

This is a sample of the report. Red items are from Sales Lines but placed in Sales Header Body. Values do not populate. This is the information that is needed to be brought in to the report.

Thx.

dans

If you are not totaling the fields, you need to put the fields into the sales line body.
When the sales header body is printed, the data from the sales line has not been taken yet. Hence, you got zero results.