Joined: 17 May 2018
Online Status: Offline
Posts: 25
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?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
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.
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
