kuchroo

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.

Reset type means that the crosstab will calculate the data for the entire report and reset type to page would mean that the crosstab will tabulate the data pagewise.