Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 574
  • Last Modified:

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

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
Hamlet081299
Asked:
Hamlet081299
  • 4
  • 4
1 Solution
 
frodomanCommented:
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
 
Hamlet081299Author Commented:
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
 
frodomanCommented:
>>> 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
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 
Hamlet081299Author Commented:
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
 
frodomanCommented:
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
 
Hamlet081299Author Commented:
Thanks for the suggestion, but that still didn't fix it.
0
 
frodomanCommented:
Sorry Hamlet - I don't have any other ideas on this one...
0
 
Hamlet081299Author Commented:
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
 
moduloCommented:
PAQed with points refunded (125)

modulo
Community Support Moderator
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now