Grouping w/ two fields

[keybs]

A2000 - I have a report that I thought was working perfectly until yesterday. The problem is that I am grouping data by two fields in a table.. and more specifically it is a wire size. This report prints all of the wire sizes used on a certain job. There is usually multiple occurances of a single wire size and each different wire container has a primary key called the DBSN. The report looks like this:

128 X 229 Quad (This is the wire size and type)
(DBSN#1) (Amount used) (Wire Location)
(DBSN#2) (Amount used) (Wire Location)
(DBSN#3) (Amount used) (Wire Location)
...

064 X 128 Film
(DBSN#1) (Amount used) (Wire Location)
(DBSN#2) (Amount used) (Wire Location)
...

Each group has a total for the Amount used. My problem is that the report will only group by the first number (Thickness) where the format is (Thickness) X (Width) If all wire sizes have different thicknesses then the report works fine, but if the report has several wire containers with the same Thicknesses and different widths, then is puts them all under the same group heading. Is it possible to group by two different fields?


[This message has been edited by keybs (edited 09-14-2001).]

 

[Pat Hartman]

Create a separate grouping level for each field but don't put any fields in the header or footer for the Thickness group. Put all the header fields in the Width group header and put the totals in the Width group footer.