Hi Zafar.Yousafi, There is no direct way to archive it, as a workaround, we take CRLF to combine the each person’ detailed info together as one column in SQL query, then drag two tablix side by side to the report designer surface, show the odd person number info in the left tablix, show the even person number info in the right tablix, you can modify your query string like below: SELECT ROW_NUMBER() OVER (ORDER BY person) AS ID, person, Person + char(13) + char(10) +'Address:'+Address + char(13) + char(10)+'PhoneNumber:'+ PhoneNumber AS PersonInfo FROM PERSON Then, drop the Person info field into the two talbix, use the ID number to specify filter on the two tablix to separate the data to two parts, then click preview to run the report, the report should looks like below: https://skydrive.live.com/?cid=A37CD89A6497043C&id=A37CD89A6497043C%21121 Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi, I am creating a report to show the list of persons with some detail like address and phone number. Report design is such that I need to show 2 records in single row. Person 1 Person 2 Address Address Person 3 Person 4 Address Address All the data come from the same source. How can I achieve this

How does it store in the table in the database?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

This is simple a user table having UserId Name and Address My Problem is to show two records in front of each other.

Forgot to mention I am using SSRS 2008

Hi Zafar.Yousafi, There is no direct way to archive it, as a workaround, we take CRLF to combine the each person’ detailed info together as one column in SQL query, then drag two tablix side by side to the report designer surface, show the odd person number info in the left tablix, show the even person number info in the right tablix, you can modify your query string like below: SELECT ROW_NUMBER() OVER (ORDER BY person) AS ID, person, Person + char(13) + char(10) +'Address:'+Address + char(13) + char(10)+'PhoneNumber:'+ PhoneNumber AS PersonInfo FROM PERSON Then, drop the Person info field into the two talbix, use the ID number to specify filter on the two tablix to separate the data to two parts, then click preview to run the report, the report should looks like below: https://skydrive.live.com/?cid=A37CD89A6497043C&id=A37CD89A6497043C%21120 Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.