With SQL Reporting Services being released recently, it's interesting to look back on the history of reporting...
For me it began with MS Access v1.0 back in 1992. A nice reporting system, with some programmability, producing on-screen and printed reports with a minimum of fuss. I followed Access right through to Access 2000, along the way I became an Access MVP... it was a fun ride but I've moved on.
The VB world started getting controls to allow reporting too, with the addition of pseudo-Access style reporting added in VB 6.
As we progressed, Web Reporting became more popular, and many ASP developers began to feel the pain. It was easy enough to generate report for displaying in a web page, but printing ... well it sucked really! Some played with using Word or Excel to print by exporting from the page into the correct format, others tried PDF generators, and then there was products like Crystal Reports. Personally I found that putting your data in XML format and having 2 XSLTs to generate either a XHTML output or the XML/HTML required for Excel XP worked rather well, but it's a pain if you're not working in an Intranet environment where you know what the client PC's have installed, and there's all those extra clicks for the users who simply want a "Print" button.
With the release of .NET we got a 5-user license of Crystal Reports built in... this was a major step forward for many developers, but it was plagued with problems. There were bugs, and the nagging dialog telling you to register. The object model let many people confused, and it was quite a while before any decent samples started to appear.
Even now, many developers are using home-brew reporting systems to aviod these headaches... but now we have SQL Reporting Services available for free (assuming you have SQL 2000).
Anyway, this is my history of reporting as far as I recall it, what have your experiences been like? What are your plans for SQL Reporting Services? Do you think this spells the end for Crystal Reports?
I'd love to hear your story, so post a comment!