Hi everyone!
And please help.
This is my report. The red circle below is the calculated field ([TotalDaysStayed]) with running sum. It shows up the correct number as sums the last column ([DaysStayed]).
The field [DaysStayed] is calculated as: [DateLast]-[DateFirst]+1 (interval including both start and end dates)
But, ... when I try to show up the total (textbox named - [GTotalOfDays]) of the last column at the group header (the blue circles), it shows up the sum of the first two group headers.
I tried :
- [GTotalOfDays] control source = [TotalDaysStayed] -> Result: [GTotalOfDays]= first value of the [TotalDaysStayed] which is 7 (not correct, must show 15)
- [GTotalOfDays] Running Sum property set to Over Group, control source = [TotalDaysStayed] -> Result: as on image
How can I sum up the [DaysStayed] field in Group Header for a group?
Thanks thanks and again thanks if you try to help me.
And please help.
This is my report. The red circle below is the calculated field ([TotalDaysStayed]) with running sum. It shows up the correct number as sums the last column ([DaysStayed]).
The field [DaysStayed] is calculated as: [DateLast]-[DateFirst]+1 (interval including both start and end dates)
But, ... when I try to show up the total (textbox named - [GTotalOfDays]) of the last column at the group header (the blue circles), it shows up the sum of the first two group headers.
I tried :
- [GTotalOfDays] control source = [TotalDaysStayed] -> Result: [GTotalOfDays]= first value of the [TotalDaysStayed] which is 7 (not correct, must show 15)
- [GTotalOfDays] Running Sum property set to Over Group, control source = [TotalDaysStayed] -> Result: as on image
How can I sum up the [DaysStayed] field in Group Header for a group?
Thanks thanks and again thanks if you try to help me.