Crystal report export doesn't work

[tb2007]

I have code for showing reports like this:


Dim rs as new ADODB.recordset

set rs= something.....

dim Report as new rptTest

Report.Database.SetDataSource rs
CRViewer1.ReportSource = Report
CRViewer1.ViewReport

This works fine, report is ok, but when I click Export button it doesn't work. I don't know why?

OK, I decide to put another button Export to form and to write export function.

I need to get report from CRViewer but I don't know how to do this, something like this:

set report=CRViewer1.ReportSource
report.export.....

but this doesn't work.

How to get report from CRVIEWER?

 

[chelseatech]

The Viewer object has a number of buttons you can enable or disable. Check the properties of that object.

Also, the export isn't available if the Export DLL's aren't installed, but I assume you have installed those with your report application.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[SBerthold]

>but when I click Export button it doesn't work

Then, what is it exactly doing?

If nothing at all, then you may be missing the CR export dlls in the \%Windows%\Crystal folder

 

[tb2007]

Then, what is it exactly doing?


Well, when I press export button, some windows appears to select format options, disk file....etc.... Everything is fine, but when I look at that file it is empty and 0 KB.
I have all dll on my pc, I found on

http://www that

many people have this problem, but nobody knows the solution.

 

[SBerthold]

Have you tried different export formats?

I do not have this problem, but I do not bind the report to a recordset. That may be a problem.

Try changing the reports Destination from "Window" to "File", set the Export PrintFileType property to text or what ever, and then print the report.

You may have to also set DiscardSavedData to False

 

[SBerthold]

This update should fix the problem for CR version 8:
ftp://ftp.crystaldecisions.com/outgoing/EHF/CR80DEVWIN_EN.ZIP


For more info see:

http://technicalsupport.businessobj...iceId=&dialogID=11350573&stateId=1 0 11354229

http://technicalsupport.businessobj...iceId=&dialogID=11350424&stateId=1 0 11354183

http://technicalsupport.businessobj...iceId=&dialogID=11350573&stateId=1 0 11354229

 

[tb2007]

Thank you, I put this patch and now I can export to doc, rtf....it is not empty zero byte any more.

But, when I want to export to pdf I get message Export failed. I have crxf_pdf.dll but something is wrong.

 

[SBerthold]

>I found on

http://www that

many people have this problem, but nobody knows the solution.

But you're here at Tek-Tips

Then the problem in the OP is solved here.
"Crystal report export doesn't work"
"...when I look at that file it is empty and 0 KB"

For your last question concerning PDF, continue with your other thread: thread222-1426746