Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running Total Needed In Group Header
- Thread starter CurtR
- Start date
You can place it wherever you like, but by definition a running total is not the same at the beginning of the group as it is at the end. Sometimes a running total can be replicated as a regular total, so explain why you have use a running total and I will tell you if there is an alternative. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
- Thread starter
- #3
Sorry Ken,
I was not very clear.
When I attempt to use the Summary Feature for the Fields that I need. It is not working due to the Relationship of the tables.
I have the following Groups on the Report of Vehicle Repair.
Department then Vehicle, then WorkOrders. Each Department Has Several Vehicles, Each Vehicle in Return Has Several Work Orders, Which each Can have several Parts etc...
Any way the Sumary Function Works Fine at The Vehicle Level for summarizing the WorkORders. But when I get to the Deparment Group, the sum is applied several times( depending on number of workorders for the vehicle). The Running total works fine, but it Can not be placed in the Header, as it only gives the sum of the first reading and I need the sum of for all( footer reading).
I have been Trying to Use Variables, and Whilereading/printing records to control this. But to be Honest I am lost. My report works Great Other than I need to supply a Cover Page Summary which unless there is another way of doing it means getting the totals from the Department Group footer to the Group Header.
Ken, as always thanks
Curt
I was not very clear.
When I attempt to use the Summary Feature for the Fields that I need. It is not working due to the Relationship of the tables.
I have the following Groups on the Report of Vehicle Repair.
Department then Vehicle, then WorkOrders. Each Department Has Several Vehicles, Each Vehicle in Return Has Several Work Orders, Which each Can have several Parts etc...
Any way the Sumary Function Works Fine at The Vehicle Level for summarizing the WorkORders. But when I get to the Deparment Group, the sum is applied several times( depending on number of workorders for the vehicle). The Running total works fine, but it Can not be placed in the Header, as it only gives the sum of the first reading and I need the sum of for all( footer reading).
I have been Trying to Use Variables, and Whilereading/printing records to control this. But to be Honest I am lost. My report works Great Other than I need to supply a Cover Page Summary which unless there is another way of doing it means getting the totals from the Department Group footer to the Group Header.
Ken, as always thanks
Curt
If you can't print the cover page at the end (and then place it on top), you will need to create a subreport to do the cover page. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Question