I have a .Net web application written in c# visual studio 2010 against a SQL Server 2008 database. Users are able to create and submit orders to our backoffice. We need to allow the users to download a report of their order at will. Also when an order is submitted we need to email them an order summary.
We have done this in the past by creating a CSV file but would like to more to a nicer solution; perhaps a PDF or Word file. Are there any free options we should be considering to allow us to generate attractive reports quickly?