>Hello, I'm in the market for an end user report generation solution.
>In a perfect world, this solution should be royalty free, capable to connect to MS SQL data sources, able to use (or not) a data dictionary, should be able to export (or even design ) the reports to excel with pivot table option, able to schedule reports for email in dayly, weekly and montly basis with automatic parameters for reports and so on.
>Anyone know of such application?

SQL Server Reporting Services should handle most of your requirements, and it's free.