Hi,

In my report below text boxes are available

Ace Tech - Report

Vendor Name:TextCart

Vendor AB# :106027

Vendor Account #:AceTec, Inc.

What i need is i need to show this output in excel sheet but in excel sheet i need Rows 1 to 4- separate the tile from data; (Vendor Name in column A, Textcart in column C)

I need to show the output in excelsheet column A and Column C.

Please help me guys how to slove these..

Hi MS SQLSERVER,

According to your description, you want to display Vendor Name in column A and TextCart in column C in Excel sheet in Excel render, right?

In Reporting Services, there is no function or property could control which data to display in which column in Excel render format. In your scenario, if you want to display the title and data in separate column in Excel sheet, you could create a tablix control without any group, then add the title in first column and the data in third column. And decrease the width of second column. Please note you should put the tablix next to upper left corner of report body surface as much as possible. Please refer to screenshots below:

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu