Get current group value of a report

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

Guest

Hi there!

I wrote some code to change a few properties of a report during it's opened.
The recordsource is also generated dynamically via VBA.
The report is grouped with the ID of a specific field. That works so far. My
problem is, that I also need to run some functions for the details area of a
group. For doing that, I need the value after which the detail records are
grouped (--> the ID of the field). I already looked at the object / -
properties which are created during starting the report, but I simply
couldn't find a property or something like that which says me what the needed
value at the moment is. Any ideas how I can read this value from the
report-object, or groupheader, or..,..? thanks in advance for your support!
 
Marcus said:
I wrote some code to change a few properties of a report during it's opened.
The recordsource is also generated dynamically via VBA.
The report is grouped with the ID of a specific field. That works so far. My
problem is, that I also need to run some functions for the details area of a
group. For doing that, I need the value after which the detail records are
grouped (--> the ID of the field). I already looked at the object / -
properties which are created during starting the report, but I simply
couldn't find a property or something like that which says me what the needed
value at the moment is. Any ideas how I can read this value from the
report-object, or groupheader, or..,..? thanks in advance for your support!
Click to expand...


Sorry, but I don't follow your question. What does " I need
the value after which the detail records are grouped" mean?

If you just want the grouping value, add a text box bound to
the grouping field. You can then use the text box's value
in your calculation.

That sounds too simple to be what you need so try explaining
what you need in another way. Perhaps a simplified example
of the report's desired output might help me get a grip on
your question?
 
I thought I described it a bit complicated, sorry for that! what you wrote
was not exactly what I meant.

But I just dropped the report because after all this report got too
unmanageable for later adjustments and might be a bit too confusing for
others.. I redesigned the whole structure and am working now with your idea
of using a textbox. So your answer wasn't in vain! ..thanks for your help
anyway!
 
Back
Top