FYI:the BIRT World article should work (I written it) but that was an early Solutions to the problem.

我们创造了一个开放的原始来源,你可以补充BIRT,为这一问题找到更清洁的解决办法。 单功能平衡中的双功能参数提供了从多价值参数中进行多功能的简单方法。

如果你仍然有兴趣查阅关于Eclipserak的“侵权行为-lib”项目。

这里是另一个。 根据一些方面,我发现别处,并延伸到保留数据组中的参数。 这一解决办法与 Java本功能有关,你在数据集的OnBeforeOpen呼吁:

prepare(this);

function prepare(dataSet) {
    while (dataSet.queryText.indexOf("@IN?")>=0) {
        dataSet.queryText = dataSet.queryText.replace(
            "@XYZ?", 
            "( "+params["products"].value.join(" , ")+" ) or ?=0"
        );
    }
}

In your query, replace occurrences of (?) with @XYZ?. The method above makes sure that the query has the actual values and still a parameter (so that the dataset editor and preview doesn t complain).

注:通过不容许扼制价值观来认识Kalk注入。

我提出了一个更为一般性的解决办法,处理optional/required criteria的行为。 如果不需要参数,用户则不选择任何价值,国家残疾人协会便会残疾。 它还允许用户选择实际价值和无效价值。

在报告<代码>中,初始 文字一添加本法典:

/** Fullfill IN-clause in a data set query,
 *  using a List box report parameter.
 *  Placeholder must be the parentheses after IN keyword with wathever you want inside.
 *  If required is false then the whole IN-clause in the query 
 *  must be surrounded by parentheses.
 *  dataType and required refers to the parameter, they must be passed, 
 *  but should be better to find a way to retrieve them inside this function
 *  (given parameter name).
 */
function fulfillInClause(dataSet, placeholder, param, dataType, required) {

    if (dataSet.queryText.indexOf(placeholder)>=0) {

        var paramValue = params[param].value;
        var emptyParam = (paramValue==null || paramValue.length<=0);

        //build the list of possible values
        //  paramValue==null check in ternary operators 
        //  will prevent exceptions when user doesn t select any value
        //  (it will not affect the query if param is optional, 
        //  while we will never arrive here if it is required)
        var replacement = " (";
        if (dataType == "string")
            replacement += (emptyParam ? "  " : createList(paramValue, ",", " ", "varchar(10)") );
        else if (dataType == "integer")
            replacement += (emptyParam ? "0"  : createList(paramValue, ",", "" , "int"        ) );
        else
            //TODO implement more cases
            return;
        replacement += ") ";

        //if param is not required and user doesn t select any value for it
        //then nullify the IN clause with an always-true clause
        if (!required && emptyParam)
            replacement += " or 0=0 ";

        //put replacement in the query
        dataSet.queryText = dataSet.queryText.replace( placeholder, replacement );
        //DEBUG
        params["debug" + dataSet.name + "Query"]=dataSet.queryText;        
    }
}

/** Create a string list of array values,
 *  separated by separator and each of them surrounded by a pair surrounders
 */
function createList(array, separator, surrounder, sqlDataType){
    var result = "";

    for(var i=0; i<array.length; i++) {

        if(result.length>0)
            result += separator;

        if(array[i]!=null)
            result += surrounder + array[i] + surrounder;
        else
            result += "cast(null as " + sqlDataType + ")";
    }
    return result;
}

Usage example

在数据查询中,请你特别说明:

select F1, F2
from T1 
where F3= Bubi 
  and ( F4 in (  /*?customers*/) )

在<代码>前 开放式数据集与印本:

fulfillInClause(this, "(  /*?customers*/)", "customers", "string", false);

请注意,我使用一名持单人,允许在更换之前进行盘问(例如,它援引的是F4是一种var)。 You can Building a place holder thatfits.