
Step 1: 创建Data Sources
Classic Models Inc. Sample Database
Step 2: 创建Data Sets
select CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
CLASSICMODELS.CUSTOMERS.CUSTOMERNAME,
CLASSICMODELS.CUSTOMERS.COUNTRY
from CLASSICMODELS.CUSTOMERS
Step 3: 创建Report Parameters
Name: param
Display Type: List Box
选择Static
点击Import Values…
Select Data Set: Data Set
Select Column: COUNTRY
点击 >>
Step 4: 修改Data Set的Query选项
select CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,
CLASSICMODELS.CUSTOMERS.CUSTOMERNAME,
CLASSICMODELS.CUSTOMERS.COUNTRY
from CLASSICMODELS.CUSTOMERS
where CLASSICMODELS.CUSTOMERS.COUNTRY = ?
Step 5: 修改Data Set的Parameters选项
Name: param_1
Data Type: String
Direction: Input
Default Value: N/A
Linked To Report Parameter: param
Step 6: 创建Table,然后绑订到Data Set
Step 7: 点击 Preview 预览结果,(用户会被提示输入参数)。
百灵报表问题解答请浏览http://www.actuatechina.com/index.php
会员注册
会员登录
个人空间