Solved

ActiveX Viewer: Data from Subreport not Exporting to Excel/Word

Posted on 2004-10-06
10
566 Views
Last Modified: 2008-03-17
I am working on an intranet interface for Crystal Reports, but have found that the ActiveX Viewer does not export the contents of subreports to Excel or Word.  It works okay from Crystal Reports itself, and the data is exported to other formats from the ActiveX viewer too (eg. PDF, RTF).

So does anyone know WHY the ActiveX viewer seems to completely miss the subreport for export to Excel?

Thanks for any suggestions.

H.
0
Comment
Question by:Hamlet081299
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
10 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 12247901
I don't know what version of CR you're working with, but there was a login problem with 8 for Excel exports - if you're doing this runtime the subreport may be failing to authenticate and causing this error.  It was fixed by a hotfix though: http://support.businessobjects.com/library/kbase/articles/c2009365.asp

If that doesn't sound like your issue, please advise the version of Crystal you're using.

frodoman
0
 
LVL 5

Author Comment

by:Hamlet081299
ID: 12254426
Should have said from the start ... Crystal Reports Developer, version 8.5.0.217.

As far as I can tell I have installed all Service Packs and Hot-fixes.

0
 
LVL 42

Expert Comment

by:frodoman
ID: 12257593
>>> As far as I can tell I have installed all Service Packs and Hot-fixes.

Are you absolutely certain?  Based on the link I gave you, for Crystal 8.5 this was fixed in service pack 2.  I'm not aware of any reason you would have this problem on a fully patched system.  Perhaps at some point Crystal was removed and re-installed but the service packs weren't re-applied?

frodoman
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 5

Author Comment

by:Hamlet081299
ID: 12273065
I am sure.  I only did the service packs AFTER finding the problem.  My only uncertainty was whether they were applied correctly.

The problem the link refers to is not quite the same thing.  I am not getting any sort of login prompt.  Also it mentions that there is no problem exporting to Word, but I DO have the same problem when exporting to Word.

The weird thing is that it works okay exporting directly from Crystal Reports.  It's only the ActiveX viewer that gets it wrong.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12277133
There is a hotfix specifically for the ActiveX viewer.  I don't know if it resolves this issue but it may be worth a try if you haven't done this one yet: http://support.businessobjects.com/communityCS/FilesAndUpdates/actxviewwin_en.zip.asp

frodoman
0
 
LVL 5

Author Comment

by:Hamlet081299
ID: 12282348
Thanks for the suggestion, but that still didn't fix it.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12286389
Sorry Hamlet - I don't have any other ideas on this one...
0
 
LVL 5

Author Comment

by:Hamlet081299
ID: 12292977
Yeah, that's okay.  I think for now I can get a similar (but not as visually pleasing) result by separately grouping the elements that were in the subreport.  It then exports okay.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12572825
PAQed with points refunded (125)

modulo
Community Support Moderator
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question