newbie27
asked on
Crystal Report 11 page number formula
hello experts,
i am using CR to export data into PDF, its working fine but I have a small problem in showing the page numbers on the file.
each record is coming upto 6 pages and i am showing 500 records on the file.
all i wanted to do is to set the page number for reach record between 1 and 6.
so i would say the formula would be
If (PageNumber = 6) Then
PageNumber = 1
this however did not worked...
please can someone advise?
thanks
s
i am using CR to export data into PDF, its working fine but I have a small problem in showing the page numbers on the file.
each record is coming upto 6 pages and i am showing 500 records on the file.
all i wanted to do is to set the page number for reach record between 1 and 6.
so i would say the formula would be
If (PageNumber = 6) Then
PageNumber = 1
this however did not worked...
please can someone advise?
thanks
s
ASKER
hi mlmcc
i have tried but didnt seems to make it work, please can you help me with this here?
i have attached the .rpt file, please can you make the change and attached it back?
many thanks
s
GiftCodes-MasterTheArtOf.txt
i have tried but didnt seems to make it work, please can you help me with this here?
i have attached the .rpt file, please can you make the change and attached it back?
many thanks
s
GiftCodes-MasterTheArtOf.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi mlmcc
that has worked thank you so much, only problem was that its now ending on 7 and then staring from 1 ..7
instead of desired of 1...6 range.
please can you amend and send me again?
thank you so much for your help.
James0628
thanks for your valuable information as well. much appreciated.
that has worked thank you so much, only problem was that its now ending on 7 and then staring from 1 ..7
instead of desired of 1...6 range.
please can you amend and send me again?
thank you so much for your help.
James0628
thanks for your valuable information as well. much appreciated.
ASKER
ASKER
hi mlmcc
its still doing the same, please rename the attached file to .pdf
to see what i am gettting
thanks
s
GIFT-CODES-MasterTheArtOf-2009-0.txt
its still doing the same, please rename the attached file to .pdf
to see what i am gettting
thanks
s
GIFT-CODES-MasterTheArtOf-2009-0.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks mlmcc
I have noticed the change you made on the report however for some reason I am unable to reset it when it reaches to 6. Instead its resetting back to 1 only after it reaches to page number 7.
Desired is 1 - 6
However its doing 1 - 7
Please advise
thanks
s
I have noticed the change you made on the report however for some reason I am unable to reset it when it reaches to 6. Instead its resetting back to 1 only after it reaches to page number 7.
Desired is 1 - 6
However its doing 1 - 7
Please advise
thanks
s
Since you've now accepted a solution, did you figure out that last problem, or are you still getting pages 1 - 7 instead of 1 - 6? Just checking.
James
James
Group on a unique field
In the section expert
Reset the page number after the group footer
mlmcc