The municipality has been planning to move to SQL Server 2008 R2. Now obviously I’m happy about it, but it also made me wonder about our Report Builder 1.0 models. I know Report Builder 3.0 doesn’t have all the functionality that Report Builder 1.0 has. In some ways Report Builder 3.0 outdoes version 1.0 and in other ways it’s lacking.
I was deliberating on how the move of upgrading to SQL Server 2008 R2 may affect us in the municipality. I mean, does that make our Report Models from 1.0 obsolete? Maybe there’s no point in continuing to develop Report Models, as the next Report Builder versions (both 2.0 and 3.0) are not necessarily model driven as version 1.0 was.
So what is a girl left to do, but put up a question in the MSDN SQL Server Reporting Services Forum? Which is exactly what I did 🙂
I wanted to get a better insight into the Microsoft strategy for Report Builder in general. So, I understood from the answers that support for Report Builder 1.0 will not stop and that both Report Builder 2.0 and 3.0 support models. After you open a report with Report Builder 3.0 (or 2.0) you will not be able to modify it with Report Builder 1.0 again, as there is no backward compatibility.
Not too long ago, I saw that in his post regarding SQL Server 2008 R2, Robert Bruckner had put up a Report Builder 3.0 FAQ document. There are quite a few points there regarding Report Builder 3.0 and how it stands in comparison to Report Builder 1.0, so I guess I’m not the only one with doubts and hesitations… I really recommend you go over that document for a more in-depth and detailed look on the matter. Again, the message coming out of the document is – don’t worry about it!
So I guess development will continue as usual here.
In the meanwhile, I’m looking forward to a standalone release of Report Builder 3.0 so I can give it a go with the SQL Server 2008 R2 Express version I already installed.