An Error Occurred During Local Report Processing

• david_h_edmonds

  Default port

  Points: 1430

  More actions

  May 5, 2021 at 7:17 am

  #3879506

  Hi, I am using SQL Server 2012 and Report Server 2012.

  I have a solution that has approx 10 rdl files in it all working fine.

  I have added a new rdl that connects to an alternate datasource (test connection succeeds using windows auth)

  The rdl immediately fails at preview with "An Error Occurred During Local Report Processing".

  The logs don't show any entries so I can only presume it is indeed "local".

  The SQL statement works fine in SSMS and if I right click the data set in VS and select query, it returns data.

  The only additional thing is that the SQL statement is using PIVOT however I have used that before with no issues.

  Any help is gratefully appreciated.

  Cheers,

  Dave

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  May 6, 2021 at 8:10 am

  #3879987

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.