Crystal Report 2011 and ODBC DataSource

[Former Member]

Hi

We use Crystal Report 2011 with Visual Studio 2010. How can we set the Report Data Source, while opening the report? The Data Source is a ODBC Connection to a MS Access Database.

Thx a lot.

[former_member188030 · Accepted solution]

Crystal Report 2011 does not install / have any .NET SDK. You would need CR for VS Sp10, install the EXE on top of VS 2010.

Develop a sample app using CR 13 assemblies. You could use the CR 2011 Designer to design your reports.

Refer to below sample applications, specifically the

• csharp_web_simplelogonengine.zip

http://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports+for+.NET+SDK+Samples

For an ODBC connection the logon code is almost the same just with a simple change.

Set the ServerName to your DSN and kkep the DBname empty.

- Bhushan

Senior Engineer

SAP Active Global Support

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Getting started and moving ahead with Crystal Reports .NET applications.

[Former Member · Accepted solution]

Hi Bhushan

Thanks a lot, this works perfect. We used the ConnectionInfo Property and it is importent to set Servername like this, if there's no db defined on the odbc link:

„ODBC;DSN=ODBC Access Link Name;DBQ=PathToDB;UID=user;PWD=password“

Regards,

Sandro

[former_member188030 · Accepted solution]

Happy to Help

-Bhushan