A double for loop

[CCH50]

I have 2 variables, one containing a list of equipment, the other containing monthly hours("," seperating each entry). How can I get them out to variables
ie.
Equipment1, Janhrs, febhrs, marhrs,aprhrs,mayhrs,junhrs,julhrs,aughrs,sephrs,octhrs,novhrs,dechrs, equipment2, janhrs,febhrs........etc.

Can i use a double for loop, or do while. Not sure how to do this.

Thanks for your assistance.
CCH

 

[lbass]

This is very unclear. I can't tell what you are working with, what you are trying to do, why, or what your intended end result is.

-LB

 

[CCH50]

I'm trying to insert a xcelius dashboard in a crystal report, the example I found loaded the info into to "," seperated variables and passed that to the xlf dashboard. Needless to say the example was a simple demonstration. I've created the variables in Crystal reports which collects the data
stringvar equip; it collects all the equipment ( equipment1,equipment2, equipment3,)... etc .The second is a numvar
monthHrs ( 100.23,45,555.45,) etc this represents the hours for each month for each equipment, (12 numbers for each piece of equipment)So i need a way to extract the first piece of equipment and then the 12 months of hours for each and then pass that to the dashboard.
Hope this better explains the problem.
Thanks CCH

 

[lbass]

I'm not familiar with Xcelius so don't know what Xcelius requres. If you want help with extracting form your existing formula(s), you will have to copy the formula contents into the thread.

-LB

 

[CCH50]

Here is how I am collecting the data, I have no clue on how to get it back out into variables for each equipment (with 12 months of hours).

whileprintingrecords;
stringvar Sum_mthHrs;
Sum_mthHrs := Sum_mthHrs + totext({@JanHrs_Display}) + ","
+ totext({@FebHrs_Display}) + ","
+ totext({@MarHrs_Display}) + ","
+ totext({@AprHrs_Display})+ ","
+ totext({@MayHrs_Display}) + ","
+ totext({@JunHrs_Display}) + ","
+ totext({@JulHrs_Display}) + ","
+ totext({@AugHrs_Display}) + ","
+ totext({@SepHrs_Display}) + ","
+ totext({@OctHrs_Display}) + ","
+ totext({@NovHrs_Display}) + ","
+ totext({@DecHrs_Display})+ ",";


whileprintingRecords;
stringvar strEquipmentName;
strEquipmentName:= strEquipmentName +{WFR_SYSTEMS.SYSTEM_DESCR} + ",";
Here is the link I found to imbed a dashboard in Crystal Reports

http://myxcelsius.com/2009/04/07/connecting-crystal-reports-data-to-xcelsius-charts/

Thanks Ches

 

[lbass]

Sorry, but I'm not willing to watch a video on this, and I'm not sure after all what you would need to do the chart.

-LB