Connect to dataBase at run time from Vb

[TarunAgarwal]

Hi,

I am working with the Crystal Reports for first time. I want to know that how do I generate crystal reports using Vb and Access Database?

I want to provide the database path at the run time. That is the *.rpt file should have a configurable database connection.

Also, how do I fire queries from the Vb?

Please provide a sample code, if possible.

Regards,
Tarun

 

[kenhamady]

Provide your VB integration method ( faq149-237 )

Also, what type of query are you talking about, an MS Access query? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[TarunAgarwal]

Thanks Ken,

I am using Vb6 and Crystal Reports 8. I am using a connection object to create connection to the Access Database.
Now I am able to connect to Access Database and fire Ms Access Queries. The problem now is that I am using a sub report within my report and I am not able to load Data to this sub report using CDO. I am able to achieve this in the main report, but not in the sub report.

Regards,
Tarun

 

[MikeTom]

stCriteria = "Your criteria" Eg "{Table.Name} = Textbox"
SummaryReport.ReportFileName = "X:\Path\report.rpt"
SummaryReport.LogonInfo(0) = DBCONNECT
SummaryReport.SubreportToChange = "SubreportName"
SummaryReport.LogonInfo(0) = DBCONNECT
SummaryReport.SubreportToChange = "" 'Changes back to main report
SummaryReport.LogonInfo(0) = DBCONNECT
SummaryReport.SelectionFormula = stCriteria
SummaryReport.PrintReport

DBConnect is your connection string an is of the format
"DSN=;UID=;PWD=;DSQ="