使用存储过程的结果,参数为asp.net应用程序中的图表 - 水晶报告的值 [英] using result from a stored procedure with parameters as value for gauge chart - crystal reports in asp.net application
问题描述
我有一个存储过程,它接受2个参数并返回一个整数值。我想这个值是页面上的量表图表的值。 2个参数将根据所选项目的属性而改变。有一个简单的方法将一个值从存储过程传递到图表显示?这将嵌入在asp.net应用程序(vb)中 - 因此,根据先前选择的项目,参数和结果的值将更改。感谢您的帮助。
I have a stored procedure that takes in 2 parameters and returns an integer value. I would like this value to be the value for a gauge chart on the page. The 2 parameters will change depending on the attributes of the selected item. Is there a simple way to pass the one value from the stored procedure to the chart to display? This will be embedded in an asp.net application (vb) - so depending on the previously selected item, the values for the parameters and result will change. thank you for your help.
推荐答案
-
创建包
Create the package
CREATE OR REPLACE PACKAGE REPORTING AS
type query_results is ref cursor;
PROCEDURE barfoo (one IN INTEGER, two IN INTEGER, three IN OUT REPORTING.query_results);
END REPORTING;
END REPORTING;
创建存储过程
CREATE OR REPLACE PROCEDURE BARFOO(
one IN INTEGER DEFAULT NULL,
two IN INTEGER DEFAULT NULL,
三IN OUT reporting.query_results
)AS
BEGIN
CREATE OR REPLACE PROCEDURE BARFOO ( one IN INTEGER DEFAULT NULL, two IN INTEGER DEFAULT NULL, three IN OUT reporting.query_results ) AS BEGIN
打开三个
选择一个+两个
从双
;
open three for select one + two total from dual ;
END BARFOO;
END BARFOO;
建立报告
3a。确保存储过程在数据库专家中可见
3a. Ensure that stored procedures will be visible in the Database 'Expert'
3b。将存储过程添加到报表
3b. Add the stored procedure to the report
3c。添加图表
插入|图表... |类型选项卡| Gauge,then Data tab
Insert | Chart... | Type tab | Gauge, then Data tab
- 结果
这篇关于使用存储过程的结果,参数为asp.net应用程序中的图表 - 水晶报告的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!