如何更改水晶报表文件的数据源类型 [英] How to change the datasource type on a crystal reports file

问题描述

是否可以在无需重新构建整个报表的情况下更改水晶报表文件的数据源类型?

Is it possible to change the datasource type on a crystal reports file without having to rebuild the entire report?

我知道我可以转到数据库/设置数据源位置并更改一些数据源定义，例如服务器名、登录名、密码，但是我必须做什么才能从 ODBC (RDO) 数据源类型更改为 OLEDB?

I know that I can go to Database / Set Datasource Location and change some datasource definitions like servername, login, password, but what do I have to do to change from an ODBC (RDO) datasource type to OLEDB?

我已经尝试向报表添加新数据源并从该数据源添加所需的表，但是这样做时我必须重命名它们，因为 Crystal Reports 似乎无法处理具有相同名称但不同数据源的表...

I already tried adding a new datasource to the report and add the required tables from that datasource but when doing so I have to rename them because Crystal Reports doesn't seems to be able to handle tables with the same name but different datasources...

推荐答案

你说的是通过设计器还是编程方式?

Are you talking about through the designer or programmatically?

Designer:转到设置数据源位置"对话框，在下部窗格中创建 oledb 连接，在顶部窗格中选择现有表，选择匹配的 oledb 表，点击更新"按钮.对每个表重复.

Designer: go to "Set Datasource Location" dialog, create the oledb connection in the lower pane, select an existing table in the top pane, select the matching oledb table, hit the "update" button. Repeat for each table.

以编程方式:不确定，但可能很痛苦.:)

Programmatically: not sure but it's probably a pain. :)

这篇关于如何更改水晶报表文件的数据源类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！