Jump to content

Grouped Data


Kaiden
 Share

This topic is 5756 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Picture_1.png

Link to comment
Share on other sites

This topic is 5756 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.