Preview Mode not displaying in VS 2012

Good Day To all,

I recently install VS 2012 ver 4.5 on my machine. After a few configurations I was able to connect to our SQL server and create a sample report, but when I try to preview the report I get the following error. I've looked into some of threads that relate to the possible problem but was still unable to resolve this problem can some one help 

Thanks in advance

===================================

An error prevented the view from loading. (Microsoft Visual Studio)

===================================

An error occured while attempting to start the report preview worker process. (Microsoft.ReportingServices.Designer.11.0)

------------------------------
Program Location:

   at Microsoft.ReportDesigner.Design.ProcessingHostProcess.StartProcess()
   at Microsoft.ReportDesigner.Design.ProcessingHostProcess.GetProcessingClient(IPreviewProcessingCallback callback)
   at Microsoft.ReportDesigner.Design.WCFProcessingHost..ctor(ProcessingHostProcess hostProcess, ILocalCatalog catalog)
   at Microsoft.ReportDesigner.Design.PreviewFrame.<>c__DisplayClass1.<CreateLocalReport>b__0()
   at Microsoft.Reporting.WinForms.LocalReport..ctor(Func`1 getNewProcessingHostInstance)
   at Microsoft.ReportDesigner.Design.PreviewFrame.CreateLocalReport()
   at Microsoft.Reporting.WinForms.ReportViewer.Reset()
   at Microsoft.ReportDesigner.Design.PreviewFrame.Initialize(ProjectReportDesigner designer)
   at Microsoft.ReportDesigner.Design.ProjectReportDesigner.CreatePreviewFrame(VsStyleToolBar pageViewToolBar)
   at Microsoft.DataWarehouse.Design.EditorWindow.EnsureViewIsLoaded(EditorView view)

===================================

CreateProcess failed with Error Code: 5 (Microsoft.ReportingServices.Designer.11.0)

------------------------------
Program Location:

   at Microsoft.ReportDesigner.Design.DependentProcessMonitor.TraceAndThrowLastError(String functionName)
   at Microsoft.ReportDesigner.Design.DependentProcessMonitor.CreateDependentProcess(String exePath, String commandLineArgs)
   at Microsoft.ReportDesigner.Design.ProcessingHostProcess.StartProcess()

April 28th, 2015 3:47pm

Hi David,

Base on my research, the error "CreateProcess failed with Error Code: 5" error, it usually occurs due to sufficient permissions. the same behavior and error could be reproduced by launching a Remote Desktop session in Seamless or Remote Applications Integrated Locally (RAIL) mode.

Here, I suggest that you try the following steps:

  1. In the Report Designer, right click the report and click "Run" to see if the report can be previewed properly in the pop-up window.
  2. Log onto the computer with an administrator account and check the issue again. 
  3.  If the report development environment is the SQL Server Data Tools (SSDT) shipped with SQL Server 2012 and you launch the SSDT via Remote Desktop Procotol (RDP) in Seamless/RAIL mode , SSDT will fail to launch Preview process. This is by design.

Here has a blog which describe this error, please refer to the following link to see the detail information about this error.
An Error when attempting to Preview a Report using SQL Server Data Tools in a Remote Session

Similar thread for your reference:
SSDT 2012 Report preview not working

If you still have any problem, please feel free to ask.

Regards,
Vicky Liu

Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 3:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics