Visual Basic :: Crystal Report To Excel Export

Export Crystal Report To Excel
Hi All,

I have a crystal report(.rpt file). I need to export that to excel in my vb(6.0) application. Everything works great. The only issue i have is, when i export the file to excel, the Page Header is not getting exported. So the excel has only the data without column names.

Any ideas?

This is what i am doing.

cdlAdHoc.ShowSave
cdlAdHoc.Filter = "*.xls"
strFileName = cdlAdHoc.FileName

    constr = "DSN=" & gDSN & ";"
    constr = constr & "UID=" & gLoginID & ";"
    constr = constr & "PWD=" & gPWD & ";"
    constr = constr & "DATABASE=" & gDatabase & ";"


            ' Here print the report
            frmReports.crReports.Connect = constr
           frmReports.crReports.Destination = crptToFile
           frmReports.crReports.PrintFileType = crEFTExcel80
           frmReports.crReports.PrintFileName = strFileName


        frmReports.crReports.ReportFileName = App.Path & "
ptNickGeneralInfo.rpt"

           frmReports.crReports.Action = 1

Export Crystal Report 9 To Excel
Hi,

Plz. Help me to export the crystal report 9 to excel sheet without asking any parameter?

Crystal Report 8. Export To Excel File
Hi! Good Morning!

I am Tan.

I am using crystal report 8.
In the icon like envelop. I can't export out the report in Ms Excel. I can export to PDF, text and etc. Just cant found the Ms Excel.

Same program, i have install to 2 PCs. Only one of the pc facing this problem. What should i do now?

When i install the program, i also copy
c:winDOWSsystem32
egsvr32 crviewer.dll
c:winDOWSsystem32
egsvr32 Crystl32.OCX
c:winDOWSsystem32
egsvr32 crpe32.dll
c:winDOWSsystem32
egsvr32 craxddrt.dll
c:winDOWSsystem32
egsvr32 craxdrt.dll
c:winDOWSsystem32
egsvr32 craxdui.dll
c:winDOWSsystem32
egsvr32 cpeaut32.dll
to the 2 PCs.

Please help me!

THANKS!

p/s : I am very sorry that i have to post in classic visual basic. Because not reply in crystal forum.

To Export Crystal Report In Excel Format
Hello friends,

I made an application in vb 6 to generate crystal reports but i don't want to use export button of crystal report and want to add my code in vb which will automatically convert it into excel or pdf format. Also if possible it shld automatically send mail to my id without using outlook express....

waiting for responses,
varsha

How To Export Crystal Report In Excel File Using Vb 6.0
hi

I want to write a code in vb which will directly export crytal report into excel or pdf format.... Also tell me which components should i use?

thnx in advance,
varsha

How To Export Crystal Report To An Word And Excel File
hi Everyone,

does anybody know how to export a crystal report to an word(.doc) or excel(.xls) file.

This is really important to me b`cos i have all the reports in crystal reports and i have to mail them, but i couldn`t do this because they are all in crystal report format.

but if I just can export this reports to a word or excel file then i will be able to mail them..

I really appreciate it if anybody can show me how to do this or give any URL relevant to this...

thanx in advance,
niroshan

How To Export Crystal Report File To Excel 8.0(extended)?
how to export a crystal report file in excel 8.0(extended) format?
i'm using crystal report version 10.
thank you.

Excel Option Doesnt Come In Crystal Report Export Dialog Box
hi everybody i am using vb and access and crystal report for my application.before i had problem of export dialog box not coming.but that problem is solved by adding CRXF_XLS.dll and now the dialogbox is coming but excel option is not coming.i think it is a problem of missing another dll, i have also included u2fxls.dll but then also excel option is not coming so please help me in this regard. tell me which dll to include so that excel option can come.
with regards
ashok
thanks in advance

Crystal Report Export To Excel Not Woking From Vb Packege Dan Deploy
When i install packege an deploy in other computer crystal report view and print work fine
but export button not respon and when I use this code :

Code:
Dim crRpt As New crView1
crRpt.ExportOptions.FormatType = crEFTExcel80Tabular
crRpt.ExportOptions.DestinationType = crEDTDiskFile
crRpt.ExportOptions.DiskFileName = "C:Test.xls"
crRpt.Export (False)

it show error, its posible to export report without install crystal report in other computer??

Failed To Export The Report, Error In MS Excel Export Format DLL
Hi,

I have a little problem with Crystal Reports (CR 8) :

I try to export one of my reports from a VB program. When I try to export it in "Comma Separated Values" format everything is ok (except this is not the format I need
). When I try to export it in excel format it works, on some PCs but not on others ?

VB code sample :

rpt.ExportOptions.FormatType = crEFTExcel80Tabular
rpt.ExportOptions.DestinationType = crEDTDiskFile
rpt.ExportOptions.UseReportDateFormat = True
rpt.ExportOptions.UseReportNumberFormat = True
rpt.ExportOptions.DiskFileName = txtExportDirectory.Text & ExportName
rpt.Export False

I tried all the excel formats (crEFTExcel50, crEFTExcel50Tabular, crEFTExcel70 ...) but on some PC's I always get the "Exporting Records" window for a second and then the error "Failed to export the report, Error in MS Excel Export Format DLL".

Can anyone help me out ?
Thanks !

Prob. In Export A Report In RTF Format Through Crystal Report 8.0
I have a prob. in exporting a report in rtf format through crystal
report 8.0 on some client machine...

i am able to export report on my pc. but not on client machine....

plz suggest

--
Best Regards,
Sachin Jain

Export From Crystal Report!
Pls help me!

In my program, I made a report(Crystal) and then I want to export this report to a Rich Text file. I use the following sub:

Sub ExportReport()
Report.SelectPrinter Printer.DriverName, Printer.DeviceName, Printer.Port
Report.PaperSize = crPaperA4
Report.PaperOrientation = crLandscape
Report.Export
'Report.PrintOut False
End Sub

When the ExportReport is called, a dialog appears allowing me to choose the format file and the path to save it.
But I want to specify the format and the path in my program(it means that the program does all things) how can I write the code for this?

If I have many reports can I export it into only one file (for example, We have report named report1.rpt and we export it into the rich text file name rtfTest.rtf. Then we have another report named report2.rpt, can we append it into rtfTest.rtf)

Thanks in advanced.

Export Crystal Report
hi,

i have made a report using crytal report, i am able to export the

report to HTML format from my machine. But there is no option

listed in the export box like HTML when i installed my

application in other machine. The other machine have Internet

explorer 5.5. Y is this so ?

any suggesstion will be appriciated..

regards

mohan

Crystal Report Export To PDF
Hi,

I'm trying to export a Crystal Report file to a pdf file using the automation server method. My code is as follows:

Dim App As CRPEAuto.Application
Dim Report As CRPEAuto.Report

Private Sub cmdPrint_Click()
Dim obj As Object
Set App = CreateObject("Crystal.CRPE.Application")
Set Report = App.OpenReport "c:dmsreportsServiceSummaryTotals.rpt", 1)

Report.ExportOptions.DiskFileName = "C: emp est.pdf"
Report.ExportOptions.DestinationType = crEDTDiskFile
Report.ExportOptions.FormatType = crEFTPortableDocFormat
Report.Export False

When i ran this code, i got a runtime error message saying "Invalid enum value" and the error number is 30012. However, when i changed the file extension to .doc and set the FormatType = crEFTWordForWindows, it worked fine. Also when i changed the code to Report.Export True and selected the file format mannually, it also worked fine. I was just wondering if anyone out there has come accross this problem before and can help me out of my misery. Thank you so much in advance.

Longman

Crystal Report Export
Quote:

Originally Posted by MKoslof

The structure of the .ExportOptions method is as follows. Make sure all the export dlls are on your development machine..this has been a known problem. Before trying the code insert your Crystal Reports CD or get to the installation source. Do a change/modify and expand ALL folders so you get any dlls that were not installed during your initial installation (sometimes all export dlls are not installed on the first run). Then in your VB code you can use the .ExportOptions method to send your report to varying formats, including HTML

Code:
With crxReport
.ExportOptions.DiskFileName = "name of new file"
.ExportOptions.DestinationType = "destination type"
.ExportOptions.FormatType = "your format"
.Export False 'so it does not prompt the user, automatic export if false
End With

I work also with VB an CR. But i work with CR XI.
But when I want to export my report, it doesnt work.
Can you help me?

Code:
Private Sub SetData()
Dim rsTemp As ADODB.Recordset
Dim Report As CRAXDRT.Report
Dim Application As CRAXDRT.Application
Dim strSQL as String

Set Report = Nothing
Set Application = CreateObject("CrystalRuntime.Application.10")
Set Report = Application.OpenReport("C:myReport.rpt")

Report.DiscardSavedData

Report.RecordSelectionFormula = "{Table.Field} = '" & Field & "' AND {Table2.Field2} = '" & Field2 & "'"

Report.ExportOptions.FormatType = crEFTPortableDocFormat
Report.ExportOptions.DestinationType = crEDTDiskFile
Report.ExportOptions.PDFExportAllPages = True
Report.ExportOptions.DiskFileName = "C:Data.pdf"

Report.Export (False)

Set Application = Nothing
Set Report = Nothing

End Sub

How To Export CRYSTAL REPORT To PDF Using VB6
Actually in an application (VB 6 & CRYSTAL REPORT 8) I got a problem with RTF Export option. The settings (Tab settings, Paragraph settings etc.) got changed in RTF file.
One more thing is that, user can edit the RTF file.

So I need to export CRYSTAL REPORT to PDF format.
How to ?
Plz help..

Crystal Report Export
I am a newbie and need some help with some basic code.
I am using Crystal Reports 8.5 and VB6 (sp6).
I am trying to export a report to html.
The report works fine in the Crystal Report Designer...there are no paramaters or anything to pass to it.
I do not have the Crystal Developer version so I am just trying to use the ActiveX Control (not the RDC).
I configured the properties of my ActiveX control and my code works but the output is ugly. It is all one page etc. It doesn't have the navigation links at the bottom like it does if I export from within the designer.
Here is my code:

Private Sub Command1_Click()
Form1.CrystalReport1.ReportFileName = "H:VB6SuSchedSuSched.rpt"
Form1.CrystalReport1.ReportFileName = "H:VB6SuSchedSuSched.html"
Form1.CrystalReport1.Destination = crptToFile
Form1.CrystalReport1.PrintFileType = crptHTML32Std
CrystalReport1.Action = 1
End Sub

Is there an equivalent to ExportOptions.HTMLEnableSeparatedPages for ActiveX controls?

Any other advice?
Thanks in advance.
Jeff

Crystal Report Export
Hey MK and Zerocool! Thanks again for your help!

It's working now under Crystal Reports ver 8.5. Yeah!!!!!

Another issue I ran into is the export button of the Crystal Report Viewer. It's working on the development environment (Win98) and also on a Win 2000 client computer. But when I installed it on a Win XP machine, the report comes up but when you click on the export button nothing happens.

I tried to Google this, but I haven't been able to find anything specific about this type of issue.

Help again!

Thanks in advance!

-xmen64

VB6+Crystal Report EXPORT
I have two questions about the Crystal Report V8.5 professional with VB6

1. I can export a crystal report to a PDF format to Mail or file locally inside the development environment run time or complied executable. However, the 'Export Report' button just hasn't do anything although it can be clicked. (We execute the program under the Citrix terminal service environment and it has the CR V10. being installed)

2. How can I export to 10 seperated PDF files with per-defined file name inside VB6 using Crystal report components.

Thanks in advance

Export From Crystal Report
Hi all!

I have a big problem when I try to export from Crystal Report 8.5 in .pdf from VB6. I use a database made in SQL Server 2000.
The problem is that all the decimal fields in database are truncated in pdf when I export from VB6. For example, If I have 75.45, it will return 75.00. If I export the data direct from Crystal Report, it works fine.
I tried with some updates for Crystal Report, but with no result.
Please, help me!

Export A Crystal Report To Pdf.
i have an app that generates a crystal report, in preview mode. the issue is when i press the export feature in the crystal report viewer i do not have the option to export to pdf. on all the other pc on the network i have the pdf option. all the pc's have the same install and i reinstalled adobe reader 6.0. can any help me with this issue. is there some file i need to check or reregister.

Thank You,
Thomas

Crystal Report Export HELP!
Hi,

I'm using VB6 + CR7, one of the report I design contain a subreport. In the subreport, the detail may span over one page, and the group header will print again in each page.

When I preview my report, everything is fine. However, once I export the report to Paginated Text format, the group header will not repeat on 2nd pages and so on.

Can anyone teach me how to solve this problem?

Thx!

Export Using Crystal Report 8.5
I'm new to Crystal Reports... I've created a report in a VB application that has the export function enabled on the crystal viewer. It works great on my computer, but if I install the VB application on a machine that does not have crystal reports installed, the export function (on the tool bar) does nothing.

I assume that I need to include a dll in my package and deployment, but I'm stumped beyond that.

Am I on the right track??? What dll's do I need to include??? Is there something else that I'm missing?

Thanks!

Export Crystal Report
Hi VB addicts......
I created a Crystal Report in my VB application. I can't export it to any format using the built in exportbutton.
Please tell me what can I do to fix it. What *.dll are required to export and such?

Thanks in advance.

Norm

Export Crystal 8 Report To Pdf?
I have VB application with Crystal 8 reports. I need to export report to pdf, but Crystal 8 does not support this.
Can anybody help me?

Export Crystal Report To XLS [MS SQL]
good day everyone... i am having a hard time exporting my report to xls format ... i am using crystal 8 ... isn;t that with crviewer once a report is viewed above the form we have some icons there -- the envelope with arrow (Export Report) -- seems not working for xls ... with other format it can, like dhtml but i badly need to export it to xls format... is there any other way? do i need to install 3rd party softwares? or can be solved with some codes? i deeply appreciate if someone could guide me to solve my problem ... thanks in advance

Help In Crystal Report Export
Hi

(1)
I m using crystal report 8.5 in visual basic 6.0, and i have a problem with crystal report. The problem is that i have displayed records on the crystal report from database, using stored procedure. It is working fine, but while displaying records on the crystal report i change the value of some fileds in crystl report's designer's Section10_Format() event. The changed records are dispalyed correctly on the report but when i export that report in text or word format the changed fields are not exported. why this happened....?

Please help me in this problem

(2)
There is problem while using visual basic 6.0 and crystal report 8.5, the porblem is that when crystal report is displayed with records then it also show tool tip text of every field when mouse cursor is placed on that field including Stored procedure name, field's data type etc. Now I want that this tool tip text should not displayed. How it is possible...?

Please help me

Thanks

Export Help In Crystal Report
hi
I m using crystal report 8.5 in visual basic 6.0, and i have a problem with crystal report. The problem is that i dsiplay records on the crystal report from data base using stored procedure. it is dine fine but while displaying records on the crystal report i change the value of some fileds in crystl report's designer's Section10_Format() event. The changed record are dispalyed correctly but when i export that report in text or word format the changed fields are not exported. why this happened....?

Please help me in this problem

Thanks

Crystal Report(Export)
i am trying to export a .rpt file with the code below.But this leads to an error which says "Invalid directory".

db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBName & ";Persist Security Info=False;"

        rs.Open strSQL, db, adOpenKeyset, adLockOptimistic
        Set r = a.openreport(strReportFile, 1)
        r.Database.SetDataSource rs

        r.Export True

could anyone help me with this,
thanks in advance

Crystal Report PDF Export
Hi,

I have exported the Crystal Report in PDF by using the ASP code. The export functionality works fine but there is one catch. In the final exported PDF file the first page repeats i.e. First page shows twice.
If i have one page in crystal report, PDF contains 2 pages .
If i have 20 pages in Crystal report, PDF contains 21 page out of which first and second page have first page repeated.

Can anybody help me out.
Thanks.

Export To PDF Problem With Crystal Report
Got a problem with exporting to PDF file, the generated report has several pictures per detail, but when exported to PDF only one picture is being exported.

Thanks in advance for your help.

Export Crystal Report To File PDF With VB6
Hello ,

I 'm using VB6 et CR8.5: and I want to know how export a report to file type : PDF.

when I writing the following code: CR1.printfiltype= ????,there isn't the option PDF.
someone can help me?

thanks

How To Export Crystal Report To Word
Hi,

Does anyone know if it is possible to export the output of a Crystal Report to a Word document using VB code? I know how to do it in the Crystal Report interface but don't know the command for exporting to Word document in VB6.

The reason for this is that I need to send the output via email to the customers and I assume they will have Word installed in their PCs.

I am using CR9.

Thanks.

Mike

Export Crystal Report To RTF Or Word
Actually I have a system which is written in VB6 which has the viewer to view the reports. However, when I tried to export the report into either RTF or Word format, the page numbering seemed to be distorted.
eg. The page numbering is Page N or Total of Pages
When viewing the report, it displays correctly, Page 1 of 2, Page 2 of 2
But when I exported it out and opened it again the page numbering becomes Page -1 of 1 on every page even though its supposed to be Page 1 of 2, Page 2 of 2 & etc.
Also, I found out, not all the pcs have this problem. I suspected that it depends on the version Microsoft Office which is used. Appreciate any feedback! Thanks in advance!

Crystal Report 9 Export To Text
Im trying to export reports in Crystal Report. There seems to be no problem in the main report's txtfile output but in the subreports labels and data are misaligned. So the report looks distorted. Thanks Extreme people.

Crystal Report 8: Export Issues
Hi,

I've got a problem here when developing my application using the VB6 + CrystalReport8.0

To export the report generated (from the CRViewer in the VB6), I've first use this method:
i) Using the built-in export button from the CRViewer. However, when I export the report into CSV, the CSV file generated shows nothing eventhough there's value in the report.

ii) And so, in the same PC, same coding, I've amended a few lines, adding the export report coding. It works perfectly.

And so, I don't think it's the dll problem. And I can't really think of the cause. Pls. advice and thanks in advance.

Regards,
Jerry

Use Export Feature Of Crystal Report
I want to export a Crystal Report to PDF file, but without opening Crystal Report form in Visual Basic.

Crystal Report Export Problem
Hi, I'am using Crystal Reports 8.5 comprising of abt 6 Subreports. I'am using the following code to Export from Crystal Report:

Code:

rptInvoice.Sqlquery = "Select * From Temp_Hdr Where Acctno Between '02200000' And '02219999'

rptInvoice.ReportFileName = "D:REPORTBILL.RPT"

rptInvoice.Destination = crptToFile

rptInvoice.PrintFileType = crptCrystal

rptInvoice.PrintFileName = "D:" + txtBillPeriod + "_Test" + Format((Now), "yymmddhh") + "-" + Trim(FromAccount(i)) + "-" + Trim(ToAccount(i)) + ".rpt"

rptInvoice.PrintReport

(1) Now my problem is it's not generating any output (for a big range of numbers as specified above).
(2) If I pass the Acctno value as a small range like '02200000' - '02201000', it's completing the process successfully, but...
the file size generated is very big.

Why is it so? Can anyone help to solve this issue???

Thanks in advance

Crystal Report Export Option
Dear all,

How to use use Crystal Report Control to export report to PDF format by using coding?

If I go (manually) to Export option, I can see an option to export to PDF and it works.

How to do it by coding? PrintFileType doesn't have PDF.

With Me.CR

.ReportFileName = "x:Report.rpt"
.Destination = crptToFile
.PrintFileName = "x:Report.pdf"
.PrintReport

End With

Looking forward for your reply.

Thanks in advance
Keiko

Export Crystal Report Through VB Code
Hi all
Here I am having a problem
I want to export crystal report file (in Paginated Text format)
through my vb code so that customer need not to worry about creation the file
any body suggest me the code for that

Export Option In Crystal Report
Hi Friends

I am using a Seagate crystal Report 7.0 for Report design.

In some of the client machines after report is displayed ,

Export option is not displaying any thing .

So users are not able to export their report to Microsoft Excel.

Crystal Report is not installed in the client machines . Only reqired
support files are loaded

What can be the reason?

Thanks
Aravind

Problem In Export The Crystal Report
hai

when i try to export my report to outlook express(want to mail the report), it flashes the message:

Either there is no default mail client or the current mail client cannot fulfil the messaging request. please run ms outlook and set it as default mail client.

How to set it as default mail client.

Please help me out.

Regards
Sasi

*****************
SASIKUMAR R.
S/W PROFF.
EZHIL CHENNAI.
*****************
COMPASSION IS THE HIGHEST VIRTUE.

Export Crystal Report To PDF Format
Does anyone know how to export a Crystal Report file to PDF format?

Thank you

Regards
WSL

Using VB6 To Open Crystal Report And Export It To Pdf
I wrote a script to query up about 50 ids.  Loop thru them and open up the crystal report and pass the ids then export it to pdf format.

I have 2 questions.
1.  Instead of doing the below statements each time is it possible to do a refresh?
    Set Report = crxApplication.OpenReport("test.rpt", 1)
    ...
    Set Report = Nothing
    Set crxApplication = Nothing

2.  Sometimes VB closes after it attempts to export. Any ideas?  This occurs just before I set the report = Nothing.

Crystal Report Export To .RTF Format
While exporting report from crystal to .rtf format in MS Word, It exports the text boxes also to the .rtf file..Is there any way to avoid this and only plain text shud get exported to the rtf file rather text with text box.

Crystal Report Export Problem
Hi, I'am a new member looking for resolving this problem.

I'am using Crystal Reports 8.5 comprising of abt 6 Subreports. I'am using the following code to Export from Crystal Report:

Code:
rptInvoice.Sqlquery = "Select * From Temp_Hdr Where Acctno Between '02200000' And '02219999'

rptInvoice.ReportFileName = "D:REPORTBILL.RPT"

rptInvoice.Destination = crptToFile

rptInvoice.PrintFileType = crptCrystal

rptInvoice.PrintFileName = "D:" + txtBillPeriod + "_Test" + Format((Now), "yymmddhh") + "-" + Trim(FromAccount(i)) + "-" + Trim(ToAccount(i)) + ".rpt"

rptInvoice.PrintReport

(1) Now my problem is it's not generating any output (for a big range of numbers as specified above).
(2) If I pass the Acctno value as a small range like '02200000' - '02201000', it's completing the process successfully, but...
the file size generated is very big.

Why is it so? Can anyone help to solve this issue???

Thanks in advance

Please Help.Crystal Report Export Problem
Hi.

In Visual Basic 6.0 with Crystal Report 8.0,

I click export button on My Report preview.(CRviewer). I select Excel 7.0 and Application.
Then click OK. Displaying a messagebox with "Can not create a temp file Do you want to create a temp file yourself..." . and I select a file. Some times ask again temp file and export successfuly. But some times not ask again so does't export.
What can I do.
Sorry my bad english.
Thanks.

Dll's Required To Export Crystal Report
Hi!

I've created reports using Seagate Crystal Report version 6.0. The problem is I'm not able to export the report. When I click the Export Icon of the report it is not displaying any dialog box to export report.

when I tried installing Seagate crystal reports software on the system then I could able to export report. But I couldn't able to find the dll's required to export that report. So that I can include in the package to install at client's place. Hope u have a solution for this. Waiting for immediate response as it is very urgent.

Thanks in advance