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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. cgordonn

    URGENT HELP: Supress A Zero Value

    Thanks DGILLZ, that seemed to have done the trick. CGordonn
  2. cgordonn

    URGENT HELP: Supress A Zero Value

    Hi gang, Having a bit of a problem with the suppression of zero values oin CR 8.5. I have the following 3 fields in my detail... {@DISBURSEMENTS} {@RECEIPTS} {@AMOUNTDUE} (this formula is {@Disbursement}-{@Receipts}) I have subtotals for these 3 fields in my group header, and have the details...
  3. cgordonn

    CR 8.5: "ALL" Parameter on a Number Field

    Thanks vampire. The first option worked perfectly. Regards, CGordonn
  4. cgordonn

    CR 8.5: "ALL" Parameter on a Number Field

    Hello All, Quick question. I have a parameter based on a number field in the database {tablename.filenum}. The user would like to be able to enter a particular file nnumber, or "ALL" to return all file numbers. How do I get an "ALL" type selection to work with a number...
  5. cgordonn

    Aging: Current Date & Previous Dates

    Thanks synapsevampire for the feedback. I write all my reports in CR 8.5 Pro. Let me once again clarify what I am attempting to accomplish. Most of the other aging reports that I have worked on did the aging based on CURRENTDATE. In this new report I am working on, I need to age based on a...
  6. cgordonn

    Aging: Current Date & Previous Dates

    I am once again reaching out to the forum users here. I have a report where I need to do some aging calculations. The aging will be based on {currentdate} minus one of my database fields {saildate}. The report has 3 parameters to enter prior to running, these are... {?CompanyNo)...
  7. cgordonn

    URGENT: Funky String to Date Issue

    Awesome...it worked. Thanks Vampire. Regards, CGordonn
  8. cgordonn

    URGENT: Funky String to Date Issue

    I am working with a database that stores the Month, Day and Year of a date in 3 separate number fields. I.E... Field 1:{month} 1.00, 2.00, 12.00 etc... Field 2:{day} 1.00, 2.00, 31.00 etc Field 3:{year} 2,000.00, 2,001.00, etc I have been able to stip the zeros and commas out and convert the...
  9. cgordonn

    Number to Date

    I have searched the forums for information on converting a number date type to a date, but have not found a solution for my problem. The database I am working with stores the date as follows, or at least this is how CR 8.5 shows the number date in the report... Example 1 Actual Date: 09/24/1985...

Part and Inventory Search

Back
Top