Global Variables?

[NickEveritt]

I have field which captures the length of time in EVENTS.

There are EVENTS that are productive and non-productive, and there is an EVENT TYPE field.

Therefore I am looking, in one field to have the fields for EVENT LENGTH sum all the Productive event lengths, and then another field for all the non-productive event lengths.

Therefore I know I need to create a set of static variables for Productive Event Types and another set for Non-Productive.

Is it Global Variables I need? Is it done using an array.

Looking for help on this ASAP.

Nick

 

[synapsevampire]

This might be simpler:

Create 2 running totals, place the Event Type criteria for each in the Evaluate Use a Formula.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[NickEveritt]

OK but how do I create groups of EVENT types?

i.e. Group 1 (1,2,3) and Group 2 (4,5,6)?

 

[chris777]

Can you just group on your Event Type field? Chris
DFW Crystal User Group

http://www.dfwcug.com

 

[kenhamady]

Use a formula and group on the formula:

If {type} in 1 to 3
then "Group One"
else "Group Two" Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com