Export Chart Image From Crystal For Web - Please Help

Chart Export
Does anyone know why this code might hang? It works most of the time but occasionally it just hangs the worksheet.
-----------------------------------------------------
Sheets("sheet3").Activate
Sheets("Sheet3").ChartObjects(1).Select
Sheets("Sheet3").ChartObjects(1).Activate
ActiveChart.Export fileName:=fname, filtername:="gif"

DoEvents
Worksheets("a2s").Activate

-----------------------------------------------------

It hangs on DoEvents and if I remove DoEvents it hangs on Worksheets("a2s").Activate
Does this mean that the gif file can't close?

I'm having problems debugging because most of the time it works, and if I step through the code it works. But, then other times it just doesn't

Thanks

---

Export Chart As GIF
I'm having an problem that pops up every once in a while and I can't seem to find out what's happening. Essentially I'm plotting 3 charts to a
worksheet Sheet3 and as each is created I export and save it as a gif file.

Sometimes, I see a "Exporting" message flash on the screen but the program doesn't complete the export. It just keeps flashing "Export"

Can this be a memory problem? How can I see how much memory is available before I attempt the export.

Here's my code. Any help would be appreciated.

For i = 1 To 3
Select Case i
Case Is = 1
which = 1
Case Is = 2
which = 2
Case Is = 3
which = 3
End Select

Call PlotAChart(ChrtString(i, 2), which, ChrtString(i, 1), NCount)
fname = Worksheets("sheet3").ChartObjects(which).Name

fname = ThisWorkbook.Path & Application.PathSeparator & fname & ".gif"
Sheets("sheet3").Activate
Sheets("sheet3").ChartObjects(which).Select
Sheets("sheet3").ChartObjects(which).Activate
With ActiveChart
.Export fileName:=fname, filtername:="gif"
End With


Next i

---

What Formats Can I Export A Chart
i'm exporting a chart from excel using VB using this code:
ActiveChart.Export Filename:="No Title.tif", FilterName:="TIF"

but what other file types can i use other than .tif?

---

Export A Chart Whose File Might Be Locked
Every 60 seconds my VBA code writes an HTML file and exports three charts to the webspace of Apache 2.0.48 webserver. Occasionally it will err out at the statement that writes one of the charts. I can debug into it and resume normal operation from that statement.

Could this be a locked file conflict? I'm guessing that the VBA error occurs when the file cannot be replaced with a fresh one. Only the webserver accesses these files and should only read them, but maybe it locks them briefly for some reason. This only errs exporting the charts, never when writing the HTML page.

Or is it possible that the filename, calculated in a cell, may have not settled before the VBA fetches it?

Here are some code snippets:


Code:
Public Sub MakeHTML()
On Error GoTo Local_Err
'
'snip-------
'
chartMo.Chart.Export chartPathMo, Sheets("Procedure").Range("ChartType")
chart31.Chart.Export chartPath31, Sheets("Procedure").Range("ChartType")
'
'snip-----------
'
Local_Err:
On Error Resume Next
Application.OnTime nextTic, "MakeHTML", , False
bPerformUpdates = False
Application.StatusBar = "Error, Polling stopped: " & Now()
MsgBox "MakeHTML " & VBA.Err & " " & VBA.Err.Description
Resume Local_Exit
Resume
End Sub

It would not be a problem if the export is unsuccessful in these instances (only a few times weekly), but its a big problem when the program stops on error. Is there some way I could amend the error handler to acknowledge this particular error and keep running?

Is there a way I can identify the specific error? As reported (Error 1004) I can't tell specifically what the problem is.

Pete

---

VBA In Excel - Chart.Export Question
Firstly, Let me say how much I have enjoyed this forum for its insightful revelations into VBA.

My current question revolves around using VBA in Excel, e.g.:

Chart.Export FileName:="current_sales.gif", FilterName:="GIF"

Specifically, I am interested (and presently confused) as to the "FilterName" parameter. I have found very little elaboration on its usage (MS Help files make reference to it being defined "in the registry" and little more). I have experimented and found I can use "GIF" or "JPG" successfully; however "BMP" or "WMF" generate errors when used. It would seem to have little reflection upon which graphics filters I have installed (I have the MS addon pack for Excel).

Does anyone know a method to determine what filters are available for usage in this context?

Many thanks, if so!

w00fer

---

Error When I Export A Chart From Access?
I'm using, access 2k with a win2k machine sp4

I'm using "Me.objGraph.Export "Location", "GIF", False"
in a report. Every time I try to close the report I get the following error....

The Operation on the Chart object failed.

The OLE server may not be registered.

To Register the OLE server, reinstall it.

Does anyone have any idea?

---

Export Excel Chart To Wmf Format
there is method in excel VBA : chart.export to export chart in worksheet to GIF, JPG or BMP (bitmap format), is it possible to export to wmf format (vector format) (or is there any way to export excel chart to wmf programatically ) ?

thanks in advance

rd

---

Export Image
How to export an image from ImageList ?

---

Export Text To BMP Image.
Hi guys

I'm new in picture processing in VB so if anyone here can point me to some function to export my text into 720x480 (4bit) bmp image file which I can define my font/size/color/border will be alot appreciated

Or tell me how can I process a picture from VBA (VB for excel) to a picture.

Thanks alot.
Seyed Mohammad

---

Export An Image To Excel
Hi everyone,

Please, can anyone tell me how do I do to export an imagen to excel, for
example my enterprise's logo.

Thanks

---

Export An Image To Excel -
I am trying to export some data to an Excel spreadsheet which is working fine, but I need to export our company logo on it as well. How do I do this I cna't find it anywhere.

The graphic is held in the projects "Resources" called "TSSR-logo.png"


Code:
        Try
            Dim oXL As Excel.Application
            Dim oWB As Excel.Workbook
            Dim oSheet As Excel.Worksheet
            Dim oRng As Excel.Range


            ' Start Excel and get Application object.
            oXL = CreateObject("Excel.Application")
            oXL.Visible = True

            ' Get a new workbook.
            oWB = oXL.Workbooks.Add
            oSheet = oWB.ActiveSheet

            Catch ex As Exception
                Console.Write(ex.Message)
            Finally
                conn.Close()
            End Try


Any advice would be greatly appreciated.

Rob




Edited by - TSSR_Rob on 2/28/2008 9:18:25 AM

---

Crystal Export!
Pls help!
When I using the tool export of Crystal report (click the icon export on Crystal's toollbar when viewing report) an error appears:"code invalid base false in module u2frtf.dll". How can I correct this problem?
Pls show me! Thanks!

---

VB6 Crystal 8 - Export To PDF
Hi all,
This question seems to have been asked several times in various forums and asnwers are quite ok. However, I have a small problem.

I am using VB6, CR8 and need to export the report programatically to PDF. I am unable to get PDFExportAllPages property on myReport.ExportOptions.

myReport.ExportOptions.PDFExportAllPages = True 'This does not work

I have the Crystal ActiveX runtime Library switched on.
I have Adoble working fine on my machione and able to make PDF file using the printer as well.

Anything missing else missing. Appreciate a helping hand.

Nissar

---

EXPORT TO CRYSTAL
Hi,

we have more than 20 reports to be exported to crystal XI.

I have seen in crytal reports version 7.0.
there are properties of RDC for exporting to crystal report format such as

with rdccrystal
.destination=crpttoFile
.printfilename=destinationfile
.printFileType=crptCrystal
.action=1

I have searched through documentation, I could n't find any equivalent to above properties in Crystal report XI i.e. (Active X designer Run time Library)

I would appreciate your assistance in this regard.


thanks

---

Crystal Export
Hello gurus,
I have a crystal report. The size of the report is A3. If I export this to text file the whole alignment is changed. Any way to avoid this.

Thanks
Shivakumar G.M.

---

Export Word Doc To Image File
I'm looking for methology, or code, which will allow me to save a Word doc as an image file via vba. I'm currently doing this with Excel charts and ranges, but can't get to first base in word.

Has anyone got any suggestions please.

---

NEED Experts! Export Image From Word
Hi alll,
i search now for weeks for a solution for my problem:
the export of a picture as bmp in word with vba
(access2002)!

The tool i started with is,

http://www.lebans.com/msword.htm

it's nearly what i need if all would work how it should,
the problem, something goes wrong with the
" horizontal or vertical dissolution "

I think the two decisive methods are(do not frighten a lot of code =)):


VB Code:
Public Function EMFToDIB() As Boolean     ' Play the Metafile into the DIBSection     Dim blRet As Boolean     Dim hDCtemp As Long     ' Instance of EMF Header structure     Dim mh As ENHMETAHEADER     ' Current Screen Resolution     Dim lngXdpi As Long     ' Used to convert Metafile dimensions to pixels     Dim sngConvertX As Single     Dim sngConvertY As Single     ' Pels per meter for Bitmapinfo     ' Some apps will read thsi value to determine DPI for     ' display purposes     Dim PelsX As Long, PelsY As Long     ' Image dimensions     Dim Width As Long, Height As Long     Dim hDCref As Long     Dim rc As RECT      ' Create a temp Device Context     hDCtemp = CreateCompatibleDC(0)     ' Get Enhanced Metafile Header     lngRet = GetEnhMetaFileHeader(m_hEMF, Len(mh), mh)     With mh.rclFrame         ' The rclFrame member Specifies the dimensions,         ' in .01 millimeter units, of a rectangle that surrounds         ' the picture stored in the metafile.         ' I'll show this as seperate steps to aid in understanding         ' the conversion process.         ' Convert to MM         sngConvertX = (.Right - .Left) * 0.01         sngConvertY = (.Bottom - .Top) * 0.01     End With     ' Convert to CM     sngConvertX = sngConvertX * 0.1     sngConvertY = sngConvertY * 0.1     ' Convert to Inches     sngConvertX = sngConvertX / 2.54     sngConvertY = sngConvertY / 2.54     ' DC for the enumeration of the EMF records     'It must be GetDC not CreateCompatibleDC!!!     hDCref = apiGetDC(0)     ' See if we can get the original Image dimensions     ' From an EMRSTRETCHDIBITS metafile record which     ' will exist for any Images that were     ' originally Bitmap based.(BMP, Jpeg, Tiff etc.)     blRet = EnumEMFGetDimension(m_hEMF, hDCref, Width, Height)     ' Always release the DC as soon as possible     lngRet = apiReleaseDC(0, hDCref)     ' Again if Width = 0 then we are dealing with a plain Metafile     ' not a DIB wrapped within a Metafile.     ' Get the Dimensions from the Metafile Header.     If Width = 0 Then         ' Get the Image dimensions directly from the EMH Header         Width = mh.rclBounds.Right         Height = mh.rclBounds.Bottom     End If     ' Next we need to check and see which dimension values are     ' larger, the EnumEMFGetDimension values or the EMF Header values.     ' Use Whichever values are larger. This logic will cover the     ' case where we have an origina EMF Image but it happens to     ' contain one or more calls to the EMRSTRETCHDIBITS record. '    If mh.rclBounds.right > Width Then '        Width = mh.rclBounds.Right '        Height = mh.rclBounds.Bottom '    End If     ' The vars sngConvertX and  sngConvertY contain the     ' dimensions of the Image in inches.     ' We need to convert this to Pixels Per METER.     ' First convert to Inches     PelsX = Width / sngConvertX     PelsY = Height / sngConvertY     ' A problem here is that we are too accurate compared to     ' the rounding used by Word and Explorer. For instance we might     ' arrive at a value of 302 DPI when Word originally loaded the     ' Image it was only 300 DPI.     ' Let's round to the nearest 100th value.     ' If the value is under 120 then leave it alone     If PelsX > 120 Then         PelsX = PelsX + 5         PelsY = PelsY + 5         PelsX = PelsX 10         PelsY = PelsY 10         PelsX = PelsX * 10         PelsY = PelsY * 10     End If     ' Now convert Inches to Meters     PelsX = PelsX * 39.37     PelsY = PelsY * 39.37     'PelsX = PelsX * 8.24     'PelsY = PelsY * 8.24     'PelsX = 96     'PelsY = 96     ' Now create our DIBSECTION     Create Width, Height, PelsX, PelsY     '"PLAY" the Enhanced Metafile     ' back into the Device Context containing the DIBSection     rc.Top = 0     rc.Left = 0     rc.Bottom = m_bmi.bmiHeader.biHeight     rc.Right = m_bmi.bmiHeader.biWidth     lngRet = apiPlayEnhMetaFile(m_hDC, m_hEMF, rc)     ' Success     EMFToDIB = True End Function


and:


VB Code:
Public Function SaveEMF(strFname As String)     Dim lngRet As Long     Dim blRet As Long     Dim lLength As Long     Dim Width As Long     Dim Height As Long     Dim hDCEMF As Long     Dim hDCref As Long     Dim rc As RECT     ' local storage for out copy of the EMF Header     Dim mh As ENHMETAHEADER     ' Vars to calculate resolution     Dim sngConvertX As Single     Dim sngConvertY As Single     Dim ImageWidth As Single     Dim ImageHeight As Single     Dim Xdpi As Single     Dim Ydpi As Single     Dim TwipsPerPixelX As Single     Dim TwipsPerPixelY As Single     Dim sngHORZRES As Single     Dim sngVERTRES As Single     Dim sngHORZSIZE As Single     Dim sngVERTSIZE As Single      ' To create our EMF     'It must be GetDC not CreateCompatibleDC!!!     hDCref = apiGetDC(0)     ' See if we can get the original Image dimensions     ' From an EMRSTRETCHDIBITS metafile record which     ' will exist for any Images that were     ' originally Bitmap based.(BMP, Jpeg, Tiff etc.)     blRet = EnumEMFGetDimension(m_hEMF, hDCref, Width, Height)     ' Again if Width = 0 then we are dealing with a plain Metafile     ' not a DIB wrapped within a Metafile.     ' Get the Dimensions from the Metafile Header.     If Width = 0 Then         ' Get Enhanced Metafile Header         lngRet = GetEnhMetaFileHeader(m_hEMF, Len(mh), mh)         ' It is a plain Metafile we are dealing with         ' not a DIB wrapped in a Metafile.         ' Get the Dimensions from the Metafile Header         Width = mh.rclBounds.Right         Height = mh.rclBounds.Bottom     End If     ' Next we need to check and see which dimension values are     ' larger, the EnumEMFGetDimension values or the EMF Header values.     ' Use Whichever values are larger. This logic will cover the     ' case where we have an origina EMF Image but it happens to     ' contain one or more calls to the EMRSTRETCHDIBITS record.     If mh.rclBounds.Right > Width Then         Width = mh.rclBounds.Right         Height = mh.rclBounds.Bottom     End If     ' Setup     ' April 19-2004rc.right = Width     'rc.Bottom = Height     ImageWidth = Width     ImageHeight = Height     ' Calculate the current Screen resolution.     ' I used to simply use GetDeviceCaps and     ' LOGPIXELSY/LOGPIXELSX. Unfortunately this does not yield accurate results     ' with Metafiles.  LOGPIXELSY will return the value of 96dpi or 120dpi     ' depending on the current Windows setting for Small Fonts or Large Fonts.     ' Thanks to Feng Yuan's book "Windows Graphics Programming" for     ' explaining the correct method to ascertain screen resolution.     ' Let's grab the current size and resolution of our Screen DC.     sngHORZRES = apiGetDeviceCaps(hDCref, HORZRES)     sngVERTRES = apiGetDeviceCaps(hDCref, VERTRES)     sngHORZSIZE = apiGetDeviceCaps(hDCref, HORZSIZE)     sngVERTSIZE = apiGetDeviceCaps(hDCref, VERTSIZE)     ' Convert millimeters to inches     sngConvertX = (sngHORZSIZE * 0.1) / 2.54     sngConvertY = (sngVERTSIZE * 0.1) / 2.54     ' Convert to DPI     sngConvertX = sngHORZRES / sngConvertX     sngConvertY = sngVERTRES / sngConvertY     Xdpi = sngConvertX     Ydpi = sngConvertY     ' Calculate TwipsPerPixel     TwipsPerPixelX = TWIPSPERINCH / Xdpi     TwipsPerPixelY = TWIPSPERINCH / Ydpi     ' Convert pixels to TWIPS     ImageWidth = ImageWidth * TwipsPerPixelX     ImageHeight = ImageHeight * TwipsPerPixelY     ' Convert TWIPS to Inches     ImageWidth = ImageWidth / 1440     ImageHeight = ImageHeight / 1440     ' Convert Inches to .01 mm     ImageWidth = (ImageWidth * 2.54) * 1000     ImageHeight = (ImageHeight * 2.54) * 1000     ' Ready to call the Create Metafile API     rc.Bottom = ImageHeight     rc.Right = ImageWidth     rc.Left = 0     rc.Top = 0     ' Create the Metafile     hDCEMF = apiCreateEnhMetaFileRECT(hDCref, strFname, rc, vbNullString)     If hDCEMF = 0 Then         MsgBox "Could not create Metafile", vbCritical         lngRet = apiReleaseDC(0, hDCref)         Exit Function     End If     ' Now play the Memory Metafile into our Disk based Metafile     rc.Bottom = Height     rc.Right = Width     lngRet = apiPlayEnhMetaFile(hDCEMF, m_hEMF, rc)     ' Now close the file based EMF     lngRet = apiCloseEnhMetaFile(hDCEMF)     ' Delete it(not really...it merely releases the ref to it completely.     lngRet = apiDeleteEnhMetaFile(lngRet)     ' Always release what you get     lngRet = apiReleaseDC(0, hDCref) End Function


first it seems everything working however if I try with the method " ConvertBMPtoJPG " (ImageUtils.dll)
to convert the bmp the colours of the converted picture are wrong... i think the reason are the "dpi"
(wrong export from the "WORD-Tool" but where?)

I work with Access 2002 (VBA) makes the thing a little more difficulty!

still as further tip: if I load the exported picture(bmp from Word) into a picture processing program(MS Paint) and save it again as bmp the dpi changes and the picture can be correctly converted with " ConvertBMPtoJPG "!

Im working on a larger project and dont know how to continue would be great if one of u experts can give me a tip!!

greeting Seinfeld=)

---

LaserFiche, Toolkit 5, Export Image
What's up?

I'm using LaserFiche's Toolkit version 5 and I have a .JPG file that is imported into a new document. However, when I want to export the same image, but rename it with a different name, the .JPG file comes up to be a blank. Here is my code:


VB Code:
strReturn1 = LFAPI.ExportImage("testerwork" + strPerson1, 1, "C:AXB00001.JPG")


What's very strange is: It's the same file, just a new name, and VB won't accept it as a "valid file" when it's loaded into either an imagebox or a picture box. Even more strange: if you open up this image with Photoshop 6 or 7 it works, but not with internet explorer, VB, or anything else.

Another weird thing: Instead of using VB to program LaserFiche to export the image, I went into the client software and manually exported the image going to the menu File > export > image.

That works perfectly fine, just not when VB commands it to export an image.

Any pointers?


Thanks

Chris

---

Why Can't I Export My Picture1.image To A File?
code:

Option Explicit

Private Sub Form_Click()
' Declare variables.
Dim CX, CY, Limit, Radius As Integer, Msg As String
ScaleMode = vbPixels ' Set scale to pixels.
AutoRedraw = True ' Turn on AutoRedraw.
Width = Height ' Change width to match height.
CX = ScaleWidth / 2 ' Set X position.
CY = ScaleHeight / 2 ' Set Y position.
Limit = CX ' Limit size of circles.
For Radius = 0 To Limit ' Set radius.
Picture1.Circle (CX, CY), Radius, _
RGB(Rnd * 255, Rnd * 255, Rnd * 255)
DoEvents ' Yield for other processing.
Next Radius
Msg = "Choose OK to save the graphics from this form "
Msg = Msg & "to a bitmap file."
MsgBox Msg
SavePicture Picture1.Image, _
"TEST.BMP" ' Save picture to file.
End Sub

This works for good if the circles are assigned to the picture prop of the form, however when assigned to the image of the picture test.bmp returns empty. Why and how does that happen?

---

Crystal Reports Export
Using CR 9
I want to add a button to export the report to excel. I know hoe to do this but how do you export the data only format. Right noe it exports the report as it is in excell with all the headers and footers.

Urgent Help needed!

---

Crystal Reports 8.0 Export To Pdf
Crystal Reports 8.0 is not saving formatted
data correctly to a .pdf disk file correctly
from the report viewer. I have a VB6
application that retrieves data from a SQL
database then puts in a report. From the
report viewer I chose to export to disk in
pdf format. The file is created but the data
retrieved from the database is not in the
report. I checked the machine the I
installed to for all of the correct Crystal
dlls and all looks well. If anyone else can
give me any other assistance It would be
greatly appreciated...!

---

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

---

Help With Crystal Rpt Export To HTML Please
Please help me with the code that will run a Business Objects (XI) Crystal Report and Export it to an HTML 4.0 file.

Using VB 6, have a form with the Crystal XI Viewer control on it.
Name of report is myfile.rpt.
Need to export it to HTML ver 4.0 to c: estmy.htm

Can someone show me how to do this?

---

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!

---

Crystal Export Button
Hi all!

I am lacking the technical terms but it goes like this.

I am viewing a report in the form of the report viewer, after i move my mouse in a certain place(record) in the report and double click it, a new tab in the report is shown, i go to it and then i try to click the export buttton but for my surprise its not enabled! If i go to the 'Main' tab it goes enabled again and if i go to the tab i 'created' if disables again!

Why does this happen and how can i go around this?

I apreciate your help! Thanks!

---

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!

---

Crystal Reports Export
I have a vb application which displays a crystal report(8.5). When a user clicks on the export report button, crystal prompts the user to choose a format and a destination. Is there a way to take items off the format list? Also is there a way to set the default directory that it exports to without prompting the user?

Thanks,
AndyL

---

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

---

Crystal Reports 7 Export
I am using Crystal Reports 7 with VB 6 to generate reports on Access database tables. When I preview the report on the screen and then try to use the export button, nothing happens. The button did work when I was using a package and deployment from VB but stopped working when I started using the Install Shield installer. I have gone back in and tried to load all of the dependencies of Crystal, but it still does not work. Does anyone know the dll or ocx file needed? I have the format and destination dlls loaded.

---

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

---

Export In Crystal Reports
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

---

Export To Excel With Crystal?
Does anyone know how to get Crystal to create an export file, without first previewing the report on the screen with the Crystal Report Viewer? I need to create multiple excel worksheets from a database, and can't figure out how to get the view to do the export programmatically. Any suggestions would be greatly appreciated.

---

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 Crystal Reports
I have created a report using Crystal Reports 8.5 and executed the report using VB. I want to export the output to other format for which i believe crystal reports provide the facility. But in my case i could able to see the export button when i am at design time, i mean when i see the report using crystal reports User Interface, but when i run it through VB i don't find that button to export. Do i have to enable some thing for that??

I use CRViewer control to view the report.

Thanx in advance.

---

Saving A Chart As An Image
I have the MSChart control plotting data. I want the user to be able to save the chart as an image. How would I accomplish this?

---

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.

---