running sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a nested running sum. Basically it is the third grouping in the report

grouping #1 Date of visit (group by month)
grouping #2 referring provider header (group by value)
grouping #3 chart # header (group by value)

I want to count the number of patient visits ( chart #) by the month and
have a total at the end of the report.

In the chart # header I have an unbound text box control source =1
running sum set to over all

I have a reference to this in an unbound text box at the report footer which
totals the patients. That works fine

However in the Date footer (grouped by month) I am trying to get the total
patients just for that month. Again I have a text box in the chart #1 header
named (monthvisits) which I refer to in the date footer.

If I set monthvisits to overall it doesn't reset for each month. If I set
month visits to over group it resets at the referring provider group footer
so I only get the value present for the last referring provider group.

I have tried setting monthvisits = 0 in the code window for the Date header.
But I get cannot set value error.

Any help would be greatly appreciated
 
Stefan,

Add a second unbound textbox =1 with a running sum over group. set visible
to false (assuming you don't want it displayed)

HTH

Terry
 
When I do that it resets itself when it goes through the referring provider
group
I get the number of patients for the last referring provider only.
 
Stefan,

I finally read your initial question properly and tried a similar setup
here. I can't see how to sum over a specific group. You might try this:

Text1 (in detail section) =1 running sum over group

Text2 (in first group footer) = [text1] running sum over group

Text3 (in second group footer) = [text2] running sum over group

and so on up the group hierachy.

The text1, 2, 3 reset after each additional grouping.


A bit messy ... but will do what you want ...... I think.

HTH

Terry
 
Back
Top