Export To Data Report
I need help attached file for your reference.
Question:
The report in the individual item for the long description line cannot form the second item in line.
For eg. Item 1 with the long description will jump down to second line, then for item 2 the description line should be printed on line 3, but some description line printed on line 2, it mess up the item 1.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Data Report Export
Hi
I am using a dataReport with DataEnvironment, I need to Export My DataReport to an EXCEL File, How can I do it?
Thank you for your concern
Roger
Export In Data Report
Hi Gurus!
I made a report using Data Report.
This report includes 8 images on RptImage controls.
There's no text in this report.
But in case export as html, there's no images in that exported html file.
Why does this happens?
Could anybody help me figuring out this problem?
Export Data Report In VB6
When I try to export a data report in VB6 I got "Report width is larger than the paper width".
Please help.
Thanks.
Export Data Report To File
I am trying to export a data report to file. It is easy enough to use the Data Report component of VB, but it does not support graphics. I am going to try and use crystal reports, but I cannot install the component correctly. I added by going to Project->Components->Crystal Report Controls
But if I go to Project->References there is no reference to Crystal Reports. What am I doing wrong?? How do I correctly set up Crystal reports?
Thanks,
Brandon
Data Report Export Command
I was just wondering if I could remove the export command on a data report? I have been searching it but haven't found anything that will really help.
Export Button On Data Report
Does anyone know a simple way to disable the export button on the data report? I'd like to allow users to print out the data but not to export it to a file.
Disable Export Button On Data Report
Does anyone know a simple way to disable the export button on the data report? I'd like to allow users to print out the data but not to export it to a file.
How To Export Data Report In Excel Sheet
Hi,
I am using datareports to generate the reports in VB. I want to transfer datareports to excel sheet. Please let me know the code to transfer datareports in excel sheet.
thanks
Export Data From Crystal REport Viewer
hi friends,
i have used crystal report 8 , display records from my db. I have make Property Code:EnableExportButton=True of Crystalviewer. But when i click on export button and want to store all records in text or rtf file it doesn't store any data init.
so where m wrong , pls help me
How To Export Data To Excel From Cryastal Report
Hi all,
I want to export the data from crystal report to excel.
so i want to give one button , instead of using export
functionality in crystal report....
the same functionality i want to use ....just user clicks
on that..it has to store in the excel file in a specified formate...
let me know the code ....vb code
Thanks
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?
How To Export Data From Crystal Report To Exel
Hi all,
I want to export the data from crystal report to excel.
so i want to give one button , instead of using export
functionality in crystal report....
the same functionality i want to use ....just user clicks
on that..it has to store in the excel file in a specified formate...
let me know the code ....vb code
Thanks
Export Landscape Data Report To Text File
I can display and print a data report in landscape mode, but cannot get the report written to a text file without receiving the dreaded "Report Width is Larger than the Paper Width" error.
I've tried: filename1.ExportReport rptKeyText, with and without setting the paper orientation to landscape for the printer, but I still get the above error message. Any other suggestions?
Data Report Problem (export Format Messed Up)
Hello all,
I needs some help here before I pull out all of my hair. I wrote a program in vb6, that use an access db and data reports. The problem is that when I view my reports in the preview, everything is perfect, all formatting is where it should be, but when I export the file (txt or html, tried both) and save it to my computer and open it again, some the formatting is out of wack. Some parts skip over a few spots and some print on the line beneath it. Why is this doing this?
Help anyone.
Thanks,
Data Report Problem (export Format Messed Up)
Hello all,
I needs some help here before I pull out all of my hair. I wrote a program in vb6, that use an access db and data reports. The problem is that when I view my reports in the preview, everything is perfect, all formatting is where it should be, but when I export the file (txt or html, tried both) and save it to my computer and open it again, some the formatting is out of wack. Some parts skip over a few spots and some print on the line beneath it. Why is this doing this?
Help anyone.
Thanks,
creggio
How To Know The User Selection Export File Format Based On Microsoft Data Report
Hi all,
i am using microsoft data report in VB 6 , how to i get the user selection file format (open the export file dialog box) he or she wish to export the file for example to EXCEL. or is any window API to detect the file selection from the file dialog box.
after when the user select *.xls for export i wish to do other application processing , therefore is there any other to detect or know the file format selection from the file dialog box ?
Private Sub DataReport_Initialize()
rptDemo.ExportFormats.Add _
Key:="ExcelReport", _
FormatType:=rptFmtText, _
FileFormatString:="Excel (*.xls)", _
FileFilter:="*.xls"
End Sub
Private Sub DataReport_AsyncProgress(ByVal JobType As MSDataReportLib.AsyncTypeConstants, ByVal Cookie As Long, ByVal PageCompleted As Long, ByVal TotalPages As Long)
Dim iCount As Integer
Dim i As Integer
'iCount = rptDemo.ExportFormats.Count
'
'For i = 1 To iCount
' Debug.Print rptDemo.ExportFormats(i).FileFormatString
'Next
End Sub
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 !
How Can I Export A Report, Naming The Report ...
I need help. I'm trying to export a report and naming it based on the value in a control on the report. Can I do this using VB in MS ACCESS?
Tom: Thanks for your reply.
I figured it out, The code works fine, the problem I had was that I didn't have write permissions to save the file in the network location I wanted.
Code:
DoCmd.OutputTo acOutputReport, "rpt_Whatever", acFormatSNP, "C:" & (Forms![frm_Whatever].[WhateverName]) & ".snp"
Export Report From CR9
Have been able to add photos/images on the fly in VB6 with CR9. All images show up as they are intended.
However, whenever the report is exported with a .pdf format, the first page has no images attached, but the other pages do. If exported to Word, on images are present. Then when I go back to the .pdf format, no images. Shut down and restart the program, the same results.
I populate the report using the crSection_Format:
Code:
Set crSection.ReportObjects("Classmate").FormattedPicture = _
LoadPicture(crNameTagsAdhesive.Sections("DetailSection3").ReportObjects("PicFile").Value)
Thanks for the help.
Kim
Export A Report
hi
please can anyone tell me how to export a report programmatically
i know i can do it using the report it self but i want the report tp be saved at form load without been displayed
can this be done
plz tell me the procedure
thanx
Export Report
hi.. im using datareport to generate my reports with (us std) as the paper size.. it works well when i print these reports.. but it generates an error (report width is larger than paper width) if i try to export it to another format e.g. text file(.txt).. i've already changed the properties of my default printer but it still wont work.. please help..
a friend of mine posted a similar question in the reports section of this forum but it has 0 replies.. hope somebody can help me..
VBA Export MS Access Report As .doc
Hi All,
I am using MS Access 97, and I would like to know the VBA code for exporting a MS Access report as a word document.
Thanks for the help,
Access Report Export
I have built an access database that creates dynamic reports and then sends them automatically via lotus notes. However a customer has pointed out that the letter looses the company logo during transit. I have tested it and it looks as though the image is not exported to the word file with everything else. Does any one know how I can retain the logo on the exported letter (its a image object)
Thanx in advance
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.
The Run-tim Error When Doing Report.Export
I'm doing some program using vb6+CrystalReport8.5. I placed a button named "b_save" and wrote the following code:
Private Sub b_save_Click()
Report.Export
End Sub
When I executed the code in the machine which one I programmed on, a box appeared and asked some details for exporting(saving). Well, that's what I just want to do, but now I compiled the code to a exe file and copied it another machine , it didn't work!(the exe file could also work in the machine I programmed on) When pushing the button "b_save", it appeared a error box saying "run-time error '2147190911'(80047781)".
I think there must be some dll files I didn't include or copy to another machine,but the question is I don't know which dll files I should include or copy? Could anybody help me,thanks :-)
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
Failed To Export The Report
I am using VB6 with CR8.5 and have a few users that get a "Failed to export the report" error when trying to export to some file formats. Some WinXP and Win2K users cannot export to RTF, while others have problems exporting to PDF, and others to TXT. Some get a combination of these but some of the other export formats work fine for them. Most users have no problems at all.
Below is a list of the files that I am installing. I have checked the Business Objects site and have got the latest hot fixes for CR 8.5 (Dec 2003) but still the problem crops up with a few of my users.
Code:
[Files]
; Other Drivers for Crystal Reports
Source: "SystemWin9xatl.dll"; DestDir: "{sys}"; Flags: sharedfile regserver restartreplace; MinVersion: 4.0,0; OnlyBelowVersion: 4.9,0
Source: "SystemWinNT2000atl.dll"; DestDir: "{sys}"; Flags: sharedfile regserver restartreplace; MinVersion: 0,4.0; OnlyBelowVersion: 0,5.01
Source: "Systemmsvcp60.dll"; DestDir: "{sys}"; Flags: uninsneveruninstall sharedfile
Source: "Systemmsvcirt.dll"; DestDir: "{sys}"; Flags: uninsneveruninstall sharedfile
Source: "Systemmsvcrt.dll"; DestDir: "{sys}"; Flags: uninsneveruninstall sharedfile
Source: "Systemmfc42.dll"; DestDir: "{sys}"; Flags: sharedfile regserver restartreplace
; Crystal Reports
Source: "Report Designercraxdrt.dll"; DestDir: "{pf}Seagate SoftwareSharedReport Designer Component"; Flags: restartreplace sharedfile regserver
Source: "Report Designercrviewer.dll"; DestDir: "{pf}Seagate SoftwareSharedReport Designer Component"; Flags: restartreplace sharedfile regserver
Source: "SystemP2smon.dll"; DestDir: "{sys}"; Flags: sharedfile
Source: "Systemp2bdao.dll"; DestDir: "{sys}"; Flags: sharedfile
Source: "Systemexlate32.dll"; DestDir: "{sys}"; Flags: sharedfile
Source: "ExportsU2DDISK.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "ExportsU2FHTML.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "ExportsCRXF_RTF.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "ExportsU2FTEXT.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "ExportsU2FWORDW.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "Exportscrxf_pdf.dll"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "Exportsu2fxml.dll"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "SharedExportModeller.dll"; DestDir: "{pf}Seagate SoftwareShared"; Flags: sharedfile
Source: "Sharedcrtslv.dll"; DestDir: "{pf}Seagate SoftwareShared"; Flags: sharedfile
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
Automating Report Export To *.snp
I have a report that I need to export monthly for all customers in the Business table. The report is exported in *.SNP format and must contain the individual customers specific information. My code is driving me mad. Any help would be greatly apprecisted.
Public CustomerID, Filename As Variant 'setting up necessary global variables
' Usage: PrintAllCustomers("Reportnamehere")
Public Sub PrintAllCustomers(ReportName As String)
Dim ADOCon As ADODB.Connection
Dim Rst As ADODB.Recordset
Dim Folder As String ' to hold directory information
'now lets ask directory you want to save
Folder = InputBox("Where do you want to save files?", "Destination Folder", Application.CurrentProject.Path)
'if canceled leave the sub without processing.
If Folder = "" Then Exit Sub
Set ADOCon = Application.CurrentProject.Connection 'get current connection
Set Rst = New ADODB.Recordset 'to query current customers
'open recordset and load all data we need into recordset
Rst.Open "SELECT Business.BusinessName, ImportAddresses.Name, ImportAddresses.Add1, ImportAddresses.City, ImportAddresses.State, ImportAddresses.Zip, Zips.Type, Zips.CustomerNumber FROM Business INNER JOIN (Zips INNER JOIN ImportAddresses ON Zips.ZipCode = ImportAddresses.Zip) ON Business.CustomerNumber = Zips.CustomerNumber GROUP BY Business.BusinessName, ImportAddresses.Name, ImportAddresses.Add1, ImportAddresses.City, ImportAddresses.State, ImportAddresses.Zip, Zips.Type, Zips.CustomerNumber, ImportAddresses.Type HAVING (((ImportAddresses.Type) = [Zips].[Type])) ORDER BY Business.BusinessName, ImportAddresses.Name", ADOCon, adOpenForwardOnly
Do While Not Rst.EOF 'start sending all reports to files
CustomerID = Rst!CustomerNumber 'set necessary global variables before print to file
Filename = Folder & "" & Rst!BusinessName & ".SNP" 'set folder and filename.
Rst.Filter = "CustomerNumber = " & CustomerID
'send report to file
DoCmd.OutputTo acOutputReport, ReportName, acFormatSNP, Filename, True
Rst.MoveNext 'next customer
Loop
Rst.Close
Set Rst = Nothing
End Sub
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
Export An Access Report To PDf
I know, wrong forum but someone here will know how to do this.
How do I programmatically export a MS Access 97 report to PDF?
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
How To Export MS Access Report
Hi all
I have a Microsoft Access report that i want to export to a folder on my harddisk but the problem is, each month, i would like the script to run that will export this report to a folder on my Hard dirve.
each time the report is exported, it should be saved with the user id of the recipient, this process will continue until all the recipients have reports attached to their names . there are about 300 recipients
Pleas help!!! I am new in Macro and VBA
Iyke
|
TRACKER
