format report

[tekila]

I have a report that displays Model (of the product),Total and Pass as one record. I want to show a summary (Subtotal) of the Model Family (first three letters of the model),Total and Pass at the report footer but somehow I couldn't achieve what I desired. It should look something like this:

Model Total Pass
AAA123 100 98
AAA225 120 113
BBB667 100 90
BBB145 120 114
... ... ...


AAA 220 211
BBB 220 204

 

[JohnLowell]

Create a Sorting and Grouping row like this:
=Left([Model],3) and set the Group Header and Groupt Footer to Yes. Create 2 text boxes, 1 that is =Sum([Total]) and the other to be =Sum([PAss]).
You can put a text box in the Header or Footer to show the Model like this =Left([Model],3).

Let me know if this helps.

 

[tekila]

Well, actually the Model Family, Total and Pass are fields in the query that the report is bound to. I've tried to place Model, Total and Pass in the Detail section and Model Family, Total(Subtotal) and Pass(Subtotal) in the group footer of Model Family but this was what I got:

Model Total Pass
AAA123 100 98
AAA 220 211
AAA225 120 113
AAA 220 211
BBB667 100 90
BBB 220 204
BBB145 120 114
BBB 220 204]

What should I specify in the Sorting and Grouping property sheet?

 

[JohnLowell]

=Left([Model],3) and set the Group Header and Groupt Footer to Yes.

 

[tekila]

Tried your method but I want to group all the records of the Model Family together.

 

[JohnLowell]

The only way I can see to do this like your example is to use a sub report for the totaling of the Model Family

 

[tekila]

But I want all the records of Model Family to be grouped together. How?