I read through this thread and I'm supprised nobody has mentioned Microsoft Reports. You can do things the same way you are used to with Microsoft Reports. I hardly ever you SP's. I build my SQL in a biz object (I use MM.net) bring all my data into a dataset then attach it to a report definition file (.rdlc file). I use the ASP.Net report viewer to display the report but there is also a Windows forms version of the viewer.

It's not as feature rich as CR but it does everything I need. Also I think the report designer in VS.Net 2005 is easier to use than the CR report designer.

I even built a windows service app that automates reporting. It will generate a PDF using the ASP.Net report viewer control and attach that PDF to an email.

There are also no licensing issues that I'm aware of.