Solved

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

Posted on 2004-10-06
10
559 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
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

734 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