running total for group

[cliff7376]

i have a running total for a group in my detail section of my report. I would like to be able to hide those records that the running total is equal to a field in the detail section. for instance if the total of my issue qty equals my required qty i dont want it to show on my report can that be done?

 

[JCollins]

I did something similar...

In the table for the records, I added a new field called "blnVisible" and set it to True/False as appropriate.

In the report, I added the field blnVisible (made it invisible) and then put the code behind in the appropriate GroupFooter Format event:

me.groupfooter1.visible = me.blnVisible

If blnVisible is true, then the group footer shows up, otherwise, it becomes invisible...

If you are looking for specific values, I think you could use a Select Case:

Select Case Your_rpt_Field_Value
case 1
me.groupfooter1.visible=true
case 2
me.groupfooter1.visible=false
case else
end select