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

    Question Unanswered: passing runtime SQL to crystal report

    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
    Oct 2003
    Posts
    357
    Hi,
    In the VB Application try this.
    Code:
    CR.DiscardSavedData=True
    CR.Referesh
    CR.SQLQuery='Your query'
    CR.View
    This is for CR8

    Madhivanan

Posting Permissions

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