Never mind. I forget about the report labels query. You have to take out the offending fields and columns there, too.
Joe
Hi,
I have a query pulling sales commission data. The query and dashboard work fine. But when I try to make a BAQ report from the query, I get the following error message:
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 'RptLabels'. ---> System.Data.SqlClient.SqlException: Invalid column name 'InvcMisc1_Company'.Invalid column name 'InvcMisc1_InvoiceNum'.Invalid column name 'Calculated_FreightCharge'.
These columns belong to the subquery. I get this error even after taking those columns out of the dataset query in the SSRS report, so I gather it hitting this when the temporary table is built.
Has anyone overcome this?
Thanks,
Joe
--
Joe D. Trent
Bigham Ag Equipment