Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CRXI - Maximum of Formula

Status
Not open for further replies.

jannoth

MIS
Oct 9, 2007
60
CA
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
 
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
 
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 :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top