help urgent

i want design report by giving values at runtime i am making use of dataset parameters its working when i give a single value

select p.name as a,count(p.name) as total,bug_status as b,bug_severity as c,c.name as d from bugs_sb.products p,bugs_sb.bugs b, bugs_sb.components c where and p.name in ( ?) group by p.name

this is my query
here if i pass single value for p.name it works but if i supply more than one value it doesnot can any one help me

Find more posts tagged with

Comments

Virgil Dodson

Hi vinayb, 
 
Take a look at the IN Clause report design example located at: 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/338-birt-parameters-using-in-clause/'>http://www.birt-exchange.com/devshare/designing-birt-reports/338-birt-parameters-using-in-clause/</a> 
 
Does this help?

vinayb

i it helped but in that example they r having where cluase for single paramters but i want it for multiple of those i conflicts when there r multiple of those but thanks a lot for help i hope u got my problem can u help me i want something that takes multiple values and handle multiple parameters thanks for help

Virgil Dodson

Hi again vinayb,

The example above takes a comma seperated list of values and then splits it up inside the Property Binding tab of the Data Set so that it can use the IN clause. You should look at that bit of scripting code since it is allowing multiple values for the parameter. Can you explain what else you were looking for when you say, "something that takes multiple values and handle multiple parameters "