Create a new connection inside The Report Viewer. The DNS value is case sensitive. Also test the ODBC connection with other software. Twitter Documents Forum Blog Login. Click Next to create a graph of the results. If you followed these steps and it’s not working, go back to the ODBC driver you created, and test the connection.

Uploader: Barg
Date Added: 13 June 2007
File Size: 20.22 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 54130
Price: Free* [*Free Regsitration Required]

You can either specify a complete database, including user name and password, or you can build a basic DSN and use Crystal Reports to set the crystal report odbc name and password.

Select the connection you just saved in the connections drop down box. There is a known issue with certain versions of Crystal Reports where the application is unable to open and browse tables and fields crystal report odbc an ODBC connection.

Log in or register to post comments. Crystal report odbc 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 to be done. I shared crystak technical memory in spanish. Foro – Memoria Tecnica Crystal Reports. For our example, we will expand the selected Sakila database. Crystal report odbc, click Finish to continue the data source selection wizard. Create a new connection inside The Report Viewer.


Protect Your Assets Quality and Testing. The opinions expressed above are the personal opinions of the authors, not of Micro Focus. Add a nickname for this connection, and add the username and password.

Solved: Crystal Reports and ODBC Driver – Micro Focus Community

This applies to a 4. The error persisted and the log displayed that the user was not in the Active Directory, so I had to add the parameters of crystal report odbc LDAP integration in the sc. Main menu Applications Buy Contact. You should probably ignore my previous post.

Odbf I want to make the database connection from CR, it displays the message ” Connection is not possibleDetails: Also install Crystal Reports Crystal Reports will crystal report odbc read the table definitions and automatically identify the links between the tables. I am using Windows Server bit, Service Manager 9.

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

Check the report, and see what DSN it references. Demo data issue in SM Kelalek2 on: Win7 x86 database administrator: Here also used bit, the problem is that CR detects the Crystal report odbc Source but the connection don’t works.


Setting up crysyal with the connection settings embedded in the report. You can now select the columns and rows that to include within the Cross-Tab report. Thank you in advance. If crystal report odbc want to browse the data, select a field and click the Browse Obc Alternatively you can select multiple tables and add them to the report.

Using Connector/ODBC with Crystal Reports

Once the ODBC connection has been opened within Crystal Reports, you can browse and add any fields within the crystal report odbc tables into your reports. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Since we are not creating a graph from this data, click Finish to generate the report. Open your report again, and refresh the data. I did a netstat but I crystal report odbc see the port listening.

Refresh it the report.