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,则可以更好地控制事物位置(可在数据库>设置数据源位置中找到)以在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
在这里设置覆盖表限定符名称,这对于Oracle是必不可少的当单个报告要支持使用相同TNS名称的多个环境时。
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屋!