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!

Show variable from one group to another

Status
Not open for further replies.

ij76

Technical User
Mar 15, 2005
25
CA
In Crystal v 9, I have a report where in Group#2 (which is grouped by severity) I have 6 varibles in this group, 2 for each sveerity level (high, medium and low), the two for each severity calculate the average of two other variables (open to close, and open to first). A couple of examples of the variables in group#2 are:

1. WhilePrintingRecords;
if {Incident_History.Severity}="3. Low Impact" then numbervar firstlow/DistinctCount ({Incident_History.IncidentID}, {@Severity Name}) else 0

2. WhilePrintingRecords;
if {Incident_History.Severity}="1. High Impact" then numbervar closehigh/DistinctCount ({Incident_History.IncidentID}, {@Severity Name}) else 0

What I need to do now is copy the totals of the above varibles in to group #1 as such:

Open to first- high medium low
Open to close- high medium low

I have created more varibles. The first set are placed in group#2 and are:

EvaluateAfter ({@Avg CloseLow});
numbervar lowclose:={@Avg CloseLow}

Then I created the formula to display the value in group#1 as:

EvaluateAfter ({@Var Low Close});
numbervar lowclose

This is working only for the last group in group#2, for the other, it shows 0.00. What am I doing wrong?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top