Results 1 to 3 of 3

Thread: [RESOLVED] server has not yet been opened

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Resolved [RESOLVED] server has not yet been opened

    i have the following code
    Code:
    Set Report = crxApp.OpenReport(App.Path & "\Reports\CSP1.rpt", 1)
            With Report
            .ExportOptions.FormatType = crEFTPortableDocFormat
            .ExportOptions.DestinationType = crEDTDiskFile
            .ExportOptions.DiskFileName = App.Path & "\Reports\CSP1.PDF"
            .ExportOptions.PDFExportAllPages = True
            .Export (False)
            End With
    but it showing server has not yet been opened" on .Export (False) line


    any help would be appreciated

  2. #2

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Angry Re: server has not yet been opened

    my crystal report asking user name and password everytime when am refreshing and creating pdf directly from the report. I think the user name and password is the problem here. Am opening the same report in VB6 by passing password and username but i dont know how to pass it for pdf creation...


    please help

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Thumbs up Re: server has not yet been opened

    Report.Database.LogOnServer "p2sodbc.dll", "dsn", "", "user", "pwd"

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