Seven price
asked on
crystal group subtotal
I have a report with dates what I am trying to do is get it display correctly but when I use the date group it does not add correctly.
date amount result
10/11 50 50
10/12 20 70
10/15 10
10/15 9
10/15 5
10/15 40 134
10/19 10 144
date amount result
10/11 50 50
10/12 20 70
10/15 10
10/15 9
10/15 5
10/15 40 134
10/19 10 144
ASKER
above is what the result should be.
this is one user and by there userid displays the amount according to the day and month
I am grouping by day but when I add the amount it only sums the last month shown for example
date amount result
10/11 50 50
10/12 20 70
40 180
10/19 10 190
so the result for example suppose to be 220 it comes out 190
If I can get the same result to add each amount line but do not show the group like the example
Do not want below**
date amount result
10/11 50 50
10/12 20 70
10/15 10 90
10/15 9 99
10/15 5 104
10/15 40 134
10/19 10 144
Do want below
date amount result
10/11 50 50
10/12
10/15 40 134
10/19 10 144
this is one user and by there userid displays the amount according to the day and month
I am grouping by day but when I add the amount it only sums the last month shown for example
date amount result
10/11 50 50
10/12 20 70
40 180
10/19 10 190
so the result for example suppose to be 220 it comes out 190
If I can get the same result to add each amount line but do not show the group like the example
Do not want below**
date amount result
10/11 50 50
10/12 20 70
10/15 10 90
10/15 9 99
10/15 5 104
10/15 40 134
10/19 10 144
Do want below
date amount result
10/11 50 50
10/12
10/15 40 134
10/19 10 144
The examples and example text does not make any sence at all.
ASKER
Here let me explain it since it doesn't make since.
The amount will total in the results but they will be grouped together using the date. So if its the same date it will only show once. why giving the correct total result on each line.
The amount will total in the results but they will be grouped together using the date. So if its the same date it will only show once. why giving the correct total result on each line.
If you put the totals in the group footer, they will appear only once per group.
If you want the details to show for the group then put the field in the detail section.
mlmcc
If you want the details to show for the group then put the field in the detail section.
mlmcc
ASKER
I did add it in the group and vice versa, but this does not give me a sub total of the amount in Details and it does not separate it when i group it together in the group section. If i add it in the group section then it only gives me the last line subtotal of that group. If I add it to details then it shows everything and does not separate it like it does in group.
Let me know if you follow.
Let me know if you follow.
How are you totaling?
mlmcc
mlmcc
ASKER
let me ask you this can i call a group name and define it in the details row, if so example how.
ASKER
>>How are you totaling?
NumberVar y;
WhilePrintingRecords;
y:=y+{Review.ChargeAmount}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Not OnLastRecord or Next({GroupField}) = {GroupField}
ok sorry not to familar with crystal syntax groupfield would be
ok sorry not to familar with crystal syntax groupfield would be
ASKER
Ok i got it thanks
GroupField is the field you re grouping on. In this case the date field
mlmcc
mlmcc
ASKER
I uses a run total and add it to group.
ASKER
I was trying to give points and there was a glitch
ASKER
t
ASKER
trying to add points
Overruling original poster's inappropriate closing attempt by issuing a better disposition.
Modalot
Community Support Moderator
Modalot
Community Support Moderator
How are the sums being done?
What is the group?
Are you grouping by day?
mlmcc