Get report data into a web page and print multiple pages

[jbonifacejr]

Yesterday I got the bad news that I can't open an instance of Access,
run a report, then close Access over ASP. So, I need to come up with an
alternative so that I can execute printing of "orders" over an ASP
page.

I know how to open the db connection, get the data I want into a table,
and I can present the data on the screen. The problem is that I want to
print out "orders" on individual pieces of paper. I can present the
orders on the screen separated by hr tags. I don't know what kind of
tags or markup to put on the page that will tell the printer that the
next segment of screen data should be printed to a new page.

Can someone tell me how to do that?

Thanks

[jbonifacejr]

Hate to answer my own question, but I think I've found it here

http://www.htmlgoodies.com/beyond/cs...le.php/3470341

Looks like all I need to do is create the asp page and display my data,
and when I walk the recordset put one of the described page break
commands either before or after each record.

[Lyle Fairfield]

"jbonifacejr" <jb*********@hotmail.com> wrote in
news:11**********************@u72g2000cwu.googlegr oups.com:

Yesterday I got the bad news that I can't open an instance of Access,
run a report, then close Access over ASP. So, I need to come up with an
alternative so that I can execute printing of "orders" over an ASP
page.

I know how to open the db connection, get the data I want into a table,
and I can present the data on the screen. The problem is that I want to
print out "orders" on individual pieces of paper. I can present the
orders on the screen separated by hr tags. I don't know what kind of
tags or markup to put on the page that will tell the printer that the
next segment of screen data should be printed to a new page.

Can someone tell me how to do that?

Thanks

http://msdn.microsoft.com/workshop/a...perties/pagebr
eakbefore.asp
--
Lyle Fairfield