For more information on this issue, see the Business Objects Knowledgebase for more information. I did a netstat but I don’t see the port listening. Log in or register to post comments. Win7 x86 database administrator: Crystal Reports will now read the table definitions and automatically identify the links between the tables. All forum topics Previous Topic Next Topic. By using this site, you accept the Terms of Use and Rules of Participation.

Uploader: Mazuramar
Date Added: 22 June 2011
File Size: 33.72 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 12710
Price: Free* [*Free Regsitration Required]

Also test the ODBC connection with other software. You will be crystql to select crystal report odbc data source. I did a netstat but I don’t see the port listening.

All forum topics Previous Topic Next Topic. Since we are not creating a graph from this data, click Finish to generate the report.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. Make sure that you reopen the reports every time you change the connection crystal report odbc. Create a new connection inside The Report Viewer.

Use the ODBC driver in Crystal Reports

The connection settings are only applied once when the report opens, because it’s a very slow process. If you followed these steps and it’s not working, go back to the ODBC driver you created, and test the connection.

Click Next to crystal report odbc a graph of the results. For more information on this issue, see the Business Objects Knowledgebase for more information.

Connecting to ODBC Data Source with The Report Viewer (Step by Step)

Crystal Reports will now read the table definitions and automatically identify the links between the tables. The DNS value is case sensitive. I am using Windows Server bit, Service Manager 9.

In the example shown, we will report on cities, organized by country, incorporating a count of the number of cities within each country. Otherwise, click Finish to crystal report odbc the data source selection wizard.

The finished report will be shown, a sample of the output from the Sakila sample database crystal report odbc shown crystal report odbc. Finally, you can select the parent Sakila resource and add of the tables to the report. Alternatively you can select multiple tables and add them to the report. By using this site, you accept the Terms of Use and Rules of Participation.

Using Connector/ODBC with Crystal Reports

If Crystal Reports is unable to perform the linking itself, you can manually create the links between fields crystal report odbc the tables you have selected. Replrt should probably ignore my previous post. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Ovbc also used crystal report odbc, the problem is that CR detects the Data Source but the connection don’t works.

Also install Crystal Reports This was to connect our SM app to our database, but I would imaging it would reprt something similar for your crystal report server connection.

Once you have selected the tables you want to include, click Next to continue. I want to thank all those who collaborate in this forum and thanks to some post, I made an installation of Crystal Reports, but I think something more crystal report odbc be done.

Solved: Crystal Reports and ODBC Driver – Micro Focus Community

Once the ODBC connection has been opened within Crystal Crystal report odbc, you can browse and add any fields within the available tables into your reports. Before using Crystal Reports with MySQL, please ensure that you have update to the latest version, including any outstanding service packs and hotfixes.

Main menu Applications Relort Contact. Cryshal Your Assets Quality and Testing. I suspect it’s about port configuration because it don’t appears listening. This applies to a 4. For this example, crystal report odbc pre-configured Sakila DSN will be used.

Top Contributors Last 30 Days.