OWC PivotChart in Access Report

[Tobias Olbort]

Hello,

i've written a VBA-Function in Access, which builds up a Chart from a
blank ChartSpace-object (OWC10.ChartSpace.10).

This works fine in within a access form.

But in a access report the folling happens:

I should get ONE page with the chart, but i get three or more pages.
The first contains the blank ChartSpace (with the OWC-Logo). This will
be displayed immediately. The second and following pagees contain the
chart. It gets builded up very very slow, so that i can see each line
getting printed.

Is it possible at all to display a OWC-PivotChart in a report? What's
wrong here?

To workarround, i've tried to build the chart in the background,
export it to a jpg or gif and load it to a picture-control in the
report. But the quality of the exported image files is very poor and
not usefully.

Thanks for any idea.

Tobias

 

[Yuan Shao]

Hello Tobias,

Thanks for your post. We are able to add the Microsoft Office Chart 10.0
object in the report object. Was this the object you used? Based on my
experience, the PivotChart in the report is as a view so you cannot to
change the PivotChart as it is in the form.

According to your description, I am not sure what the problem is on your
side. Will you provide more information so that I can narrow down this
issue?

1. What is the version of Microsoft Access?

2. What made you think the Chart needs only one page to display in the
report?

3. Please provide the detailed reproduction steps so that I can reproduce
this problem on my side.

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Tobias Olbort]

Hello,

I've tried to send you a mail with a small MDB as sample. But I'm not
sure, if you've got it.

Can you please tell me, if it has arrived?

Thanks.
Tobias

 

[Yuan Shao]

Hi Tobias,

Thanks for your feedback. Unfortunately, I did not receive your mail.
Please make sure that you send your mail witht the sample to me at
(e-mail address removed).

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Yuan Shao]

Hi Tobias,

Thanks for your sample codes. Unfortunately, I am unable to run the sample
codes on my side. Many event errors occurred. Based on my hard research, I
suspect this problem is due to the language version of the sample database.
On my side, the language version of Access is English, I would like to know
what language environment is on your side so that I can perform further
research.

Also, such issues tend to be complex and take up extensive research time.
I'd like to set your expectations that it may take a while for us to help
you narrow down the problem and we may eventually redirect you to PSS to
continue working with a dedicated Support Professional. Your patience is
appreciated. If this is critical, I'd recommend contacting PSS and opening
a Support incident to troubleshoot this further. If you need any help in
this regard, please let me know

I am standing by for your response.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Tobias Olbort]

Hello,

my language version is german. On my system I don't get any errors.

I'm a msdn universial subscriber. As far as I know, it is possible, to
get any further help with that. How can I do that?

Thanks.
Tobias

 

[Yuan Shao]

Hi Tobias,

Thanks for your feedback. Your information of language version is
important. I changed the Language version of my computer to German and
started the sample database on my side. Now I am able to start the Access
database successfully. Aslo, I think I see the problem you described.

I would appreciate your patience while I am performing further research on
this problematic database. I will post my response as soon as I have update
for you. I will do my best to help you solve this problem.

In addition, if the problem is too complex to be handled in newsgroup. it
would be best to contact Microsoft Product Support Services so that a
dedicated Support Professional can assist with your request more
efficiently.

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Orlanzo Ross]

Tobias,

I am currently researching this issue for you. I will provide additional
information as it becomes available.

Best regards,
Orlanzo Ross
Microsoft Product Support Services

 

[Janet Chisholm [MSFT]]

Hi Tobias,

We are still researching this issue and what might be causing the behaviour
that you are experiencing. I have been able to duplicate the behaviour on
my machine and will continue to investigate further. Can you please
confirm the following for me:

1) What is the version of Access - with Service Packs?
2) What is the version of Windows - with Service Packs?
3) What is the version of msjet40.dll?
4) Are you able to create a chart successfully, on a report, in any
database?

Again, I will continue to investigate and provide additional information as
soon as I have it.

Thank you,
Janet Chisholm
Microsoft Access Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Tobias Olbort]

Hello Janet,

sorry for my late answer. Because of the christmas-holydays, i didn't
read your posting earlier.

Find my answers below:

Hi Tobias,

We are still researching this issue and what might be causing the behaviour
that you are experiencing. I have been able to duplicate the behaviour on
my machine and will continue to investigate further. Can you please
confirm the following for me:

1) What is the version of Access - with Service Packs?

Tested on two different machines: Access 10 (SP2) and Access 11
(11.5614.5703)

2) What is the version of Windows - with Service Packs?

Windows XP Prof. SP2 (5.1.2600)

3) What is the version of msjet40.dll?

msjet40 4.00.8015.0 1,44 MB (1.507.358 Bytes) 01.11.2003
23:37 Microsoft Corporation c:\windows\system32\msjet40.dll

4) Are you able to create a chart successfully, on a report, in any
database?

Yes, but not with this PivotChart-Object

 

[Janet Chisholm [MSFT]]

Hi Tobias,

Thank you for the additional information. This should assist in helping us
to continue the research on this problem. I will keep you updated on
anything that I can locate and will be back in touch as soon as I have any
new information. An update may take a day or two.

Do not hesitate to let me know if you have any questions!

Thank you,
Janet Chisholm

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Janet Chisholm [MSFT]]

Hi Tobias,

I just wanted to let you know that we are still testing and investigating
this issue. I have found that moving the report code to the OnFormat or
OnPrint events corrects the problem of the blank pages however; I still
experience the slow down and the chart being built line by line.

It may take a few more days before I have any additional updates.

Thank you,
Janet Chisholm
Microsoft Access Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Janet Chisholm [MSFT]]

Hi Tobias,

I just wanted to touch base on this issue and see if you received the
suggestion that I provided yesterday. If so, has this resolved the problem
for you? Please let me know how things are progressing.


Thank you,
Janet Chisholm

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Tobias Olbort]

Hello Janet,

in the report i've moved the function, which formats the chart, from
"Report_Page"- to "Detail_Format"-event. You're right, the first page
is now correct. But it is still very slow when i view it on the screen
(DoCmd.OpenReport stDocName, acPreview). When printed directly
(DoCmd.OpenReport stDocName, acViewNormal) without preview, it is fast
as it should be.

This is a great help for me, because i primarily need to print it
without preview. But it would be useful to know, if i can avoid the
slow painting on the screen.

For the moment, thank you for your excellent help with the best wishes
for the new year.

Tobias

 

[Janet Chisholm [MSFT]]

Hi Tobias,

Thank you for the update. Did you receive my additional post from
yesterday? If not, please test the following for the slow painting of the
report:

1) Open the Public Module
2) Move to the procedure called DiagrammAufbauen
3) Comment the line:

.DashStyle = chLineRoundDot.

4) Test the report. It should now behave the same as the form.

It appears that this line of code does in fact result in different
behaviour within a report. I have been able to reproduce the problem in
other databases as well. Please let me know if the workaround above
resolves the problem.

Thank you,
Janet Chisholm

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Janet Chisholm [MSFT]]

Hi Tobias,

I just wanted to follow up on this issue and see if you received the
additional workaround that I provided. Please let me know if this resolved
the chart issue for you.

For your records, here are the steps I recommended:

1) Open the Public Module
2) Move to the procedure called DiagrammAufbauen
3) Comment the line:

DashStyle = chLineRoundDot.

4) Test the report. It should now behave the same as the form.

It appears that this line of code does in fact result in different
behaviour within a report. I have been able to reproduce the problem in
other databases as well. Please let me know if the workaround above
resolves the problem.

Thank you,
Janet Chisholm

This posting is provided "AS IS" with no warranties, and confers no rights.