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.

然后点击右侧的更新"按钮.而已！你完成了.尽管当前数据源"部分中的对象名称似乎没有变化，但如果您单击对象旁边的 (+) 号，源名称将显示您使用的新 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屋！