I am trying to generate a serial # for a report I created for preprinted time sheets.
I have the parameter asking the total # of timesheets needed but I cannot figure out how to sequentially generate the serial # using the entered value.
The format of the number is: 2008-AAA-000x (where x starts at 1 and ends at given number. So if I enter 4, I should have the following:
2008-AAA-0001
2008-AAA-0002
2008-AAA-0003
2008-AAA-0004
The formula I have only puts 0001 at the end and prints the same thing on all 4 pages.
Any suggestions?