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 Chris 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: *

  • Users: KZOG
  • Order by date
  1. KZOG

    Combine two fields into one parameter

    I am on version 8.5. I have two fields. Employee Last Name field and an Employee First Name field. I would like to create one parameter that will allow the user to select the entire name field (last name + first name) instead of having to select the first name parameter and then having to...
  2. KZOG

    How can I group specific values using the same field?

    How can I goup specific values within a field. Here is an example: field = proc_code group 36.01 and 36.02 only then group 36.01 and 36.07 only then group 36.01 and 36.05 only. How would I go about grouping on a single report?
  3. KZOG

    How can I subtract a date/time field?

    I upgraded to Crystal 8.5. Thanks it worked! Yippie!
  4. KZOG

    How can I subtract a date/time field?

    I created a formula using this logic: DTSToTimeString(DateTimeDiff({MPVisit.Created},{ADT_PatientVisit.AdmitDateTime})) and it returned this: 1 Hour(s), 8 minute(s), 55 second(s) ----this is good but I want to convert it to 1:08:55. How can I do this?
  5. KZOG

    How can I subtract a date/time field?

    Unfortunately, I cannot use the DateDiff function because I'm on Crystal 7.0. Do you have any other suggestions?
  6. KZOG

    How can I subtract a date/time field?

    I know this sounds kinda like a dumb question, but here is the deal. I have two date/time fields. This is my formula ({ADT_PatientVisit.AdmitDateTime} - {MPVisit.DateTime}) The data looks like this (example): MPVisit DateTime AdmitDateTime DateTimeDiff 9/22/03 9:58AM...
  7. KZOG

    Grand Total Count for my report is inaccurate

    dgillz, It worked! Thanks!!! -kzog
  8. KZOG

    Grand Total Count for my report is inaccurate

    Here is my example: CPT Code description 1234 xyz 4567 qrs 7895 tuv 1234 xyz Grand Total = 15 as you can see I show only 4 codes. I have the detail section suppressed. I have two groups 1. Group Header #1 = MPVisit.Acct# - A 2. Group Header #2 =...
  9. KZOG

    Grand Total Count for my report is inaccurate

    I used the select expert to exclude a code that starts with "9928". That worked out fine. Then I ran my report and selected the code field to perform a Grand Total Count. For some reason the the total count is higher than what I have counted in the report? Does anybody have any...

Part and Inventory Search

Back
Top