This can happen when you have some SQL Services installed and running on your machine that interfere with the Report Preview. You can check your current services by going opening Sql Server Configuration Manager:

![Sql Server Configuration Manager][1]

To **fix** this you can [do the following][2]:

1. Type <kbd>WinKey</kbd> + <kbd>R</kbd>,  input `services.msc` in the Run box, and press <kbd>Enter</kbd>.
2. Find the "Net.Pipe Listener Adapter" and either Restart or Disable it.  
   ![Net.Pipe Listener Adapter - Services][3]


The **workaround**, as SQLnbe mentioned, is to:

1. Right Click the RDLC file from solution explorer
2. Click "Run" from there which will open up a new window.  
    ![Run RDLC from Solution Explorer][4]


  [1]: https://i.stack.imgur.com/HJNlT.png
  [2]: https://social.msdn.microsoft.com/Forums/en-US/38ff8d54-06aa-40c3-8916-378d5185320e/report-designer-preview-in-ssdt-throws-up-a-end-point-not-found-error?forum=sqlreportingservices
  [3]: https://i.stack.imgur.com/AztX3.png
  [4]: https://i.stack.imgur.com/NxG2X.png

I'm having a very peculiar issue with SQL Server Data Tools 2012. Whenever I attempt to launch the report previewer, I get the following exception:

> There was no endpoint listening at net.pipe://localhost/PreviewProcessingServce7324/ReportProcessing that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more deatils.

![Error Message][1]

As far as I can tell, nothing I did triggered the issue. It just started happening one day when I fired up SSDT. I tried the suggestion on [
Report Designer Preview in SSDT throws up a 'end point' not found error][1]. 

However, my service is up and running just fine (restarting it didn't help), and using Setspn didn't do anything for it, either. 

Anyone have any ideas?


  [1]: https://i.stack.imgur.com/XH1pA.png
  [2]: https://social.msdn.microsoft.com/Forums/en-US/38ff8d54-06aa-40c3-8916-378d5185320e/report-designer-preview-in-ssdt-throws-up-a-end-point-not-found-error


SSDT/SSRS - Report Previewer Won't Run

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

Sortable columns on Tablix with multiple header rows

They will be greyed out if they are not identical in all fields selected. This can depend on a related formatting field being different.

One workaround is to create an internal text parameter:

![FontFamily Internal Parameter][1]

With default value of the value you want to use for the property:

![FontFamily Internal Parameter Default Value][2]

Then set the property for each cell that should have the same formatting to this parameter individually:

![Textbox properties with parameter][3]

Repeat this for each of the relevant child properties, you will then be able to change formatting across the report by changing the parameters.

  [1]: http://i.stack.imgur.com/1DgFj.png
  [2]: http://i.stack.imgur.com/VscYN.png
  [3]: http://i.stack.imgur.com/ki2O4.png

This is very similar to the post on [Formatting multiple fields at once in RDL][1], but there are still issues with setting properties like `Size.Width` and `Font.FontSize` when the underlying data is different between selected cells.  

Here's the accepted answer: 

> Select all the controls in the designer and press <kbd>F4</kbd> for properties. Change the background color

But if falls short when there is a property that is made up of several child properties. Here's an example using font and size, each of which are comprised of several properties.

This is what it looks like when a single field is selected or when multiple fields are selected that all have the same value:

![Properties](http://i.imgur.com/9xBOZwy.png)

But if I highlight several cells that have different font sizes, or widths, I lose the ability to edit them all simultaneously.  For example if I wanted to make consistent column widths across an entire report.

Here's what the properties look like when multiple fields are selected and any of them have a different value:

![Properties - Hidden](http://i.imgur.com/89fOdti.png)

It's not ideal, but in the case of the size property, I can enter the shorthand value which includes both width and height separated by a comma and it will apply that change to all the selected cells.

But for some reason, in the Font section, I can't even do that.

### Other things I've tried:

* **Using the Formatting Toolbar** - which seems to be always greyed out for SSRS:  
 ![Toolbar](http://i.imgur.com/6K8e03o.png)

* **Using the Formatting Menu Item** - which doesn't expose the FontSize property:  
 ![MenuBar](http://i.imgur.com/qWzqjJm.png)

* **Using the Context Menu** to enter the Properties Form, which is disabled:  
 ![ContextMenu](http://i.imgur.com/ezFXJ7B.png)

[1]: https://stackoverflow.com/q/3681397/1366033