Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: Summary forumla in header Post Reply Post New Topic
Author Message
The_Stranger
Newbie
Newbie


Joined: 28 Aug 2008
Location: United States
Online Status: Offline
Posts: 2
Quote The_Stranger Replybullet Topic: Summary forumla in header
    Posted: 18 Sep 2008 at 1:18pm
I'm trying to edit an existing report, I need to keep formatting the same. Crystal 10
 
I have a db with people, salary, age, salary deferral amount.   I have a formula '@agegroup'  
If 17">{@RealAge}>17 and {@RealAge}<30 then '18 - 29'
etc, etc for grouping people by age range.  "18 - 29' is one of the groups. I need to summarize (average) each age group's salary deferral.
 
I realize this is simple with groups and sections but I need to display all the averages in report header.  I thought this would be a simple formula: average ({@salarydeferral},(@agegroup}, '18 - 29')
 
The formula results in the error "a group condition is not allowed here".
 
How can I create a formula, for the report header, that will give me a summary for each group.
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.047 seconds.