Search results for query: *

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?

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)

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.

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

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

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