I'm looking for advice/suggestions for a open-source or inexpensive (say, $10K max server license) reporting/BI tool or toolset written in .NET similar in form, functionality, features, and overall polish/presentation/professionalism to the Actuate/BIRT offering available on SourceForge. There seem to be quite a few BI toolsets in Java/J2EE, and I'll go that way if necessary if nobody else has what we need. Reporting Services 2005/2008 completely lacks the security, navigation, toolset, and features we need (and we've looked at RSInteract as an add-on already), and Analysis Services is limited to simple two-dimensional or "naive" Bayesian, basic clustering, etc. I need something with the polish/featureset of a high end Crystal Reports or Business Objects Edge suite, without the cost (my choice was Business Objects Edge but this was rejected at the time). My immediate need is reporting with basic functional dashboarding; analysis can wait for a quarter if necessary. Reprots will be consumed by internal end users, primarily executives and sales people. So, it has to look 110% and be salesman-friendly. Ad-hoc reporting is a nice to have but isn't necessary at this time, but basic report parameterization and metadata would be needed to support minimal ad-hoc reporting. The product must be MS-based with MS SQL Server 2005/2008 as a backend.
Please, for the love of Pete, no salespeople. I want advice/opinions from those who have been there and done that.