[phi-dan]

For creating formatted reports at work we use Crystal Reports. No need to know the full syntax, you just drag and drop fields onto the report, but you can also build complex queries, link tables, ref external data, etc.
One of the developers has a thing for Logicity (but she also hosts dashboards off nested shares on her PC instead of the web cluster / SharePoint server / data farm- go figure)