Reports Question

[Baylah]

[color:red]<>

Hi Everyone:

I have a database with related tables. Table 1 contains the "Master Record" and table 2 contains the "Sales Records".

The Master Record table has a Primary Layout with a Portal that displays records in the related Sales Records table. The relationship is pkOrdNum = fkOrdNum.

This way I can have an infinite number of sales lines for any given order.

The problem is I can can not seem to build a report that shows order history the way I would like.

The Sales record database might have hundreds (or thousands) of records to account for all of the Order Lines. What I would like is a report that changes raw data that looks like this:

1 $10.00 Smith

1 $15.00 Smith

1 $12.00 Smith

1 $13.00 Smith

2 $20.00 Smith

2 $25.00 Smith

2 $13.00 Smith

3 $17.00 Jones

3 $17.00 Jones

4 $12.00 Jones

4 $11.00 Jones

4 $19.00 Jones

into a report that looks like this:

Customer Total Sales

Smith $108.00

Order # 1 $50.00

Order # 2 $58.00

Jones $76.00

Order # 3 $34.00

Order # 4 $42.00

Company Total Sales:$184.00

I know this needs to be done with sub-summary partitions and the like but I cannot seem to get this right.

Any help would be greatly appreciated.

Thank you,

Steve

Edited December 27, 2007 by Guest