使存储过程参数在Crystal Reports中级联 [英] Make Stored Procedure parameters cascading in Crystal Reports

问题描述

我没有太多使用存储过程作为Crystal Reports数据源的经验.我的问题是，当您连接到具有2个参数(国家和城市)的Oracle存储过程时，这些参数已经分别映射到Crystal中.有什么办法可以让这些参数级联，即国家/地区">城市"，位于前端还是后端

I don't have a lot of experience using Stored Procedure as a data source for Crystal Reports. My question is that when you connect to an Oracle Stored procedure which has 2 parameters - Country and City, the parameters are already mapped in Crystal individually. Is there a way i can make these parameters cascading i.e. Country > City, either on front end or backend

推荐答案

在将存储过程添加到报表中之后，您应该在字段资源管理器的参数字段"部分中看到列出的两个参数.

After you add a stored procedure to the report, you should see the two parameters listed in the Parameter Fields section in the Field Explorer.

编辑其中一个参数，从值列表"选择列表中选择动态".单击值"列下面的第一行，以选择SP中的哪个字段将包含国家/地区"的值(键).对说明进行相同的操作.单击第二行，以对城市执行相同的过程.

Edit one of the parameters, select 'Dynamic' from the List of Values picklist. Click the first row below in the Value column to select which field in your SP will contain the value (key) for Country. Do the same for the description. Click the second row to follow the same process for the City.

参数的值将限于SP返回的值.

The parameters' values will be limited to what the SP returns.

如果将报表发布到BusinessObjects Enterprise，它将创建一个BusinessView(以及许多其他对象)来托管值列表.这样，您可以指定更广泛的值集(不仅限于SP的结果).

If you publish the report to BusinessObjects Enterprise, it will create a BusinessView (and lots of other objects) to host the List of Values. This allows you to specify a broader (not just limited to the SP's result) set of values.

这篇关于使存储过程参数在Crystal Reports中级联的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！