Results 1 to 2 of 2

Thread: Help please Exporting Crystal to HTML

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    15

    Help please Exporting Crystal to HTML

    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:\test\my.htm

    Can someone show me how to do this?

  2. #2
    Junior Member
    Join Date
    Nov 2004
    Location
    Laredo, TX.
    Posts
    29

    Re: Help please Exporting Crystal to HTML

    Hope this helps a bit:

    VB Code:
    1. Private Sub genera_htm()
    2.        Screen.MousePointer = vbHourglass
    3.        CrystalReport1.ReportFileName = "f:\bodega\reportes\revisionhtm.rpt"
    4.        CrystalReport1.SelectionFormula = "{revision_general.referencia} ='" & FormMain.Text1.Text & "'" & " and {revision_general.factura} = '" & FormMain.Text2.Text & "'" & " and {detalle.referencia} = '" & FormMain.Text1.Text & "'" & " and {detalle.factura} = '" & FormMain.Text2.Text & "'"
    5.        CrystalReport1.Destination = crptToFile
    6.        CrystalReport1.PrintFileName = "c:\bodega\revision.htm"
    7.        CrystalReport1.PrintFileType = crptHTML32Std
    8.        CrystalReport1.PrintReport
    9.        Screen.MousePointer = vbNormal
    10. End Sub
    VB6 / SQL Server Express 2005.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width