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

    How to calculate months and years

    I am trying to create a report that calculates the age of a case....this is what I have now DateDiff ("d",{CASE_PHYSICAL_TABLE.casefiled date},CurrentDate ), however, I want the report to say after the 30th or 31st day display as "1 month and (x) days"...then after the 365th day, "1 year and (x)...
  2. yatesk

    Suppress duplicates when creating mailing labels

    I am trying to create mailing labels. I have multiple cases for one defendant. I want to generate one label for each defendant not multiple labels for each case. Can this be done? Thanks in advance for your help
  3. yatesk

    Suppress Data that Does Not Contain a Specific Criteria

    I have this report that is grouped by Case # and it returns all activity for one case, for example: Case #123 Appearance Date Courtesy Due Date Time Payment Plan Case #456 Trial Copy of Check Copy of Complaint I want to be able to say...all cases...
  4. yatesk

    Calculate Past Due Dates

    How can I calculate a past due date? Example: If a book was checked out from the library on October 1, 2006 and it was due on October 16, 2006 How can Crystal calculate the past due date which will be on October 17, 2006? I hope this makes since.
  5. yatesk

    Displaying multiple info for one record on one line...

    Is it possible to get data on one line if a record has multiple line items? Example: A defendant receives a citation and he sets up a payment plan...when I generate a report this is how it looks: Ticket Number Pay Amount Pay Date Pay Type 123123 25.00 11-25-06 CK...
  6. yatesk

    Crystal Report Format

    Is it possible to get data on one line if a record has multiple line items? Example: A defendant receives a citation and he sets up a payment plan...when I generate a report this is how it looks: Ticket Number Pay Amount Pay Date Pay Type 123123 25.00 11-25-06 CK...
  7. yatesk

    Crystal Report Format

    Is it possible to get data on one line if a record has multiple line items? Example: A defendant receives a citation and he sets up a payment plan...when I generate a report this is how it looks: Ticket Number Pay Amount Pay Date Pay Type 123123 25.00 11-25-06 CK...

Part and Inventory Search

Back
Top