Visual Basic :: How To Export Data From Crystal Report To Exel

Export Data In Listview To Crystal Report
I have a listview with data pulled from my MySQL database.
NOw I would like to print out the data in the listview. Note that my intention is just to print it.

I planned on using crystal report to print, to be more specific, i am thinking of first exporting the data to crystal report then call the print function to pribnt it. But how do I start? Do I even need crystal report in thye first place, because I just want the printing functuion?

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

Crystal Report To Excel Export
Hi,

I realise this is asked a zillionth time already but I'm still having probs and have not found any solution.

I've tried using the export code posted up in previous msges by "MKoslof " but I'm getting a a "Invalid TLV record" error msg as soon as it gets to the line....
Set rep = appl.OpenReport("c:MyTestRpt.rpt", 1)

I've tried searching for this "Invalid TLV record" error and there were a couple ppl that mentioned that it could be caused by my report file being created from a diff version to the Crystal Report I'm currently running. (Crystal Report 8,VB6) I'm not quite sure how to rectify this as no one in the office has the actual Crystal Report program installed as we all use it from VB using the dsr files. I've also tried using the *.dsr file as the parameter but that returns the same error.

If anyone can point me to the right direction it'd be much appreciated!

Sorry for the ignorance as I've only been exposed to VB and Crystal Report for last couple wks for work exp.

Cheers

Adeline

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

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

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.

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 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

Crystal Report Export Problem
Hi.
I use Crystal Report 8.0 in VB 6.0

I want to export report to Excel.
My problem, Crystal Report Export not work all time. Some times work ,some times doesn't work.

I tried in Crystal Desinger it work.
But in VB doest't work all time.
What can I do

How To Export Crystal Report Into .rtf Format
When I tried to save as a .rtf file, it is displaying strange characters. how can i export to a .rtf or .doc formats?

Thanks

Export Crystal Report 8.0 Using MAPI
Hello, i have encountered some problems when try to export crystal report throught Email. The thing that i try to do is try to export a list of report with different mail address in order to send out through MAPI.

The problem for the above case is :

Actually i try to send 100 reports to respective different email address account such as

Report1 -> User1EmailAddress
Report2 -> User2EmailiAddress
Report3 -> User3EmailAddress
. . . 4 -> User4EmailAddress
. . . 5 -> ......
. . . 6 -> ......
.

subsequent until No 100 report

The problem that i encountered here is my program will connect to Outlook Express and send the Report1 report to User1EmailAddress first. Once finished sent the Report1 then subsequent my program will connect again to Outlook Express in order to send for Report2 to User2Emailaddress.

if i have 100 of reports to 100 of different user, my program will keep run the looping for 100 time (connect to OE, Send, Dissconnect, and connect for next report)

so my concern here is, it that any way to send those 100 Reports
to my OE outbox 1st then only connect, send for those 100 reports
in one go?

p/s 1: i'm using VB 6.0 and Crystal Report 8.0 to develop this program
p/s 2: Different report for different User email account

Thanks guys