Search results for query: *

I got it to work. I used the resettotal function in the group1 header, the running total function in the group2 footer, and the print subtotal function in the group1 footer. This worked for the total report also...It's been a long week but thanks to everyones help I got it done :) Zemlya

Malcolm, It does not like the Global or Local statement in from of the Variable declaration. Zemlya

And here I tought I knew Crystal. I am not in work today but this killed me Friday. I still think that this adds up every value for all detail lines which is not the answer I need. I need it to forget about the detail lines and sum the group average I get for these lines. IE sum the calculated...

Sami In the design section of the report highlight the item you want to count. Go to 'Insert' on the menu and select 'Summary' Change it from sum to count and tell it what group you want the total count put in. Zemlya

Alright, I've been trying to figure this out. I found what was wrong with the formula Malcolm wrote, so now I have it working. To be honest however I am still not sure what this is doing to help me out !? But I am getting a result of some kind... Zemlya

ok, I know that I am needing alot of hand holding here but... I made a new formula and typed in exactly what is above from Malcolm. Crystal will not accept the first line, it says that the remaining text does not appear to be part of the formula. Zemlya

There is now more info there. Thanks Zemlya

I have looked at the frequently asked questions on this forum but haven't seen anything that can help me. Let me give more of an example of what I am trying to do. I have 5 delivery routes as follows. 1101 1102 1103 5836 5837 These routes are made of two combined fields. Depot (first two...

I have a report written where there are details, group 2 and group 1. I have used a formula which gets me an average result for the details but eliminates zeros. This result is in Group 2 and is derived from details. I accomplished this using three different formulas. I now need to sum these...