Hi to all, Im creating a report in my business intelligence development studio. I would to print address in the following format FirstName1 FirstName2 FirstName3 LastName1 LastName2 LastName3 Address1 Address 2 Address3 Now with the standard list my records are listed as a normal list FirstName1 LastName1 Address1 FirstName2 LastName2 Address2 FirstName3 LastName3 Address3 How can I format my list? Can someone help me? kind regards

Hi, You could achieve this using a combination of a table and a matrix instead of a list. Please have a look at this blog http://blogs.msdn.com/b/chrishays/archive/2004/07/23/horizontaltables.aspx HTH, RamRam

Hi Ram, Thanks for your reply,i made a matrix and it works fine. Unfortunately I have problems when i drag my matrix in the list. I receive the following error: The tabilx 'matrix' has a detail member with inner members. Detail members can only contain static inner members. What is wrong?

Hi, Check this link also http://p2p.wrox.com/content/articles/creating-mailing-labels-sql-server-reporting-servicesRegards, Asim Bagwan Kindly mark the replies as Answers if they help!

Hi, You are using Grouping in this Tablix?If not create dummy Group. right click row Group and Go to Group Click ADD Give The Group Name Dummy. hope it will workBest Regards, C.Gnanadurai ----------------------- Please mark the post as answer if it is helpfull to you

hi to all, it works now, i made an error on step 7. Step 7: Adjust the group expression in the matrix Edit the column group expression in your matrix and change the RowNumber argument to be the list group name. For example: =RowNumber("list1_Details_Group") thanks to all

Hi, You could achieve this using a combination of a table and a matrix instead of a list. Please have a look at this blog http://blogs.msdn.com/b/chrishays/archive/2004/07/23/horizontaltables.aspx HTH, RamRam