Adding new field from BAQ to SSRS

I would like to highly advise against using the Sync Dataset option inside of the Report Style screen. Always causes nothing but problems.

After you have added the fields into your BAQ, go into the dataset inside of your SSRS Report, then modify the query expression.

Add your new fields into the SELECT clause

Then add the field into the fields section

While it may be slightly time consuming to manually add the new fields into the SQL query inside your SSRS report, you’ll spend less time doing that than correcting the mess that that button creates…

1 Like