on 05-22-2017 4:18 PM
Hi everyone!
I am quite new to Crystal Reports. I have a question regarding formula fields:
How can I get the maximum value of a formula field since 'it cannot be summarized'?
I looked on many forums but I don't find any successful answer, hopefully someone here will help me find a solution!
Thanks!
You will need to use a variable
assuming you may want to reset use 3 formula,
@reset// place this in group header where max is being determined and suppress
Whileprintingrecords;
Global Numbervar maxval:=0
@Eval // Place this in group footer where max is being evaluated/displayed and suppress
Whileprintingrecords;
Global Numbervar maxval;
If sum(valuefield, groupfield) > maxval then maxval:= sum(valuefield, groupfield) // replace valuefield and groupfiled with your respective field names
@display place this where you want to see the max of summarised field
Whileprintingrecords;
Global Numbervar maxval;
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.