Question about , report pages . I have a field in my report that requires no decimal places but on the other hand my global summary needs to have 2 decimal places not ; 5.33333 etc.... . Does anyone know how this can be changed without the field data that is being totaled changing . I know I can change it as view custome with strValue = FormatNumber(strValue,0) but this also changes the global summary that I need to be an interger with 2 decimal places ex.... 5.33. not 53333333 . It seems whatever you query the field as is also the global summary.
ex. field
5
9
3
global average = 5.70 instead of 5.666666666666666
is what I'm trying to accomplish
