Hi there,
I have records in the form of scorecards. Each scorecard has fields "type" and "score".
eg
typeA 2.3
typeB 3.3
typeA 2.0
typeC 1.9
typeB 1.1
etc
In the CrystalReport I have a group section where I show the average score of each type. I suppress the detail section and put the "average (running total)" ( Average ({ScoreCardTbl.Score}, {@card}) )in the group footer section.
Using the above example the report would show
typeA 2.15
typeB 2.2
typeC 1.9
This much is working already.
How can I suppress an instance of a group if the average score falls outside a range value?? So if I want averages greater than 2 then I don't want "typeC 1.9" to appear.
In the report section suppress fomula I have tried putting eg
Average ({ScoreCardTbl.Score}, {@cardtype}) > 2.0
but it does not work
Can anyone help? Thanks
PS, when posting a question in this forum how can I highlight a block of text, say in a different colour?