I need to build a reporting system that would pull the data from a Microsoft SQL server database.
I have done similar stuff with LAMP stack. But I'm wondering what's the best way to do so in a windows server world (even if that means using PHP with IIS) ? What tools are needed ? I have access to Visual studio, expression studio and any other Microsoft software.
EDIT: Should have clarified, that this system is going to be used internally. So need a robust solution that will work in production.