May 2, 2006 at 9:35 am
We are currently using SQL 2000 and it works fine for our exising system. Most of our front end is in Access 2003. We are slowly porting it over to .NET (C# for the most part). Our Access program has thousands of reports - many are quite simple, while others have multiple sub-reports that may or may not be included (depending on the data). We want to begin generating these reports using reporting services (no familiarity with how they work at all). Should we upgrade our database to 2005 (as is there more built in functionality for reporting services)? Additionally, are there any good add-on tools for our Access reporting conversion? It is going to be a slow conversion process, but we are trying to establish a good, solid base.
Thanks for any help!
May 3, 2006 at 6:36 am
You can upgrade to SSRS 2005 without upgrading the database itself. I just went through the process in a test environment and it was very simple to complete. 2005 gives you the ability to hanlde multivalue parameters as well as locked headers in the HTML displays and dynamic sorting. Another big plus is Report Builder for user AdHoc reporting.
Access reports can be imported into SSRS as well, just be aware that it creates the data regions only as lists.
Hope this helps.
Dave
May 24, 2006 at 3:36 pm
just want to make sure i understand what you're saying--does this mean you can upgrade to RS2005 without upgrading the database to 2005 and stay with 2000?
thanks
dale
May 25, 2006 at 1:41 am
We've just upgraded our report server database to SS2005 from SS2000. All the (data) databases which the reports connect to still reside happily in SS2000.
May 31, 2006 at 8:10 am
thanks for the tip!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply