Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-25 : 08:26:58
|
| Joseph writes "I am doing a complex payroll for a compensation system.I have a stored procedure which generatesd the individual payroll outpout which I output to an ASP page.There are about 65 individual payrolls.I want to loop through all payrolls (loop through the payroll employee_Id) and send them to directly to the printer.Any suggestions would be greatly appreciated.Thanks ..... Joseph LucierPS the email is real" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-25 : 08:29:33
|
| Sending the output of an ASP page directly to a printer is not really a database issue, nor is there any easy way of doing it from the database directly. You can include some client-side JavaScript in your ASP page that automatically prints the page when it's opened, but it will pop up the Print dialog box.You might have better luck on some ASP sites:www.4guysfromrolla.comwww.asp101.comwww.15seconds.comwww.learnasp.comwww.aspalliance.comBut I'm pretty sure you won't be able to circumvent the dialog box. Sorry. |
 |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-06-25 : 08:32:42
|
| You can use something like Crystal Reports to print them automatically. Plus you can get good formatting support. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-25 : 08:39:21
|
 ...forgot about Crystal Reports...my bad |
|
|
|
|
|
|
Output Stored Procs results to the printer