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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CCH50
  • Order by date
  1. CCH50

    A double for loop

    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}) + "," +...
  2. CCH50

    A double for loop

    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...
  3. CCH50

    A double for loop

    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...
  4. CCH50

    crosstab using formulas in a sub report

    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...
  5. CCH50

    How to calculate hours for ea month when enddate spans multiple months

    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 (...
  6. CCH50

    How to calculate hours for ea month when enddate spans multiple months

    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...

Part and Inventory Search

Back
Top