>>I have an ASP.NET application. On user Submitting one of the pages, I need a report to be printed to a designated printer (report is basically one page form). The browser where the Submit is initiated does not have to and should not be aware of the report being printed. That is, the printing should be initiated either from Stored Procedure or from the SQL Server using what? What product should I be using for this? Crystal? Reporting Services?
>>
>>Any suggestions?
>
>
>First, assuming that SSRS has been installed as part of the SQL Server setup, I'd probably use SSRS
>
>Second..a question...when the user clicks submit, would the user be promoted for which printer to print to? (and any other print options...i.e., would the user get a print dialog?)

I will have to find out if SSRS is installed and learn it (which is harder than just install it :)). If it is not installed, can it - SSRS - be added to the existing SQL Server installation?

No, the user who Submits has no idea about this report or where it is being printed. So no dialog for the user. But when the report is printed from the Server it should go to a certain network printer (defined in some configuration file, like XML).

Thank you.