Print Page | Close Window

report summary

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19579
Printed Date: 03 May 2025 at 6:13am


Topic: report summary
Posted By: taniarto
Subject: report summary
Date Posted: 27 May 2013 at 5:25pm
Dear All,
I have an invoice report it contain like this :

Number         Item              Qty     Price         Total
1            Sugar                       1    300          300
2            butter                      2    200           400
so on

Total                                                          1.500

the record taking 2 pages of the report, every pages of the report is summing the record. For example the page number 1 is has own summary and the latest page show grand total of the summary. I put the summary formula on the page footer.  My question is could it only show on the latest of page?(the summary) the first only show zero value and it all show only on the latest page..

thanks



Replies:
Posted By: taniarto
Date Posted: 29 May 2013 at 5:48pm
according to the problem I just got an idea..
I want to make a formula. The scenario is if it is the latest page so the summary appear otherwise the value is 0 (zero). The condition is taking from page number..does anyone can tell me how? or suggestion?

thanks


Posted By: Gurbs
Date Posted: 02 Oct 2013 at 12:22am
not quite sure what you mean. If you want to create your own formula, you could use the following formula.

if pagenumber <> totalpagecount then 0 else {your own summary}




Print Page | Close Window