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

    IF Formula Help needed - NULLs?

    My current formula: IF {aaUDS7;1.PrenatalPatient} = 1 AND {aaUDS7;1.Age} < 15 then 1 else 0 In my dataset, PrenatalPatient is NULL on all my patients. In my report, I am expecting to see a 0; however I am not getting any value. Should I be evaluating for my NULLs somehow?
  2. Jeffs23

    Help with a Crystal Report Grouping

    In my report, I have the following 5 grouping levels: Data.Entry @GroupHeader Data.FinancialClass Data.SubProgramCode Data.PaymentType My client is needing to list in Group Footer 3 all the FinancialClass Names with the Sum of Data.Amount versus having a distinct footer for each Financial...
  3. Jeffs23

    Output to Spanish

    Please disregard, I found an old posting that helped me answer this question. http://www.tek-tips.com/viewthread.cfm?qid=1105578
  4. Jeffs23

    Output to Spanish

    Client wants an English and a Spanish Version of a form. She wants the DateTime fields on my report to pull in Spanish, not English. Is this do-able?
  5. Jeffs23

    Crystal Report Formula Assistance - find Duplicate Values

    In my report, I have the following 8 fields. What I would like to do is if the value is the same in any of these, I need it to return a phrase "Duplicate Diagnosis" else pull nothing back (NULL). Example - if the end user enters 724.02 in {Data.Diag1} and {Data.Diag4} - it would return my...
  6. Jeffs23

    Formula - dates greater then 3 yrs

    I have a field in my report called {Last Visit Date}. What I would like to do is return a phrase if this field is greater the 3 yrs old. For Example, if the date thats returned to this field is : 04/01/2008, I would like it to return a phrase like "Greater then 3 yrs old" if its NULL or under 3...

Part and Inventory Search

Back
Top