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...
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"
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.