I have a report that has a two "Groups" set up. I then need to be able to "Sort" by a field within one of those groups.

 

eg, our data is grouped by product, then job number, i then need to sort it by due date.

 

Is this possible?

 

 

The usual sorts do not work as the group takes presedance

 

thanks in advance

stephen

 gh1 - product

  gh2 - job

   gh3 - due date

 

there is probably a cleaner way (as someone complained that this was a hack) but it took him at least a day to figure it out.  I guess I'm just lazy and this works...

 

HTH

 

1. the report groups by product. this part works fine.

2. the report groups by job number. this is because each job can have more then one item per job number. so i have hidden the details section and i have all of the fields in the job number group line. this allows me to have totals per job number rather then per item.

3 we then want to sort by due date.

 

the two groups work, however the due dates are then jumping all over the place. i need them to be from oldest to newest.

 

i hope this is a bit clearer.

 

thanks