Has anyone had trouble adding a new table to there data set expression after upgrading to 10.2? In the past on 10.1.600 I used to be able to call tables in the data set via below. But I receive an error now.
*Report server has not changed since upgrade. Epicor and SSRS live on the same server
Data set expression table addition:
FROM MtlQueue_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN [RASE10PROD].[Erp].[JobOper] T2
ON T1.JobNum = T2.JobNum"
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘MtlQueue’. —> System.Data.SqlClient.SqlException: Invalid object name ‘RASE10PROD.Erp.JobOper’.