Recent content by bslaast

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

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

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.

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

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

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

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

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"

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

thanks

that is giving me a time: 57/12/10

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

Great, Thanks.

the result of the formula - 201008, 201007, 201006 etc

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