Grouping

[computergeek]

Hi,

I am trying to create a grouped report grouped by date/material.

Detail records:
Date Material Component NH3 Water
1/9/2007 Test1 Comp1 30 null
1/9/2007 Test1 Comp2 null 70

Desired Output:
Date Material NH3 Water
1/9/2007 Test1 30 70

Thanks

 

[lbass]

If the setup is always like that, with nulls or one relevant value per date/material, you could insert a group on date, then insert a second group on material, and drag the group #1 name into the group #2 header. Then place the other two fields in the detail section and right click on each and insert a maximum. Drag the results into the group #2 header and suppress the GF#2, the two Group #1 sections, and the details section.

-LB