SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft.

AC Uses crystal reports to generate its reports. There is a competing product known as SSRS for SQL Server. This often gives you more granular control of data. Your only limitation is probably your imagination. James posted an example of generating a record set from the data.
http://amazingcharts.com/ub/ubbthreads.php/topics/47680/Re_sending_mass_emails#Post47680

That's using SQL Server Integration Services (SSIR).

For generating the report only SSRS suffice. It's not exactly practical for a solo physician though. AC's way is much easier but limited.