Chart errors on subsequent reports

[ndeans]

Hi there all. I have built a database that collects our clients Baseline health data which generates a series of single page reports for each type of health test that has been completed.

So for example we take blood pressure and return a single page report with a chart containing both systolic and diastolic (120/80 etc). The chart also returns age/gender related risk ratings based on their own scores (eg low risk, Normal, Hypertension etc). There is, in this case, as well as many others, a need for a calculated value and a specific chart for it's display.

My biggest concern at the moment is an inconsistancy in the accuracy of the charts when sending the reports to the printer. I have set up a macro that opens each report in sequence and prints it to the default printer (which is currently CutePDF). Unfortunately i have to check just about every print run for differences between the calculated field and the associated chart. I have noticed that when this occurs the chart will print off using the temporary figures that were used in the chart specific table when i was designing it. This however is also inconsistent in that i can run the report macro again and things will all work out OK.

Is it possible that my computer (pent M centrino 1.5GHz Laptop) is just not quite up to it and therefore i get some holes in the data or is there some way i can be clearing the calculated cache data between reports.

Additional:
I have added an example. The zip file contains 2 report pages (one correct) and the other with a discrepancy which will be plainlyobvious. This page is page 3 of a 10 page report. All 10 reports are distinctly seperate and are generated in sequence via a print macro i have done.

Any help will be greatly appreciated.

Cheers All

 

[Moniker]

It has nothing to do with the computer. Are you refreshing/requerying the report on each run? If you're not, that's an issue. If you are, have tried throwing in a DoEvents in the OnFormat event of the report?

 

[ndeans]

Moniker,

Not entirely sure what you are referring to with regard to refreshing/requerying on each run, though it sounds like something that might do the trick. I have added a zipped copy of an example. This may help clear things up.

 

[Moniker]

Whatever you're seeing as an obvious error is not very obvious. Define what is wrong in that PDF. I don't know how much help myself or others will be by just looking at the results, but if you can explain specifically what is wrong (using the PDF as your example), that may help.

 

[ndeans]

Sorry Monika, Notice on page 1 of the pdf the BGL figure is correctly shown in the field as 3.89 while it shows 4.25 in the chart. A second attempt of the print run is represented by page 2 where you can see that the figures are correct in both the field and the chart.

Actually i should also mention that this only happens with the charts, never with the field based figures on the screen. I have to assume that there is some way to ensure a proper redrawing of each chart every time a report is generated, this might fix the problem, i'm just a little unsure how to achieve this.

This is my problem, i can't see any reason why this error should occur.

 

[Moniker]

OK, it looks like the Fasting BGL field is not updating properly. The chart looks right in both cases. Where in the report design are you sectioning/grouping the Fasting BGL value? Whatever section that is, go to its OnFormat event, and then refresh/requery that field, as in Me.YourFieldName.Requery (if it's a calculated field) or Me.YourFieldName.Refresh (if it's from a table). Throw in a DoEvents immdeiately following that and see if that helps. If not, you may need to post a stripped down version of the DB (the report and the table/query it's based on) to get help.

 

[ndeans]

Sorry Monika, i never do seem to be able to do things the easy way. Some info as follows might help clear things up.

1. The reports are not summary reports. They are individual reports based on 2 joined queries (one getting info for current test and one getting info for previous test) that is all related to the individual client ID as well as an Assessment ID.

2. All reports have been designed to fit neatly into one A4 page.

3. So if a client does Assessment A (Tests A, B & C) then they get Report A, followed by Report B followed by Report C. If the client does Assessment B (Tests A, C, X, Y & Z) then they get Reports A, C, X, Y & Z.

What you are seeing in the example pdf is page 1 is incorrect and page 2 is correct. These are both report pages for the same individual and the same test. As the chart does not match the feld data on the first page i have to run the print protocol again to generate the second page. (note: the field figures are the same - as they are meant to be). But on so many occasions there will be an error in the chart when i first run the print which means lots of wasted time double checking the reports before i can send them on to the client.

I know you're probably a bit perplexed by it all, so am i sometimes, plus i've probably done some things that are a real step away from the norm so i understand if/when you get tired of hearing from me, i appreciate very much the time and energy you are expending on little old me.

Cheers