Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Location
    Port Talbot, Wales
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Seagate Crystal Reports (Seagate Crystal Reports 8)

    Not sure if this post should be in this forum but does anyone know how easy/hard it is to write VBA code to use Seagate Crystal Reports. We currently use Microsoft Query to pull data from our main database, this works fine but the powers that be in our IT department want to give us Seagate Crystal Reports and take away Microsoft Query. This is a bit of a pain in the butt as all my code will have to be re-written to use Seagate Crystal Reports instead of MS Query. I havn't even looked at Crystal Reports yet and ain't got a clue how to use it. Any comments would be greatfully received.

    Thanks
    Jambo

  2. #2
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Suffolk, England
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Seagate Crystal Reports (Seagate Crystal Reports 8)

    In my rather limited experience, it is very easy to use Crystal within VB :
    Install Crystal Report ActiveX Designer Run Time Library - from Project, references
    in the declarations section type:
    Private CrystalApp As CRAXDRT.Application
    Private Report As CRAXDRT.Report

    Private Sub Form_Load()
    Set CrystalApp = New CRAXDRT.Application
    End Sub

    Install Project Components - Crystal Report Viewer
    and put one on the form - in the example below it's called crMain
    Then you need a command Button:

    Private Sub CmdButton_Click()
    Set Report = CrystalApp.OpenReport("C:MyReport.rpt")
    crMain.ReportSource = Report
    crMain.ViewReport
    End Sub
    and that's it
    Allison

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Seagate Crystal Reports (Seagate Crystal Reports 8)

    FWIW, Crystal should come with a native file Viewer called Crystal Info, which will convert Crystal ".rpt" Files to:

    CSV file
    Tab SV file
    Other Delimiter SV file
    DIF file
    Excel File formats versions 2 through 8, the only capability I have tried, and does a nasty ugly job
    HTML 3.n
    Lotus 1.2.3 through WK1, WK2 and WKS formats
    Multiple ODBC intermediate format
    A few structured plaintext formats
    RTF
    Word For Windows (version not stated)
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Star Lounger
    Join Date
    Nov 2002
    Location
    Port Talbot, Wales
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Seagate Crystal Reports (Seagate Crystal Reports 8)

    I think we might have a cut down version or something, can't find that info thngy anywhere!

    Jambo

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Seagate Crystal Reports (Seagate Crystal Reports 8)

    <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> Sorry, perhaps it would help if I provide the correct name: Seagate Info.

    The executable name I have on my PC for version 7.02.200 is "cvw32.exe". The Help File refers me to www.seagatesoftware.com, but that site redirects to Seagate Info, which doesn't show anything like I'm trying to tell you about. So now I've told you more than I know! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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