Crystal Reports 10 Viewers

I have a report (Crystal Reports 10) that connects to an Access database. The Access database uses a pass-through query to retrieve data. The .rpt file and the Access database will both be stored in the same directory.

What kind of viewer will my end-users need? Where can I get it?

ThanksCan anyone give some feedback on this? I still haven't found a solution...

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

crystal report and oracle?

I have a little VB.net web application which connects to Oracle using ADO.NET so i make connection

Dim Oraclecon As OleDbConnection = New OleDbConnection("Provider=MSDAORA.1;Data Source=name;Password=pass;User ID=name;")

and all work good till i try to use crystal report. it generate exception(it happens when i do report.export) "CrystalDecisions.CrystalReports.Engine.LogOnException: logon failed".
in msdn i found article "Accessing Secure Databases" with such a code

' Declare require variables.
Dim logOnInfo As New TableLogOnInfo()
Dim i As Integer

' Loop through every table in the report.
For i = 0 To report.Database.Tables.Count - 1
' Set the connection information for current table.
logOnInfo.ConnectionInfo.ServerName = serverNameTxt.Text
logOnInfo.ConnectionInfo.DatabaseName = dbNameTxt.Text
logOnInfo.ConnectionInfo.UserID = userNameTxt.Text
logOnInfo.ConnectionInfo.Password = passwordTxt.Text
report.Database.Tables.Item(i).ApplyLogOnInfo(logOnInfo)
Next i

i suppose servername parameter should be equal Data Source in connection string and DatabaseName should be empty but it still don't work. and frankly speaking i don't understand why crystal report should know logon information if i use in my report ado.net dataset as data source and make connection to oracle through ado.net technology. why should i logon twice?? so if someone had such problems please help any advice will be usefulHi,

Maybe this can help you because I also use Oracle under SCO UNIX and works for me.

1. You need to have a CrystalReport control in your form.
2. Assign to that control a name (myControl, v.g.).
3. Declare two strings variables (strSQL and strCon, v.g.).
4. Make your SQL sentence for criteria that will be throw to Crystal Reports.
Example:

strSQL = "{mytable.cycle} = 2004"

This line will added to the SQL sentence formed by Crystal Reports when you make your report. Note: this can be optional.


5. Connection for Crystal Reports. This example applies to Oracle where server is a service name made with Easy Configuration of your Oracle Client software.
strCon = "DSN =server;UID=user;PWD=password;"

User: user of Oracle
Password: which is necessary to connect to Oracle

6. Finally, properties to connect to Crystal Reports and view your report.


myControl.ReportFileName = app.path & "\Test.rpt"
myControl.Connect = strCon
myControl.SelectionFormula = strSQL
myControl.Action = 1

I hope this can serve you.

Xernai.