Usual problem saving snapshot report

[skwilliams]

I have a report which is saved as a snapshot file for viewing on our intranet site by way of a button on the data entry form.

My problem is when I check the report on the Intranet the first time, it may not show all the inputted data. So I have to go back into the database and resave it via the button. It will then display correctly.

Any ideas what causes this problem?

 

[directormac]

Snapshots are static, not dynamic, so it's not going to update with new data. Think of them as a "print to file" sort of thing.

If you have the db always running, you could put an OnTimer event to create a new snapshot and save it over the old one. Otherwise, if you're an .asp guru you can probably have the current button on the web form tell the backend to make a new snapshot at that moment, but that stuff's way above me.

I'm sure Pat or Jack has a more elegant solution, but that's my $0.02.

--Poor Mac

 

[skwilliams]

I'm the only one in the DB and didn't add any information between saves. The form is completely filled out and saved as a snapshot via the button. I open the snapshot file and only part of the data shows on the report. If I go back to the form and click the button again, then bring the snapshot report back up the information is completely there.

Puzzling?

 

[directormac]

Ok, that IS odd. I would try (just out of desparation) refreshing the records just before the snapshot is created. If that doesn't work (and this is REALLY kooky), set your macro to create the snapshot twice?

--Stumped Mac

 

[skwilliams]

I'll give it a try.

Thanks.

 

[jbandarovsky]

skwilliams,
Did you solve this problem? I am having exactly the same problem with my Database !

 

[Cosmos75]

Also interested in a solution to this

I am also interested to know if there is a solution to this.

 

[skwilliams]

I've found the only way I can do it is to enter the information, exit the application, reopen it and then save as a snapshot. This is a pain but it works.

I've tried saving the record and requerying it. Neither worked.

Thanks.