Running Count and Multiple Groups

[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

 

[John Spencer (MVP)]

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

 

[spencer]

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

 

[John Spencer (MVP)]

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