printing asp pages

i have an asp page. a record is made from a stored procedure on SQL 2005. I
can print out 1 record then, with an rs navigation button, click to get the
next record. Each record fits on a4 (or legal) sheet. I can then print
that. But, how do I print all records insead of manually doing them, is there
a way?

Thanks in advance

Asked/Answered in IE forum:
http://social.answers.microsoft.com/...4-260d1063c140


p45542004 wrote:
> i have an asp page. a record is made from a stored procedure on SQL 2005.
> I can print out 1 record then, with an rs navigation button, click to get
> the next record. Each record fits on a4 (or legal) sheet. I can then
> print
> that. But, how do I print all records insead of manually doing them, is
> there a way?
>
> Thanks in advance

Hi,

Refer to your company's IT department to program the asp page to allow the
user to choose the number of records to be displayed on each page.
(Pagination)

MTL your stored procedure is using cursors to only move through one record
at a time. This is not the way to do this (pagination). Use Data Grids and
SqlConnectors instead. You can add a pagination control to your Datagrid to
allow uses to choose how many records to display on each page or code it to
display all records. When you display all records on the one web page, the
browser Print function will automatically split the report into pages for
your chosen paper size. You can also use css to control how the printed
report is rendered by the Printer.

You could use Crystal reports also to whip up a quick ad-hock report. An
experienced programmer should only require a few hours to do this.

Regards.

"p45542004" <> wrote in message
news:3C1FB4C5-CF6E-4DE4-A091-...
> i have an asp page. a record is made from a stored procedure on SQL 2005.
> I
> can print out 1 record then, with an rs navigation button, click to get
> the
> next record. Each record fits on a4 (or legal) sheet. I can then print
> that. But, how do I print all records insead of manually doing them, is
> there
> a way?
>
> Thanks in advance
>
>
>