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 bkrike 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: Robin99
  • Content: Threads
  • Order by date
  1. Robin99

    Date formula to first of next month

    Hi, CRv10 on Enterprise Data source: Encore/Impact 6.0 (ODBC) Field Name: {ARINVOICE.InvoiceDate} Field type: Date Background: I'm writing a "welcome letter" (form letter) to send to our customers who buy our warranty support services. The warranty start date is always the 1st day of the...
  2. Robin99

    CEv10 Business Users & Setting Report Parameters

    CRv10 on CEv10 Data source: Encore/Impact 6.0 (ODBC) When business users run (schedule) reports on CE, they are not presented with a "Parameters" dialog box asking them to make their choices (date range, invoice number, etc.). I know the "Customize Your Options" pick list is there and the...
  3. Robin99

    Splitting a String for two fields

    Hello, Using CRv10 Data Source: Excel Data Type: String I'm trying to show the date of manufacture & the manufacturer of our product using a formula based on their 10 digit serial numbers. Not sure how to get what I'm after though... Serial Example: 0436040002 the 1st & 2nd digits represent...
  4. Robin99

    Number to Time Conversion

    CR Version 7 DB = Encore/Impact/Syspro 5.1 ODBC Hello, I'm working with a Transaction Time field that returns time values like: 8311576 and 10125494. CR Field Type is: Number How can I convert the above values into an HH:MM format? Thanks as always for the help. Robin
  5. Robin99

    Number to Date Conversion

    Hi, Using CR7 with Impact/Encore 5.1 ODBC Today I'm writing a bookings report. When I pull a "transaction date" field from our DB, it produces date values in the following format: 20011012 20030707 20040205 However, my desired output is mm/dd/yy. The data type for this field in CR is...
  6. Robin99

    calculating line item discounts for extended line price

    Hi, I'm writing an invoice report (Crystal 7.0) and I'm running into problems calculating the line item discount and arriving at the correct extended amount. My discount field returns a value of "60.00" for a 60% discount - and I think that's one of my problems. Formula Example: if...
  7. Robin99

    A good question ! (Groupwise)

    I want to send an email to Groupwise user. But I want to do that when I click a button in my application (Java). After that I would like to be able to know if the email has been read by destination. Is there any Groupwise API to do that ? Thanks Robin robin.tremblay@cognicase.ca

Part and Inventory Search

Back
Top