SSRS report definition is newer than Server

by

I actually ran into a similar problem where a change I needed to make resulted in an “Undocumented Error/Invalid RDL Structure” error in 2016, so I edited the RDL file so I could open it in an earlier version and make my changes. Not too hard, but you need to make a couple of tag edits.

For new reports you should probably just use an older version, but for existing reports you can do this: (I reverted to 2008)

  • Change the Report tag:
  • Delete the entire “ReportParametersLayout” block.
  • Delete the “df” tag and its content.
  • Delete the “ReportSections” and “ReportSection” opening and closing tags (not the content).

Actually wrote some superhackish code to do this as part of a blog post, but the manual edit is simple enough.

More Related Contents:

  1. hide/remove header and footer
  2. SSRS 2014 report deploy issue
  3. Add alternating row color to SQL Server Reporting services report
  4. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  5. Need help in calculation using two Datasets using Expression SSRS
  6. Local and global temporary tables in SQL Server
  7. Get first day of week in SQL Server
  8. What is the significance of 1/1/1753 in SQL Server?
  9. SQL Server add auto increment primary key to existing table
  10. Insert Update trigger how to determine if insert or update
  11. SQL Server: UPDATE a table by using ORDER BY
  12. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  13. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  14. SQL Server: How to select all days in a date range even if no data exists for some days
  15. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  16. Do while loop in SQL Server 2008
  17. TSQL: How to convert local time to UTC? (SQL Server 2008)
  18. Transpose rows and columns with no aggregate
  19. How do I pass value to a stored procedure parameter in OLE DB Source component?
  20. Possible to set default schema from connection string?
  21. How does sql server choose values in an update statement where there are multiple options?
  22. Best way to store time (hh:mm) in a database
  23. Stored procedure – return identity as output parameter or scalar
  24. Why does a parameterized query produces vastly slower query plan vs non-parameterized query
  25. SELECT INTO a table variable in T-SQL
  26. SQL Server: Filter output of sp_who2
  27. How can I insert binary file data into a binary SQL field using a simple insert statement?
  28. Generate table relationship diagram from existing schema (SQL Server) [closed]
  29. Bootstrapping SQL Express from WiX?
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment