Print Page | Close Window

Display Summary

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22631
Printed Date: 24 Apr 2024 at 5:30pm


Topic: Display Summary
Posted By: dax007
Subject: Display Summary
Date 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..


Replies:
Posted By: kevlray
Date 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.


Print Page | Close Window