CRXI - Maximum of Formula

[jannoth]

Hi,

I'm trying to determine the highest number of concurrent users of a system (grouped by date). A formula evaluates each log entry and correctly displays a counter but the list is be huge so I'd love a summary for each day (eg Maximum of the formula).

I'm using Whilereadingrecords for the counter formula as without it the count is waay off.

Nothing seems to be allowed by CR and I can't figure out a work around - can someone please (gently) help?

Outline of report:

GF1 - DATE plus hidden RESET of @ConcurrentUsers
D - Username, LoggedActionType, @ConcurrentUsers counter

GF1 is where I need a summary.

Thanks in advance,

J

 

[IanWaterman]

What is in formula @concurrentusers

You can use a variable, needs 3 formulae

place this in group header
@reset
Whileprintingrecords;
global numbervar concurrentusersvar:= 0

Place this in details and make font white
@Eval
Whileprintingrecords;
global numbervar concurrentusersvar;

if @concurrentusers > concurrentusersvar then concurrentusersvar:= @concurrentusers

Place this in footer
@display
Whileprintingrecords;
global numbervar concurrentusersvar;

Ian

 

[jannoth]

Thanks Ian,

Your approach helped perfectly! I was doing it almost correctly but your slightly different approach helped to highlight my error.

Thank you, thank you, thank you