Adding new field from BAQ to SSRS

[cfinley (Chance Finley)]

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…

RDD SSRS Adding a UD table, Sync Dataset?

As we all initially expected it to do. I guess the original intent of “Synch Dataset” was to do exactly that. But as you probably saw in the RDL(after pressing Sync Dataset), that process is unable to simple add the new additions to the RDD’s output. It has to breakdown the RDD into individual tables(which appear as separate Datasets in the RDL), renaming fields where conflicts exist. And often fails at this.

SSRS error - Cannot Read next data row

Was it a Sync Dataset issue? Go with this Personalization: [image] If you copy the Base Dataset, and paste it into something like Notepad++, and do the same with your modified version - oftentimes after a few minutes of staring you see how the Base fields and the added fields and then any customizations are somewhat organized and you can kind of copy paste into a new version for the customization - but then you have backups of it, just in case. Oftentimes you can remove entire Datasets for s…