I have did crystal report in which i have shown total of each page at its page footer. Now if suppose any report contains 15 records and each page shows 6 records hence 1st page shows 6 rows 2nd page shows next 6 then 3rd page shows remaining 3 rows.
Now when i shows total of any field at page footer on 3rd page after 3 records it shows some gap and then at page footer gives result for total.
So to avoid such result or this gap what o do?
If i have put total field at the detail section then total field will be repeated. so is there any method to avoid this repetition? so as to total should be seen only once and at the end of records of each page.
what would be a solution?