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}...
The problem I am having is that the Parameter for Date is not working. No matter what date range I enter, all data and all dates from the beginning of time display.
Any Ideas why? The format of the date shows it as YYYYMMDD.
Thanks
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...
I thank you very much for your responses. I am getting errors on the formula:
if {tdssc030.sdat} = {?SDATE} in range then {tdssc030.shpqty} else 0
I created this based on:
if date = date1 in range then value else 0 (above-help)
The error I get is that {tdssc030.sdat} doesn't result in a...
Forgive me for asking what may be an elementary question in CR. I am new to designing reports that I are not developed via views in a database.
Or, in other words, I haven’t used CR as in an IT reporting environment before.
Does the H1 in the formula you provided, connect to the F1...
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...
Let's go back to the origional Question. The cross-tab idea has a couple of draw backs because the exsisting report doesn't format well to look like the origional report.
Is there any function, function, or method that would alow me to emulate the Safari calculation that recalculates the qty...
I am now having trouble positioning the Cross Tab in a Group Area or Details. Is that posible? I need to keep the report in the same format as the Safari report.
Thanks
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.