In short, **No, it's not possible**.

From [SSRS 2008 Column issue when exporting to a CSV file][1]:

> For csv export, the header of a column is determined by the `DataElementName` property of the textbox which actually contains the data. If the `DataElementName` property is not explicitly set by the user, DataElementName automatically gets defaulted to the value of the `textbox.Name` property.  
>
> That being said, I believe you're getting this issue because RDL has a restriction that both a `reportItem.Name` and `reportItem.DataElementName` property must be [**CLS-compliant identifiers**][2]. The headings like `"Phone #"`, `"Other Name(s)"`, etc... are not CLS-Compliant.
>
> You can verify this by opening up the report in BIDS or RB and trying to set the DataElementName/Name property of the textbox containing the data to those names.  
>
> You will get an error which states the following: 
>
> `Property Value is not valid. Specify a valid name. The name cannot contain spaces, and it must begin with a letter followed by letters, numbers, or the underscore character (_).`

There is a Microsoft Connect Issue about this, but unfortunately it looks like it won't be acted on.  
**See**: [Use of expressions for DataElementName property (for CSV Export)][3] 

[1]: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bc7bcae8-cce2-4626-8cb9-132a239a4ab8/#f9bd33ae-6d92-4050-94d8-92c6e26e00cc
[2]: http://www.unicode.org/unicode/reports/tr15/tr15-18.html
[3]: https://connect.microsoft.com/SQLServer/feedback/details/732034/

By default, csv takes the text box name as the csv header name for the columns. The text box does not allow a space. 

How do I make a different header than the text box for the csv?  
Is there a way to display comma in the header when exported to csv?

**Note**: The solution has to be only for one report; not global.


SSRS csv export with comma in the column header names

You are likely getting the error message `Report Builder was unable to paste successfully` because somewhere in the grid there is a cell that uses Custom Code From the Report

> i.e. you cannot copy a textbox with this custom code: “Code.MyCustomeCode()”  
 - [Report Builder was unable to paste successfully][1] 

This has been a reported bug since SSRS 2008:

> When using Visual Studio 2008 to create new reports, we cannot copy and paste multiple textboxes in a tablix, and receive a popup error stating "Report Builder was unable to paste successfully"  
 - [Unable to copy and paste textboxes in SSRS reports with Custom Code after 2008 R2 SP2 upgrade][2]

**Workaround**:

1. **Open up the XML** view for the report, either in Visual Studio by right clicking the report and selecting *View Code*, or by editing in any text editor.
2. **Comment out `Code.`** blocks.  <kbd>Ctrl</kbd> + <kbd>F</kbd> your way through the document looking for `Code.`.  The goal is to preserve the code in some way, while temporarily commenting out the line.  Depending on your actual code, this might be different, but I here's what I like to do:
   * *Find*: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`=Code.`
   * *Replace With*: `='Code.`
3. Go back to the Designer View and **Copy and Paste the Tablix**.  You can do this by right clicking the top left corner of the tablix control:  
   ![Copy Tablix](http://i.imgur.com/iNJQuqq.png)
4. Go back to the XML View and **reverse the find and replace**
   * *Find*: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`='Code.`
   * *Replace With*: `=Code.`

You should be all set!

> **Note**: You cannot just copy the `<tablix>` block in the XML view after step 1 because it will create elements with the same exact `name` property

[1]: http://mibuso.com/blogs/clausl/2014/09/05/report-builder-was-unable-to-paste-successfully/
[2]: https://connect.microsoft.com/SQLServer/feedback/details/767968/

I have a tablix that has data for one day, and I need to have the same data at the bottom but in 3 different lines.  I'd like to copy the main day table 3 times at the bottom, and then use different datasets for each one.

I tried copying the tablix and pasting it into the `Body` beneath the tablix, but I get the following error:

> Report Builder was unable to paste successfully.

How can I accomplish the copy and paste? Or if that isn't possible, is there another way to do what I am trying to accomplish?

Here's an animated screenshot:

![Example](http://i.imgur.com/OXmB4Zh.gif)

Copy and paste a table (tablix) in SSRS

Found the answer.  So the issue was that even though the interface functions are pretty similar to excel, cell borders are handled like individual objects with properties.

Meaning two adjacent cells don't share a common border definition between them at the boundary.

So in order to remove the bottom border on the top cell, you have to remove the bottom border on the top cell *AND* the top border on the middle cell.

![Removed Borders](http://imgur.com/TH6Y3nC.png)

What I really want to do is merge column headers vertically, but that doesn't appear possible in SSRS.  One work around presented in the quest [SSRS tablix Merging cells vertically problem][1] was to just remove the header borders.

However, when I remove the bottom border (or change the border at all for that matter), the old one still remains.

For example, here's a test case where I've removed the bottom border and add a wide red border to the top and sides:

![Tablix](http://i.imgur.com/L5suhYg.png)

And here are the properties on the top text box itself:

![Properties](http://i.imgur.com/f2OnRP9.png)

*How do I get rid of the black lines?*


[1]: https://stackoverflow.com/a/23300962/1366033

Remove header borders in Tablix

I have a tablix control with multiple header rows.  There are no groupings; the extra rows are just for the visual effect of displaying information.

I've followed the instructions for [how to add Interactive Sort to a Table or Matrix][1].

I've gone to the textbox in the header (also tried doing the same to all three) and gone to properties:

&nbsp;&nbsp;![Properties](http://i.imgur.com/diAutxC.png)

And then enabled Interactive Sorting:

&nbsp;&nbsp;![Interactive Sort](http://i.imgur.com/vnQhDeW.png)

If I only have a single header row, it works and looks like this:

&nbsp;&nbsp;![Expected](http://i.imgur.com/GM8aboc.png)

But it actually looks like this:

&nbsp;&nbsp;![Actual](http://i.imgur.com/7RoO3uY.png)

Can I add interactive sorting when there are multiple rows?

**Potential Workaround**: The only thing I thought of would be to add the sort fields as a parameter to the report and set the sorting at the Tablix level as an expression based off that.  But I like the organic look and feel of inline sorting.

[1]: http://technet.microsoft.com/en-us/library/cc627509.aspx