After struggling with VB6's built-in report generator, then a brief and frustrating fling with Crystal, I discovered Active Reports. It integrates seamlessly with VB6 and exposes events behind the report so that you can control the formatting programmatically. The dlls build straight into the VB distribution package (more than could be said for the version of Crystal I was using) so installation on client machines was simple. Best of all it has an excellent import wizard to convert reports from MS Access, so all my previous work in Access could be converted without the need to redesign all the reports. I don't know why this product isn't more widely known - it is brilliant. The price is also very good - once you've paid for a single developer licence you can distribute the user dlls to as many users as you like. I haven't tried the .NET product yet but if it's as good, I'll be trying to persuade my employers to buy it to use instead of the Crystal Reports that ships with VB.NET.