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

    Show Group Header w/o Detail Records

    Vampire.... What does output represent? Is that a function or something I should know? By the way, I am using Crystal 10 in case that makes a difference on the functions.
  2. doublej0

    Show Group Header w/o Detail Records

    Here is my situation: I have essentially four tables that I am using to gather data: 1) Customer 2) Session 3) Question 4) Answer - Within the Customer table is a customer id, name, address, etc. - Within the Session table is the customer id, question id, subsection id, and answer id - Within...
  3. doublej0

    Spaces & Zeros

    I have searched and have been unable to find an answer to my questions. I have two databases (neither of which I can modify) each which has an account number that corresponds to each other. The problem is one has zeros preceding the account number (i.e. 000123456789) and the other has spaces...
  4. doublej0

    Previous Business Day with Holidays

    Okay. I am new to Crystal. I am an Access guy, but am finding Crystal much faster when reporting on thousands of records. At any rate, I am having difficulty getting the formula to work correctly. I am using Crystal 10 and pulling the date from a DB2 database (I believe). Please advise below...
  5. doublej0

    Previous Business Day with Holidays

    Thank you SMC & Ken for the help. Ken, this is exactly what I was looking for! Like SMC said, GREAT FOLLOWUP!
  6. doublej0

    Previous Business Day with Holidays

    Also, I cannot setup a table to include holidays or weekend days because I do not have access to modify the database. It needs to be strictly in CR. Thank you, John.
  7. doublej0

    Previous Business Day with Holidays

    I am creating a report which runs daily based on a previous business days date. Currently I am using the following formula: {TRANSACTION_HISTORY.POSTING_DATE} = DateTime (Year(CurrentDate), Month(CurrentDate), (Day(CurrentDate)-1), 00, 00, 00) There are two things I would like to accomplish...

Part and Inventory Search

Back
Top