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 TouchToneTommy 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: *

  1. bslaast

    Repeat group on pages

    I have a shipping label that prints a label per part number shipped. A shipment may contain several lines of the same or different part numbers so I am grouping on part number and summing the quantity. The total quantity shipped may be more than a box can fit. What I need is to start a new...
  2. bslaast

    A running total cannot refer to a print time formula

    I figured it out. I changed the Group Footer variable to: Whileprintingrecords; Global numbervar TotLess1Yr; if {@maxdate} < 365 then TotLess1Yr:= TotLess1Yr + {@extendedcost}
  3. bslaast

    A running total cannot refer to a print time formula

    That just totals the days. I need to total the costs based on the number of days. So if the number of days <365 I want a running total of those costs, >= 365 and < 730 a running total of those costs, >=730 and <1095 a running total of those costs.
  4. bslaast

    A running total cannot refer to a print time formula

    I am receiving the arror "A running total acnnot refer to print time formula" I want to get how many, the and how many days parts have been in inventory. I also want know break down the quantities and costs by <1 year in inventory, 2 years in inventory and 3+ years in inventory. I have am...
  5. bslaast

    Running Total - 1st Result Blank?

    What do you have the running total evaluating and resetting on?
  6. bslaast

    Display 2 decimal places.

    I want to display 2 decmial places I currently have: LPAD(t.full_curr_amount,10,'0') t.full_curr_amount is a number.
  7. bslaast

    Display 2 decimal places

    Pardon MY ignorance, you are right... I'm using oracle.
  8. bslaast

    Display 2 decimal places

    LPAD() adds the first character in the list to the left side of a string until the string is the specified length. Examples LPAD("APPLES", 10, ".") = "....APPLES" LPAD("APPLES", 10) = " APPLES" LPAD("APPLES", 3) = "APP"
  9. bslaast

    Display 2 decimal places

    I want to display 2 decmial places I currently have: LPAD(t.full_curr_amount,10,'0') t.full_curr_amount is a number.
  10. bslaast

    Display Current Date in mm/dd/yy format

    that is giving me a time: 57/12/10
  11. bslaast

    Display Current Date in mm/dd/yy format

    How can I display the current date formatted dd/mm/yy in a text box? I currently have: textbox.text = now() but that displays a date time format of dd/mm/yyyy hh:mm:ss
  12. bslaast

    Rolling 12 Months

    Great, Thanks.
  13. bslaast

    Rolling 12 Months

    the result of the formula - 201008, 201007, 201006 etc
  14. bslaast

    Rolling 12 Months

    How do I get the variable to display in the page header?
  15. bslaast

    Rolling 12 Months

    Thanks, LB that worked perfectly. Ian - it cannot be a date. Also, you cant sum on Date(tonumber(left({?yourparam},4)), tonumber(right({?yourparam},2)), 01)
  16. bslaast

    Rolling 12 Months

    Ian, I did use the whole formula you orignally gave me, its just the second part that is getting the error of "Too many arguments have been given to this function." So, no, Date(left({?yourparam},4), right({?yourparam},2), 01) does not work.
  17. bslaast

    Rolling 12 Months

    They are all instances of one field. The parameter retreives the first instance, and I want to calculate the prior 12 instances. I am using the parameter in a running total. I would replace the parameter with the formula in the other running totals. Month 1: {?YearPeriod} = 201008 Running...
  18. bslaast

    Rolling 12 Months

    I don't feel like I'm explaining it well. It is a report that displays account balances by month. I need a formula that would calculate the previous 12 months based off the parameter number entered. I will use the formulas in each running total for every month
  19. bslaast

    Rolling 12 Months

    Group 1: {Account.Account} Group 2: {Department.Descriptoin} Running total in GF2: {ACCOUNTING_BALANCE\.YEAR_PERIOD_KEY} = {?YearPeriod} If the user enters 201008 for {?YearPeriod}: 201008 201007 201006 201005 201004...to 200908 1000 500 699 1200 987 What I want is the user...

Part and Inventory Search

Back
Top