Grouped Data

[Kaiden]

I am almost done with this project. It has been a year and you guys have helped me out a lot. I have one more question.

I have a created a group data report that lists the workflow (design, production and design/production), relevant information for each record in that workflow, then the subtotal for the workflow. I need to also show a monthly break down. I have a date field (01/01/2007) that contains this data for each job number when it was created. I need for the report to first group the month, then the workflow along with the job number and the total for each work flow.

Example:

December

Design

Job Number 12222

Job number 12223

Total 2

Production

Job number 13333

Total 1

January

Production

Job Number 1444

Job Number 1555

Job Number 1666

Total 3

I keep running into a problem with the date field. I created a subsummary (leading) section above the Workflow subsummary field, but when ever I perform the sort action the month appears next to each of the Job Number section.

Example:

Design

Job Number 12222 12/01/2006

Job number 12223 12/09/2006

Total 2

Production

Job number 13333 12/20/2006

Total 1

January

Production

Job Number 1444 01/03/2007

Job Number 1555 01/04/2007

Job Number 1666 01/05/2007

Total 3

I need for the the date field to first convert the date 01/01/2007 to the month name and then provide the breakdown for each workflow, job number and finally the total for each.

Any suggestions? Your help would be greatly appreciated.

[mr_vodka]

These threads should get your going in the right direction.

Thread 1

Thread 2

[Kaiden]

Thank you very much. I knew I was close. I had the formula right but I needed to change the caculation result from date to text. That did the trick.

Thanks again Mr. Vodka!