My report is based on my company standard report that require two feature :
1)Each page of the report must restrict to only a max 30 record per page, i.e. if there is 40 records, the 1st page must show record in sequential order from 1-30 and the remaining 10 appear in second page.
2)There is numbering assign to the record ( I've assigned a text box with property source =1 and its a running sum to act as a counter), so it will number 1-30 BUT for 2nd page the numbering must be reset back to 1 not continuously numbered as 31-40 which I am stuck in getting it done. The report require each batch of 30 record on each successive page is numbered 1-30.
Any solution welcome.
1)Each page of the report must restrict to only a max 30 record per page, i.e. if there is 40 records, the 1st page must show record in sequential order from 1-30 and the remaining 10 appear in second page.
2)There is numbering assign to the record ( I've assigned a text box with property source =1 and its a running sum to act as a counter), so it will number 1-30 BUT for 2nd page the numbering must be reset back to 1 not continuously numbered as 31-40 which I am stuck in getting it done. The report require each batch of 30 record on each successive page is numbered 1-30.
Any solution welcome.
