I am trying to calculate Delivered Qty of an Item YearToDate. The following formula gives me the total of all Item.
If {tdsls045.ddat} in yearToDate
then Sum({tdsls045.dqua}) else 0
There is no Details Section in this report as it is a Summary.
Parameter:{Delivery Date} in {?DT_BETWEEN}...
In our previous report writer, when prompted to enter dates between we entered them as:
From Date: 2002,10,1 To Date 2002,10,31.
Is there an option for that date type in Crystal? The regular date 10/1/2002 to 10/31/2002 is ignored on my report , and all data is returned.
Thank you
Does anyone know how to format dates to work in Summary formulas?
Error "The summary / running total field could not be created"
Formula:
SUM({tdssc003.totq}, {tdssc003.cdate})
Thanks
I used this example out of a book:
Sum ({tbl_E_C_REQUISITIONS.QTY_NEEDED}, {tbl_E_C_REQUISITIONS.REQ_DATE})
But I get the Error. "The Summary/Running total Field Could not be created"
I saw a reference to a FAQ on Tek-Tips 149-182 but I could not find the FAQ.
The Result I am...
My rows have Ship dates and Ship quantities by Customer and Contract Number (Blanket Order). This is a manufacturing environment where fulfillment of orders is tracked for JIT (Just in time delivery.
A typical row will consist of the following information pulled from five tables in the query...
I am attempting to convert a Safari report to Crystal Reports CR8
The Rows in the table are like:
Customer Ship_Date Ship_Qty, etc.
I want the report to look like this:
Customer Date_1 Date_2 Date_3
XYZ Corp 10/11/02 10/12/02 10/13/02
QTY: 23 50 45...
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.