Crystal Reports - 向存储过程添加新字段并使其在 IDE 中可用? [英] Crystal Reports - Add a new field to a stored procedure and make it available in the IDE?
问题描述
我在存储过程中添加了一个新字段.
I added a new field to a stored procedure.
如何在不重置数据库专家中的数据源的情况下使其在 Crystal Reports 中可用?
How do I get it to be available in Crystal Reports without resetting the datasource in the database expert?
推荐答案
验证数据库有效，但如果您使用 Set Datasource Location (在数据库 > 设置数据源位置中找到)以在 proc 更改后更新报告:
Verify Database works, but you have more control over things if you use the Set Datasource Location (found in Database > Set Datasource Location) to update the report after a proc change:
- 打开设置数据源位置"对话框(数据库 > 设置数据源位置).
- 在当前数据源窗格中左键单击/选择要更新的过程
- 在替换为"窗格中导航到要更新的服务器上的过程
- 如果您已经在 Crystal Reports Developer 应用程序中运行过报表，请使用当前连接页.刷新窗格可能需要一段时间.
- 否则，导航到创建新连接 > [数据库] 叶.如果使用 Oracle，系统将提示您输入连接的 TNS、用户和密码
- Open the Set Datasource Location dialogue (Database > Set Datasource Location).
- Left click/select the procedure to update in the Current Data Source pane
- Navigate to the procedure on the server to update with in the Replace with pane
- Use the Current Connections leaf if you've already ran a report within the Crystal Reports Developer application. It can take a while for the pane to refresh.
- Otherwise, navigate to the Create New Connection > [Database] leaf. If using Oracle, you will be prompted for the TNS, user and password for the connection
您可以在此处设置覆盖的表限定符名称，当单个报告要支持使用相同 TNS 名称的多个环境时，这对于 Oracle 至关重要.
This is where you set the Overridden Table Qualifier Name, which is essential for Oracle when a single report is to support multiple environments using the same TNS name.
这篇关于Crystal Reports - 向存储过程添加新字段并使其在 IDE 中可用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
