Running Count and Multiple Groups

  • Thread starter Thread starter spencer
  • Start date Start date
S

spencer

I have a need to add a line number to each item in a report. The
client wants the line number for groupings of Current Month, Current
Year and Grand Total. I set a text box to =1 and set running sum to
Over Group and I get the line number Current Month. I set a text box
to =1 and running sum to All and I get the line number for Gand Total.
I am unable to figure out how to create the line number for the Year
grouping. These line numbers need to all be in the detail section with
the detail records. If I could specify Over Group and then specify the
particular group that would be ideal but doesn't appear that ability
exists.
Spencer
 
Add a grouping level based on Current Year (txtYearNumber)
Add a control txtYearCount to the section and set it to =1 and Running Sum to Overall
Set the visible property of the group section to NO.

Add a control to the detail level (txtShowYearNumber)
Set its source to =[txtYearNumber]
Set Running sum to NO
 
Ok I tried this and all I get is the value 1 to show up even when
setting the control to be visible in the group header.

Add a grouping level based on Current Year (txtYearNumber)
Add a control txtYearCount to the section and set it to =1 and Running Sum to Overall
Set the visible property of the group section to NO.

Add a control to the detail level (txtShowYearNumber)
Set its source to =[txtYearNumber]
Set Running sum to NO

I have a need to add a line number to each item in a report. The
client wants the line number for groupings of Current Month, Current
Year and Grand Total. I set a text box to =1 and set running sum to
Over Group and I get the line number Current Month. I set a text box
to =1 and running sum to All and I get the line number for Gand Total.
I am unable to figure out how to create the line number for the Year
grouping. These line numbers need to all be in the detail section with
the detail records. If I could specify Over Group and then specify the
particular group that would be ideal but doesn't appear that ability
exists.
Spencer
Click to expand...
Click to expand...
 
Hmm, it works for me, so I must have missed an instruction.

And re-reading my instructions I think I may have confused control names. Let
me rewrite that section

Control in Grouping Level
Name: txtYearCount
Source: =1
Running Sum: Overall

Control in Detail Area
Name: txtShowYearCount
Source: =[txtYearCount]
Running Sum: No

For testing purposes, I suggest you leave the grouping level visible and the
txtYearCount control visible. Once you get things running, you can hide the
group and control as appropriate.



Ok I tried this and all I get is the value 1 to show up even when
setting the control to be visible in the group header.
Add a grouping level based on Current Year (txtYearNumber)
Add a control txtYearCount to the section and set it to =1 and Running Sum to Overall
Set the visible property of the group section to NO.

Add a control to the detail level (txtShowYearNumber)
Set its source to =[txtYearNumber]
Set Running sum to NO

I have a need to add a line number to each item in a report. The
client wants the line number for groupings of Current Month, Current
Year and Grand Total. I set a text box to =1 and set running sum to
Over Group and I get the line number Current Month. I set a text box
to =1 and running sum to All and I get the line number for Gand Total.
I am unable to figure out how to create the line number for the Year
grouping. These line numbers need to all be in the detail section with
the detail records. If I could specify Over Group and then specify the
particular group that would be ideal but doesn't appear that ability
exists.
Spencer
Click to expand...
Click to expand...
Click to expand...
 
Back
Top