Got a real annoying issue here. I have modified a BAQ which a BAQ report is based on. This baq has a new field called Calculated_InspDate.
BAQ compiles and runs beautifully.
Now I need to add the new field to the BAQ report - I cannot for the life of me get it to work.
Within the SSRS report builder, I have opened the baqreport results dataset properties:
And added the field into the query
and then manually added the field
Saved the report and then have the error in system monitor:
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 ‘BAQReportResult’. —> System.Data.SqlClient.SqlException: Invalid column name ‘Calculated_InspDate’.
I have the feeling that the report is based on the old baq dataset, not the new one which includes the new field.
I see the Report style has Sync Dataset but this is usually something no one ever touches! if I do click that then i get errors about the report having hidden expressions it doesn’t like. So i dont think its wise to go that route…
Any suggestions please- this should be a simple task