Report uses design data

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

A97 on Win2000 platform, FE/BE using MDE. FE is on PC, BE is on the server.

I've been programming in Access for nine years and have never seen this
before.

I have a report which uses an unbound subreport and MS Graph. Occasionnaly,
when the report is opened, it uses the default design data for display
rather than the data from the source query. When the user prints the report
(with the design data displayed), the printed copy has the "real" data. This
is sporadic and repeatable on a regular basis. Closing the report and
re-running it prodices the correct data.

I added code for NoData and error processing but neither get triggered. Did
not get any errors, not even 'Disk or Network error'.

I would expect a blank page versus the design data. Has anyone else ever
seen this?


Andy
 
I have this same problem, creating a chart using data from the raw table
rather than a query.

Fairly frequently, the chart will display the sample data (East, North,
Qtr1, Qtr2 etc) in print preview, and even when printed out.

I have tried this on about 20 computers on our school network, all using
office 2000 and Windows XP Pro.

Still looking for an idea for a solution.
 
Steve Paget said:
I have this same problem, creating a chart using data from the raw table
rather than a query.

Fairly frequently, the chart will display the sample data (East, North,
Qtr1, Qtr2 etc) in print preview, and even when printed out.

I have tried this on about 20 computers on our school network, all using
office 2000 and Windows XP Pro.

Still looking for an idea for a solution.
Click to expand...

Always start out with your chart on a Form, not a Report. Then set the Enabled
property to True and Locked to Yes. This will allow you to double click the
chart to bring up the chart designer while the form is in normal view rather
than having to do so while in design view.

When you enter the chart designer in this fashion you see your data rather than
the sample data. When you are finished working on the format of the chart you
can copy it into a report. Later you can modify the design of the chart from
within the report and you will see a snapshot of the live data that you saw when
the chart was in the form.
 
Sounds like good advice for development.

However, my report is in an MDE, and had been working flawlessly for months.
It is the sample data that was used in a stable development environment
(MDB) that now mysteriously appears in the MDE. A local table is created to
collect the data, and the chart uses a constant query to read the data from
the table. In the case where the sample data is displayed in the report, the
local data table was created with the correct data.
 
Andy said:
Sounds like good advice for development.

However, my report is in an MDE, and had been working flawlessly for
months. It is the sample data that was used in a stable development
environment (MDB) that now mysteriously appears in the MDE. A local
table is created to collect the data, and the chart uses a constant
query to read the data from the table. In the case where the sample
data is displayed in the report, the local data table was created
with the correct data.
Click to expand...

Ah, ok that's a different bug. Charts in Access have never really been 100%
reliable on reports. What's happening in your case is that the chart is taking
longer to refresh than the report and the report is not "waiting for it". In
these cases you either get old data (run a chart for VendorA and then run it
again for VendorB and you see VendorA's data again), or you see the sample data.

There is a Microsoft knowledge base article describing this bug that offers a
couple of fixes. I have had "mixed" levels of success implementing them.
 
Thanks. I'll give it a go.

Mind you, I don't much fancy trying to talk a group of 24 teenagers through
this process!
 
Rick Brandt said:
When you enter the chart designer in this fashion you see your data rather than
the sample data. When you are finished working on the format of the chart you
can copy it into a report. Later you can modify the design of the chart from
within the report and you will see a snapshot of the live data that you saw when
the chart was in the form.
Click to expand...

I've tested this method and it works if I only want to see the snapshot, but
I want the printed report to show the live data.

So, I still don't understand what is wrong, or how to get Access doing what
it should.
 
Rick,

This seems like what I'm experiencing too. I have tried on kb and can't
find anything relevant. Any ideas on how you looked when you find it?

I am running 50+ graphs via macro, and it, too, seems like occasionally it
doesn't wait for the graph to be done before printing. I get the default
data only.

It's comforting (?)to know that others have found the same thing, but I
would sure love to know how to either fix it or better cope with it.

Thanks a LOT for your help!

Calhoun Raccoon
 
Back
Top