Crystal Reports will now read the table definitions and automatically identify the links between the tables. The problem is that I can’t determine what directory the system wants me to use. Once the ODBC connection has been opened within Crystal Reports, you can browse and add any fields within the available tables into your reports. By the way, I have the “tables” and “views” correctly checked in the “Options” choice of the connection. Please review this document for additional information on the scope of Sage Customer Support Services. This solution requires advanced knowledge of your network.

Uploader: Bakinos
Date Added: 4 April 2015
File Size: 62.8 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 93150
Price: Free* [*Free Regsitration Required]

Also install Crystal Reports Always create a backup of your data before proceeding with advanced solutions.

Have you tried others? Expand Create New Connection.

How do I setup an ODBC connection for Crystal Reports for Sage SP2?

Search option odbc crystal report incident management is not working Larry Hollingsw on: Sage Customer Support does not provide assistance for issues related to reeport party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions.

Please remember to be considerate of other members.

Here also used bit, the problem crysttal that CR detects the Odbc crystal report Source but the connection don’t works. Odbc crystal report shared my technical memory in spanish. If Crystal Reports is unable to perform the linking itself, you can manually create the links between fields in the tables you have selected. Select the accounting data folder and click OK. Skip to Main Content. For more information on this issue, see the Business Objects Knowledgebase for more information.


Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry.

All submitted content is subject to our Terms Of Use. Contact your system administrator for assistance.

Click File, New, Standard Reports. Where do dll’s go? Crystal Reports will now read the table definitions and automatically identify the links between the tables. I want to thank all those who collaborate in this forum and thanks to some post, I made odbc crystal report installation of Crystal Reports, but I think something more to be done. You should probably ignore my previous post. I also use ODBC to dump tables in access to screen when I’m figuring out what tables to use in Crystal, and to verify report data.

Thank you in advance. Do not post advertisements, offensive material, profanity, or odbc crystal report attacks. I am using Windows Server bit, Service Manager 9.

Regards, Keval Raj 0 Votes. Odbc crystal report our example, we will expand the selected Sakila database. Monitor your DB session to see what query is sent to your DB.


Use the ODBC driver in Crystal Reports

When I want to make the database connection from CR, it displays the message ” Connection is not possibleDetails: Other applications Access, Excel do show tables. This solution requires advanced knowledge of your network. Demo data issue in SM. There is a known issue with certain versions of Crystal Reports where the application is unable to open and browse tables crystaal fields through an ODBC connection.

By using this site, you accept the Terms of Use and Rules of Participation. If you’re asking for technical help, please be odbc crystal report to include all your system info, including operating system, model number, and any other specifics related to the odbc crystal report. Try xrystal the files via exact same odbc connection in access.