2. ASPRunnerPro General questions
  3. How I can print out my db with top header
This topic is locked

How I can print out my db with top header

 		10/1/2003 9:58:22 AM
ASPRunnerPro General questions
swat author

hey,

I have this very long db on the page and I would like to users to abole to print my db page with every time new page starts I would like to display first top headet with each page so they can see more clear.

Example:

// This is top hedaer

1

2

3

4

5

6

7

8

9

.... and db goes on and on.

What I need to do is just set up print code and every time after my page break I will display first this line for new page:

[color=red]Name__LastName___Phone

This then the rest of the data

and it is for every new page....
Thx
swat
Sergey Kornilov admin 10/1/2003

Hi,
I'm not sure how you do you now when to start a new page. I would recommend to print a header after each 50 rows and adjust this number after some testing.
Sergey Kornilov
swat author 10/1/2003

Hi,

I'm not sure how you do you now when to start a new page. I would recommend to print a header after each 50 rows and adjust this number after some testing.
Sergey Kornilov



ok , lets say I have db with 100 rows and when user prints the pages will be automatically breake up to couple of pages and ONLY first page has the main table (db label table) the rest of the pages dont have ... so my question is how I can set this print version that every page will start with (db label table) and will go on...
thx
swat
Sergey Kornilov admin 10/3/2003

Hi,
in your ..._list.asp file find subroutine named loopRS and insert the following bolded code somewhere in the begining of this sub:

DO  UNTIL rsData.eof OR iNumberOfRows>=nPageSize

  if iNumberOfRows mod 50 = 0 and iNumberOfRows > 0 then

      call WriteTableHeader

  end if
  '  To insure that every other one is shaded

  If iShadeTheDetail = 0 then


I hope it helps.
Sergey Kornilov