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}) + ","
+...
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...
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...
I am trying to create a crosstab, using totaled workorder hours, then using a manual running total to get monthly hours for each piece of equipment.I am using 2 string arrays to get the data to the subreport.
This one collects the equipment;
whileprintingRecords;
stringvar strEquipmentName...
I've tried this but I don't seem to get the correct hrs.
If mth=emth then //If EOM in July
T_JulHrs:= datediff("n", {WFR_ESR_ACTIONS.START_DT},{WFR_ESR_ACTIONS.STOP_DT})/60
else if emth = mth + 1 Then// If EOM in Aug
(...
I have created a report that returns workorders for the last year from current date, it is grouped by location, equipment and month. I need to provide the hours and equipment availibility by month. The Workorder may have multiple actions, an action can start/end in same month or span months. I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.