Solved

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

Posted on 2004-10-06
10
552 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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 …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now