Its very simple to display multiple lines. For this you don't have to write any subdata query or multiple queries. You can simply select for multiple values by declaring a Parameter for multiple values eg: value in ($P!{parameter}) Giving a syntax like this will enable you to give multiple values for a single query. Also note that in GROUP BY clause give a group by of "value". Hope this will solve your problem.