Adding new field to a SSRS BAQ Report

Hi Everyone,

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 :frowning:

1 Like

Check in the BAQ Report Designer, Correct BAQ is connected there.

Hi -Yes it is

Modifying RDL in correct Environment?
Can you share your BAQ Query also?


Modifying in test environment- noticed the report was using a shared datasource from live environment so corrected that, still no joy-

baq query is below - the red highlighted part is the table i added

with new added field:

solved thanks for your help- i found i was being stupid- face palm!

Thank you exactly what I needed