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 bkrike 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: dhv919401
  • Content: Threads
  • Order by date
  1. dhv919401

    Two aggregate functions in two rows in matrix

    I have the following: Month Subtotal District year quarter Days Sum(Days) Crewsize First(Cresize) Example: 1 2 3 Subtotal GP 2007 FirstQuarter Days 101...
  2. dhv919401

    Days in a month

    How can we get days in a month, if the month number is given. I need a function as below: DaysInAMonth(MonthNumber) = NumberofDaysInMonthNumber Thank you,
  3. dhv919401

    Sum and Average Values for a Max Summarized field

    I have the following crosstab: --------------Month------ District Year Quarter 1 2 3 Total XX 2007 FirstQuarter 6.2 6.1 5.6 Avg(6.2,6.1,5.6) YY 2007 FirstQuarter 1.1 1.3 0.4 Avg(1.1,1.3,0.4)...
  4. dhv919401

    Adding two fields and forcing a carriage return?

    The formula in the format field - Display string in a crosstab is: stringVar Result; Numbervar AfterDistribution; whileprintingrecords; AfterDistribution:= currentfieldvalue - val({@DistributionAmount}); Result:= TRIM(totext(currentfieldvalue,1))+ CHR(13) +TRIM(totext(AfterDistribution,1))...
  5. dhv919401

    Running total resetting to 0 on a new page

    I have a crosstab as follows: SUMMARY FIELD = Operatingdays year Quarter Month district1 district2 total unit1 1 2 3 unit2 14 1 15 Total 15 3 18 I created two groups in the report. 1. By...
  6. dhv919401

    Crosstab - Summary field/total of summarized field

    I have a crosstab as below: Year Quarter Month MonthTotal District1 District 2 DistrictTotal Unit1 1 18 19 Unit2 3 16 19 Total 4 34...
  7. dhv919401

    FIFO,QtyOnHand on Historical Stock Status Report

    Does anyone know how the FIFO value, Qty on hand on the Historical Stock Status is calculated? This is very important for me to know. I appreciate if anybody could share their knowledge. Thank you for your help in advance, dhv919401
  8. dhv919401

    UMQTYINB in POP10110

    Does anybody know what the field UMQTYINB in POP10110 (Purchase Order Line Detail table) contains? Is this the number outstanding either to be invoiced? Thank you for your help in advance dhv919401
  9. dhv919401

    Released Item on Purchase Order not allowing me to cancel

    On a purchase order all the items are received except one item. The line item status is released. I want to cancel this purchase order line item. When I enter the quanity in the canceled qty and save it, it saves the PO. But it is not retaining the changes and canceling that item. How do I...
  10. dhv919401

    FRx - Subscript Out of Range Error

    Hi I have a FRx report which has one tree, one row format. This is a departmental report. In the tree there is a consolidated line which is not associated with any row format. I have other departments under the consolidated line in the tree. When I run the report for individual lines, there is...

Part and Inventory Search

Back
Top