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

    Excluding Records

    Using Crystal XI I need to exclude any instance of records with TAB; thought a simple IF statement would work, but did not. My data to exclude looks like this: Zocor (25mg) TAB Synthroid (.01mg) TAB
  2. zenzabar

    Business Objects Designer vs Crystal Reports

    Simply said, does BO Designer offer similar functionalty to Crystal Reports or are these totally separate entities?
  3. zenzabar

    Group Sort Expert

    Using Crystal XI I need to show only records that have 6 or more dates of services. Sounds easy....Suggestions? John Smith Date of Discharge 7/30/09 Dates of Service 1/1/09 2/1/09 3/1/09 4/1/09 5/1/09 6/1/09 Susie Que Date of Discharge 5/1/09 Dates of service 2/3/09 4/2/09
  4. zenzabar

    Count or If formula

    This should be simple but I continue to get errors. Using Crystal XI My data looks like this (very simplistic) 47 48 49 Yes NO Yes NA YES YES Yes NO NA NO NO YES YES YES NA What I need is a formula that will count all YES...
  5. zenzabar

    Formula In Grouping Area

    I'm using Crystal XI and having difficulty creating a formula total. I've probably made this more complicated than it needs to be but because of all of the different codes, thought it was the way to build this one.I'm attempting to add up for each provider on each page their total dollar amount...
  6. zenzabar

    Record Selection

    Using XI - My data looks like this Patient# PatientName Text 12345 Tom Smith Closed by HARPER 12345 Tom Smith Closed by TURNER 12222 Anita Baker Closed by GRAHAM These are all patients of HARPER, but contain notes by various providers. In trying to...
  7. zenzabar

    Help with record selection

    I'm using CR XI. I need to report only patient records that contain services dates prior to 11/2006 but are also current patients being seen in 6/2007. I'm grouping by patient number - Patient # Date of Service 146097 3/2006 7/2006 4/2007...
  8. zenzabar

    Sorting Issue - Using Description

    Using Crystal XI Data is grouped by Provider, then by patient number. I need to refine the following data: Patient Name Date of Service Note Tina Smith 10/15/06 Voucher Note Tina Smith 10/25/06 Closed Case Tina Smith 11/05/06 Transfer Case Frank...
  9. zenzabar

    Simple field division problem

    I'm using Crystal X1 and a relative new user. Working off of an excel P&L statement worksheet imported to Crystal. Data looks like this - Actual Description YTD 100 Visits 500 125.00 Gross Revenue 10,000 100.00 Net Revenue 8,000 The formula I need to...
  10. zenzabar

    Formula or Running Total for grouping?

    My data looks like this grouped by provider initials: JLJ Patient # Appointment Date Amount 12345 4/23/07 $100.00 67890 4/23/07 $125.00 12345 4/27/07 $100.00 -------...
  11. zenzabar

    Sub Group Nightmare

    Our office is set up by specific groups of clinican that report to different supervisors. My data looks like this - Number Appointment Resource Balance 1234 3/21/07 GLR $120 456 3/21/07 JPL $50 001 3/22/07 ASA $75...
  12. zenzabar

    How to sort multiple dated records to show just the oldest date record

    My data looks like this - Service Date Patient Number Encounter Number 2/15/06 1234 6789 3/07/06 1234 8821 4/06/06 1234 9521 1/09/06 4321 1535 2/05/06 4321 7528 Wanted Results - 4/06/06...

Part and Inventory Search

Back
Top