>>I have been tasked with finding a reporting tool that we can use on our intranet.
>>
>>We are converting a complex Access application to SQL. What the person who wrote it considers a 'report' is grids of data put up in front of the user.
>>
>>Now I'm a fan of Crystal, but I want to research other tools, so I'm soliciting recommendations.
>
>SQL Server Reporting Services. Free. Web Based. Output to screen, PDF, XLS.

Allows Ad-hoc reporting as well as canned reports, by the way.