Joined: 23 Mar 2010
Location: India
Online Status: Offline
Posts: 14
Topic: How to calculate sum of a field for a page Posted: 23 Mar 2010 at 4:44am
I will be having 100+ rows. And in each Page i will only show 30 row. In footer i want to show total of that 30 rows In next page the footer will have placeholder where the last page total(cary forowarded) should be shown and this current page total should be shown and sum of this these 2 and so on. How to do this in crystal reports.
Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Posted: 23 Mar 2010 at 5:32am
You need to create two insert summary values. Put one in the Page Footer. That will give you the subtotal for each page. Then put one in the Report Footer and that will give you the total for all pages on the last page.
Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Posted: 23 Mar 2010 at 7:11am
If you want to see a running total from page to page you will use a running total instead of an insert summary in the page footer section. You can use either a running total or insert summary in the report footer since that will be your final total.
Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Posted: 25 Mar 2010 at 5:43am
What type of data are you trying to total up? Is it numerical or some type of text/string field. Normally if you do not have the option to do a summary and can only do a count the data type is not numerical/currency type.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
