Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: report summary Post Reply Post New Topic
Author Message
taniarto
Groupie
Groupie
Avatar

Joined: 15 Oct 2010
Online Status: Offline
Posts: 52
Quote taniarto Replybullet Topic: report summary
    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
IP IP Logged
taniarto
Groupie
Groupie
Avatar

Joined: 15 Oct 2010
Online Status: Offline
Posts: 52
Quote taniarto Replybullet 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
IP IP Logged
Gurbs
Senior Member
Senior Member
Avatar

Joined: 16 Feb 2012
Location: Ireland
Online Status: Offline
Posts: 216
Quote Gurbs Replybullet 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}

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.