Adding new field from BAQ to SSRS

[rirish (Ryan Irish)]

So I’m making the painful transition from Crystal, which I loved, to SSRS, which so far has proven to be the least user-friendly software I’ve used in a long time. Now that I have some experience, I’m shocked that the lot of you didn’t start a mutiny when they took CR away…

Case in point…I have a custom BAQ report created that I needed to add a new field to after creation. In CR, you simply reran the report, set the data location and your new fields were part of the dataset. SSRS, not so much…I’ve read a few 15 step ‘solutions’ for rdd mods, but nothing regarding custom reports.

I tried to add the field to the dataset by going into properties>fields and then adding the field name, in this case Customer_Name, but the field never populates when I run the report. What am I missing, and could M$ do anything to make this software more difficult to use?

https://i.imgur.com/GYmBgsh.png

Thanks for any help.

Edit: I should mention that I have attempted to edit the expression as shown here, no luck, just errors where the customer name should be. https://i.imgur.com/WsxjA1C.png

[wclee (PasirG_Lee)]

If you using BAQ as bridge to SSRS. You need to select those field needed in BAQ. Then either sync or manually add in SSRS dataset.

[rirish (Ryan Irish)]

They are in the baq, I’ve generated a new report, just can’t figure out how to get the fields into SSRS.

[wclee (PasirG_Lee)]

You need to select those field before you create the SSRS. Else you need to sync or manually add in dataset -> properties -> query.

[rirish (Ryan Irish)]

Thanks for the advice.

[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…

[rirish (Ryan Irish)]

Many thanks! It was the select clause I was missing, I was just adding it to the fields section.

[Hally (Simon Hall)]

Hello @rirish,

Could you please mark your last post as the solution please.

Cheers