Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    3

    Unanswered: passing SQL to reports

    I am new to vb-crystal reports. I completed database application in VB, now want to generate reports. I create a form with various options, and after selecting it wrote SQL also reference to them.

    Now I want to create crystal report with same SQL. I tried for

    Project -> Activex -> crystal reports with standard expert but it sticks with one table only.

    So, how can I pass SQL to report and refresh or regenerate it?

    Thanks.

    Tutu

  2. #2
    Join Date
    Nov 2004
    Posts
    30
    With CrystalReport1
    .Reset
    .Connect = "DSN = " & m_UDTConnect.strDSN & ";UID = " & Trim$(Userid) & ";PWD = " & Trim$(password) & ";DSQ = " & Trim$(strInitialDB)
    .ReportFileName = reportfilepath with name
    .SqlQuery = you sql statement
    .StoredProcParam(0) = ' If you r using stored Procudures with parametrs
    .WindowTitle = title
    .Formulas(0) = ' If you r using formula in crystal repo
    .DiscardSavedData = True
    .WindowState = crptMaximized
    .Action = 1
    End With
    Last edited by sudheesh_k_s; 12-15-04 at 08:02.

Posting Permissions

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