Microsoft Report Builder 2019

Some folks were concerned about using Microsoft Report Builder 2019 to customized Epicor Reports. Rest assured that 2016 and 2019 work fine. I am using Report Builder 2019. Just make sure that your team is using at least 2016+ or they won’t be able to open up a .rdl with 3.0 (2014).

Most of Epicor Reports have been built using Report Builder 3.0 (2014) which is not backwards compatible with Report Builder 2016 or Report Builder 2019. However Report Builder 2016 works with .rdl’s created with 2019.

If you open a .rdl that is created with 3.0 (2014) it’s xml will simply be converted (slightly) to the 2016 schema. You can’t download the old version from Microsoft anymore.

You will be fine, just make sure your team is using similar or newer Report Builder.

Versions:
Report Builder 3.0 (2014) [12.0.x]
Report Builder 2016 [15.0.900]
Report Builder (2019/2020) [15.0.19210] Same Schema as 2016

6 Likes

Thanks @hasokeric!

Hm, only 3.0 worked for me, last time I tried a newer version I got an error when I uploaded the report back to the cloud.

Hmmm. I remember we were SSRS 2014 and I used Report Builder 2016 fine on-prem.

I think it depends on the version of SSRS (SQL).

1 Like

Mr. Evan_Purdy is correct.

I have some SaaS MT customers that require 2014.

I believe Mr. Hasokeric is also correct - it depends on the SQL version.

I guess one lucky thing is that if the report is 2014 and you download it and then updated it using 2016 report builder. It will error out when you try to upload it back to the cloud.

Always make a backup just in case first.

DaveO

Or keep it in Source Control. There is a REST function to upload reports. There are also PowerShell scripts to manage SSRS.