动态传递参数到iReport 4.0.1 [英] Dynamically Passing Parameters to iReport 4.0.1

问题描述

我正在研究iReport 4.0.1版。我的查询是

I'm working on iReport version 4.0.1. My query is

select productcategory as CATEGORYNAME,
    value as VALUE,m_product_id::text,
    product as NAME,count(pricexception) as stock 
from dtawm_stockcalculation_v
where m_product_id=$P{M_Product_ID} or $P{M_Product_ID} is null
    and productcategory=$P{M_Product_Category_ID} 
    or $P{M_Product_Category_ID} is null
group by value,m_product_id,product,productcategory 

我在其中使用两个参数： $ P {M_Product_ID} 和 $ P {M_Product_Category_ID} 。这里我将两个参数的默认值设置为'％'但是我收到错误：

In which I am using two parameters: $P{M_Product_ID} and $P{M_Product_Category_ID}. Here I am setting default value for both parameters as '%' but I get an error:

Cannot cast char to string.

推荐答案

通常我们使用来设置默认值字符串类型参数。

Usually we use " " to set the default value for string type parameter.

这篇关于动态传递参数到iReport 4.0.1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！