Hi, Thanks in advance. I am having a report and i need to display mailing labels in the coverpage. in a row i need to display 2 labels and i am having a dataset of 57 rows. anybody please suggest. I had already tried with multiple column type reports. please ignore that. i did not work for me. Thanks

Please let us know why the Multiple Column type reports did not work for youCraig Bryden - Please mark correct answers

The Multiple Column Type report is only for pdf and tiff. It required for me to export to csv sometimes. I need the same in that too. Thanks, Kompella Murthy.

Hi Kompella, Generally, we can design multi-column newsletter-style reports whereby data flows down multiple adjacent columns. As you posted, only the PDF and TIFF files support a newsletter-style layout. Based on your requirements, there is a workaround to deal with this issue. You need to display two labels in each rows, it means the report has two columns to display data. So, you can use a query to split a field into two fields, one field is display the odd lines data in the first column, the other field is display the even lines data in the second column. For example, I have a dataset is named DataSet1 and within a ProductName field which is select from the DimProduct table. Please take the following query to split the ProductName field: WITH RowNumber as ( SELECT ProductName,ROW_NUMBER() OVER(ORDER BY ProductName) as RowNum FROM dbo.DimProduct ) SELECT a.ProductName AS ProductName1, b.ProductName as ProductName2 FROM (SELECT * FROM RowNumber WHERE RowNum%2 =1) as a left join (SELECT * FROM RowNumber) AS b ON a.RowNum+1 = b.RowNum (Note: please modify the field name and the table name based on your environment) If you have any questions, please feel free to ask. Thanks, Bin Long