Moving from MS-Access reports to SQL Server Reporting Services (SSRS)

[steevie_t]

I'm comtemplating the move, because I think it will do the following:

• Centralise the reports
• Be easier to produce PDFs
• Produce HTML for when we want to report directly to the web
• Perform better
• Be easier to manage reports individually

I could probably do all that with MS-Access but SSRS seems to have it ready made. Any experiences out there, good, bad, ugly? I'll probably be doing an import from Access 2003, is there much that gets lost in the translation?

steve