printing processed orders automatically

[Guest]

Hi,
I have a web app that users enter orders, then another department approve
the orders. I want to be able to have the processed orders be printed
automatically. How should I go about doing this? Do I have to create a
windows service that checks for processed orders and than print? Or can I
have a trigger that's executed in SQL server and send the print to a printer?

Thanks

 

[Bruce Barker]

you are on the right track. you can use a window service, sqlagent or sql
reporting services.

-- bruce (sqlwork.com)

 

[Guest]

Hi,
Where can I find info on using sqlagent and sql reporting services for this
purpose?