Enterprise level Report designer and generator

I'm looking for a reliable and full features report designer and generator (like Crystal Reports.) Open source or free would be nice, but I'm open to commercial applications as well. My short list of requirements are:

• Works with MySQL
• Charting/Graphing (Hopefully with something like excels PivotTable feature)
  
• User authentication and authorization that ideally integrates with Active Directory

Crystal Reports is the only one that I have heard of, but I've also heard it has it's shortcomings. My searches haven't uncovered anything that really stands out, so I was wondering if anyone is aware of any good solutions.