Community
Participate
Working Groups
Build Identifier: 3.7.0.v20110603-809u78FT0z0-TVCu7ujN7w Hi This is doing my head in! I'm a noob. I have a stored proc, which I am able to run with usual parameters if I hard code them e.g {call proc('2011-08-03','b','arg1|arg2|arg3')} Now the problem. When I try and use the variables through the parameters option the query would appear to work fine but what is happening is the third variable, which has a pipe | as a delimiter, only picks up the first word. This is the statement used for the parameters: {call proc(?,?,?)} I have tried various scenario's for data used in the parameters, such as using single/double quotes, no quotes and convert.. without any luck. I'm thinking that there is some inherent problem so I was wondering if someone could show me how I would go about passing the variables through a script. Or could suggest another method. Cheers JAH Reproducible: Always
Hi there, the data set parameter in BIRT can only accept one value. When the parameter is linked with a report parameter allowing multiple values, it will accept the first value. May you should modify your stored procedure to parse the parameter. Or could you attached your report design and stored procedure that we can investigate into this case ? Thanks.
