Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RppDuck
  • Content: Threads
  • Order by date
  1. RppDuck

    Year to Date Sum

    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}...
  2. RppDuck

    Parameter Dates Not Working

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

    Date in Sum Formula

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

    The Summary/Running total Field Could not be created

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

    I need to report data from ROWS in Columns without Pivot tables

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

    Recalculate a field based on a different date on the report

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

Part and Inventory Search

Back
Top