0

Auto Page number in NL(Sheet)

Jet Reports Historic Posts

February 26, 2008 16:18

None

Follow

Is it possible to use Jet to create the page number automatically with the NL(Sheets) function?

For example:

If I do a NL(Sheets) for salesperson in the Customer table. Can JetReports auto create a page number for each salesperson worksheet.

On JR worksheet, it will have “Page 1” in one of the cell then on PS worksheet, it will have “Page 2” on the same cell.

Any ideas? :roll:

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts February 26, 2008 18:54

  Thanks to NAV's Integer table, generating a page number is not too difficult
  =NL("Sheets";"Integer";"=CONCATENATE(""Page "";NF(;""Number""))";"Number";"1.."&NL("CountUnique";"Customer";"Sales person"))

• 0
  
  Jet Reports Historic Posts February 27, 2008 07:14

  Hi hansfousert,
  
  Thanks for your tip!it is almost close to what i wish to achieve.
  
  Refering to the attached pic, i wish to see the salesperson code in each and every worksheet instead of the page numbers. Can it be done?

  • autopage number.jpg