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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing values from a Forumla field to another field. 1

Status
Not open for further replies.

MattRichardsUK

Technical User
Dec 11, 2000
22
GB
I,m trying to pass the Maximum Value from a Running total, to a text box to display on my report.
My Formulae are as follows:

//RunTotal1
// Goes in group header for Agent Screen Name (group header #2a)
WhilePrintingRecords;
NumberVar Sessions:=0

//RunTotal2
//goes in detail section
WhilePrintingRecords;
IF {msi_tstamp.screen_name} = {msi_tstamp.rep_screen_name} then
NumberVar Sessions:= Sessions + 0
ELSE
NumberVar Sessions := Sessions + 1;

I want the maximum value 'RunTotal2' to be displayed in the text box. The Formula editor will not allow me to create a new formula field, displaying the error message.
"The summary / running total field could not be created"

Any suggestions?
 
You can't do summaries of fields that are "whileprintingrecords".

You can create another variable that you update with the current variable when it is higher than the previously stored highest variable. Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top