Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Display Summary Post Reply Post New Topic
Author Message
dax007
Newbie
Newbie


Joined: 17 May 2018
Online Status: Offline
Posts: 25
Quote dax007 Replybullet Topic: Display Summary
    Posted: 18 Jun 2018 at 8:38am
Hello,
How do I display summary on Page header? For example I have following report



AAA
A111       20
A112       10
A113       40
Total AAA   70
BBB
B111       58
B112       30
Total BBB   88
NET        (18)

Now I would like to display this NET (Total BBB-Total AAA) on my report page header.
For this I have formula (@Net) define, so when I drag and drop this net formula (@Net) in page header section it just show me a blank. But if I drop the same net formula (@Net) in the Page Footer area, it displays correct values [(18)]. So the formula is correct but it seems when i drop it in pager header area, Report does not know about those fields? and that's the reason it gives me blank?
Can somebody please help as how do I make this work?

Thanks again..
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 18 Jun 2018 at 11:35am
You have to understand the order of operations for Crystal Reports.  Realistic speaking, at the page header, you have not  read any values for that page yet, thus no data.

Try putting a WhilePrintingRecords in the formula (before any calculations. If that does not work.  You may have to use a sub-report to do the calculation and put the sub-report in the report header.
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.027 seconds.