Group total at far right (last column)

[ikards]

CR8. I am trying to create a daily time analysis for a one month period. I am using Header 1 to show Group Name (name of the Employee) and then a SUM of each Detail line for each of the 31 days of the month. I hide the Detail line and show the Header 1. Everything works great except I want to add a TOTAL for each Employee at the far right of the report. How do I get a total for the 31 different SUMs for each employee? IE, how do I total ACROSS instead of down?? Help!

Steve Ikard

 

[synapsevampire]

Sounds like you want a cross tab...

Insert one and:

Row: Employee
Column: Date (check group options, the default should be each day)
Summarized Field: ???

??? You state that you sum the detail lines, which isn't possible, perhaps your inserting a summary which is counting the dates?

Anyway, this sounds like what you want.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Naith]

If your report is incompatible with a cross tab format, you could capture the value of each of the employee fields in a variable, and call the variable at the end of each row.

Remember to reset the variable to 0 with each new employee, otherwise your totals will just keep growing exponentially!

Naith

 

[HowardHammerman]

Let's keep it simple.

Create a sum for each day. Then add the sums in a formula field. A bunch of typing, but what the heck.

EG:

Sum({table.hours01},{table.ID})+Sum({table.hours02},{table.ID})+Sum({table.hours03},{table.ID})+.....

You can place that formula in the header. No need for cross tabs, etc. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[synapsevampire]

Hmmm, perhaps this is a *different* sort of data source than I'd imagined.

Howard is right if you have 31 fields, just + 'em.

Are you going to conditionally suppress days for < 31 days in other months?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ikards]

Thanks for all your suggestions. I think I must have gone brain dead. I simply had to create a field in that last column at the Group Header 1 level which was the SUM of the time. Since it was at the Group level, it was the total of all the time for that Group (Employee). Sorry for bothering you.

Steve