Report is not compliant after opening the RDLC in SQL Report Builder

pabloquintana

I create a customized RDLC report. I export the file, open it in SQL 2016 Report Builder, and without any changes I save it. Then I try to import it and run the report. I get this error:



Any thoughts?

Kishorm

Are you doing this on the same report that you previously opened in report builder for 2016? If so then try with a new/different report instead.

binilabraham

From what version you exported the report ? Did you compiled the report after importing it ?

Kishorm

Try using Report Builder from an earlier version of SQL, e.g. SQL Server 2012 / 2014 instead. I think it needs to be Report Builder version 3.

pabloquintana

Thank you both.

@Kishorm I tried the 2014 version and it didn't open the files. I got a message complaining about the version from the beginning.

'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition'

@binilabraham it is NAV 2016 version. I am not sure which SQL server version is as we are using a cloud NAVonAzure version.

I can't find anything about compiling after saving the .rdlc file. Can you point me to where I can do find more info about that?

Kishorm

@pabloquintana What version is Report Builder in SQL Server 2014? (I haven't got it installed)

If it's not Report Builder 3.0 then I think you'll need to use the Report Builder from SQL 2012 which is Report Builder 3.0

pabloquintana

SQL Server 2014 Repor Builder v3.0

Kishorm

Are you doing this on the same report that you previously opened in report builder for 2016? If so then try with a new/different report instead.

pabloquintana

@Kishorm I opened a newly exported report. I will try again to make sure.

pabloquintana

@Kishorm again you were right. I was exporting an already modified by the SQL Server 2016 Report Builder rdlc file. That is why the 2014 version was not able to open it.

I started from scratch and Report Builder v3 is working fine now.