SQL Reporting Services vs Microsoft Access

Is SQL Reporting Services a good replacement for Microsoft Access reports?

I write a lot of AdHoc reports and I always use Access, all my databases are in SQL and I link to them through ODBC, while I like to write all my code in pass-through SQL queries I sometime use the Query builder in access to help me with the more complicated queries and for the really complicated ones I post a question here.

I am reasonably fluent with C# not an expert but not a beginner either.

I have stuck with access cause I know it and the reports are all for me, I do not share them with anyone else (unless they are PDFd/printed) so I have avoided the SQL Reporting Services learning curve, but I am thinking about going down it but only if the report functionality is as good as access.

I have never tried to generate reports in C#, I have a lot of code in c# to manipulate databases etc, but whenever I do a report I put it in Access...

Thoughts?

-Rowan
LVL 11
rowansmithAsked:
Who is Participating?
 
shorakCommented:
Its been a long while since I have used Access to create reports but I have been using reporting services for the past 6 months (started off as a beginner) and its really good compared to Access reports and easy to use. You can also add custom functions writen in vb.net or C#.

see these links for some reviews
http://redmondmag.com/features/article.asp?editorialsid=456
http://www.techworld.com/applications/reviews/index.cfm?reviewid=237
http://msdn.microsoft.com/en-us/library/ms159273(SQL.90).aspx

You can also migrate Access reports to reporting services.. see this link:
http://technet.microsoft.com/en-us/library/cc966391.aspx

Also, this site gives some guidances on best practice in reporting services but gives a few screenshots of the reports possible in reporting services
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

Hope all this helps

Rob
0
 
tbsgadiCommented:
Hi rowansmith,

Have a look at the following to get some idea.
http://technet.microsoft.com/en-us/library/cc966391.aspx

Good Luck!

Gary
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.