Crystal Reports更改数据源 [英] Crystal Reports Changing the Data Source

问题描述

我有一个Crystal报表，其中数据源最初设置为使用ODBC连接。现在我想修改数据源，而不是使用OLE DB而不是使用ODBC。如何替换数据源连接而不中断我最初为报告设置的数据库字段？如果我尝试删除原始数据源，我已经设置的字段也将被删除。有没有办法将报告映射为使用OLE DB而不是ODBC连接？

I have a Crystal report where the data source has originally been set to use ODBC connections. Now I want to modify the data source to instead use OLE DB instead of using ODBC. How do I replace the data source connection without breaking the database fields which I have originally set up for my report? If I try to delete the original data source, the fields which I have already set up are also deleted. Is there a way to map the report to use OLE DB instead of the ODBC connection?

谢谢。

推荐答案

很容易。右键单击字段资源管理器中的数据库字段。单击设置数据源位置然后您将在对话框中看到两个部分。 当前数据源和替换为。在当前数据源中 - 选择要替换的对象。然后在替换为部分中单击创建新连接>OLE DB>通过提供驱动程序和凭据信息连接到所需的数据库对象。

Its easy. Right click on the database fields in your field explorer. Click on 'Set datasource location' And then you will see two sections in a dialog. "Current datasource" and "replace with". In the current datasource - select the object you want to replace. Then in the "Replace with" section click on "create new connection">"OLE DB">Connect to the database object that you want by supplying driver and credential information.

然后点击右侧的更新按钮。而已！你完成了。虽然在当前数据源部分中对象名可能不会改变，但如果u单击对象旁边的（+）符号，源名将显示您使用的新OLEDB对象

Then click the 'update' button on the right side. That's it! You're done. Though the object name might not seem to change in the 'current datasource' section, still if u click on the (+) sign next to the object, the source name will show the new OLEDB object that you used

这篇关于Crystal Reports更改数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！