Dear sir/madam, I'm using Visual Studio 2008 and SQL Server 2008 SP1. I want to design data to show two columns in list as below: Annual Appraisal Probation Appraisal Sepcial Appraisal Comment I look forward to hearing from you. Thanks, Seyha seyha

are you getting data from Cube or T SQLGaurav Gupta http://sqlservermsbiblog.blogspot.com/

Dear Gaurav Gupta, I am getting data from T-SQL. SELECT PerfApprType FROM Tbl_PerfAppraisal . Thanks, Seyhaseyha

Hi seyha, Based on my understanding, the dataset returns rows as follows: Annual Appraisal Probation Appraisal Sepcial Appraisal Comment and you want them display on the report like this: Annual Appraisal Probation Appraisal Sepcial Appraisal Comment if so, it is hard to achieve this in reporting services, instead, we could do it in dataset query using T-SQL. thanks, Jerry

Dear Jerry Nee, Can please you tell me how to do it using T-SQL without preparing data in dataset. Thanks, Seyhaseyha