Solved

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

Posted on 2004-10-06
10
554 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
  • 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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

823 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