Hi, I have some reporting functionality in my app and I want to improve it a bit. Its only SQL in a XML file which is read by some parser. There can be some params for that SQL and when its parsed and the params are injected, it is executed against my DB (SQL Server). I want to improve that a bit so that the results look better and are more flexible. This are the most important points I need to have:

• subtotals
• layout that can change dynamically according to settings in DB (like logo, slogan)
• possibility to use the same report template for several customers (same fields, but different logos,colors, slogans etc.)
• should run from an ASP.NET application

It should be as dynamic as possible. I know of Crystal Reports and the Microsoft Reporting Tool. Are there any others that might be of interest and are my above points possible at all?

Thanks for some ideas and hints :-)...