Possible to Update Report in Real Time While Working in Database?

[ItsRoland]

I'm not sure if this is possible or not, but basically I would like my report to update live while a user is filling out information if possible



Some context:

The database I'm working on is one we'll be taking to multiple different clients. During these meetings the database forms will be on a larger display while we work through them with the client. The goal is for the client to be able to see the progress being made on another screen in the form of this report, so everytime we make a change I would like these changes to be reflected on the report. For example, lets say I have a pie chart on this report showing some statistics. Once something is changed that affects these statistics, the pie chart updates to reflect these changes so the client can see the progress being made in real time.

Hopefully this is possible. Any help is always appreciated!

[Minty]

Assuming the data changes can be captured then the after update events on the forms used should be sufficient.

Charts and reports aren't designed to be dynamic as such, so you may have to "quietly" reload them.

[isladogs]

During these meetings the database forms will be on a larger display while we work through them with the client. The goal is for the client to be able to see the progress being made on another screen in the form of this report, so everytime we make a change I would like these changes to be reflected on the report. For example, lets say I have a pie chart on this report showing some statistics. Once something is changed that affects these statistics, the pie chart updates to reflect these changes so the client can see the progress being made in real time.

You said in the 'form of this report' which is slightly ambiguous.
Although reports won't update unless reloaded, forms can easily be updated by requerying so why not display the pie chart on a form instead.

[ItsRoland]

I worded my initial post poorly.
1. I should have mentioned that I was looking for a way to do this other than coding the report to update every time something changed
2. Where I mentioned "in the form of this report" I just meant viewing the progress in a report, not in a report within a form or anything like that. I apologize for the confusion.


I ended up just writing a function that updates the report, and calling that function anywhere that would be needed. If there's a better way of doing this I'd love to hear to it, but otherwise I achieved what I wanted.

Thanks for the help!