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

  1. cyreports

    SQL Query Help - Calculate Collection %

    I currently have collection % calculated as: ( ( SUM(pvpa.insPayment) + SUM(pvpa.patPayment) ) / dbo.cusIsZero(SUM(pvp.TotalFee) * 100, 1) ) AS CollectedAvg, What I have to have is the sum of the payments divided by last months sum of Total Fee. Any assistance is deeply appreciated!! SET...
  2. cyreports

    Set fixed width

    I am using crystal reports ver 9. I am using a fixed font of courier new font size 9. I need to do a fixed length report that contains fields of various character widths. Is it possible to set width sizes on my report to be exactly the number of characters I need. For example, I need 'Employee...
  3. cyreports

    Help with a formula

    Brian - Thanks!
  4. cyreports

    Help with a formula

    {?DATE2} is currently set up as a String. I need it to pull the date as yyyyMMdd - is this do-able somehow? "05" & LEFT({?BATCHHEADER} & SPACE(30),30) & CSTR(CurrentDate,"yyyyMMdd") & {?DATE2} & LEFT({?JOURNAL} + SPACE(10),10)
  5. cyreports

    Best way to write formula

    What would be the best way to write this formula? It the SFFormOfDeclaration = "W-2" or "1099" then I want an "X" else nothing. Would I just want to use multiple IF THEN Statments or could I use a IN Statement?? IF {rpPatProfile.SFFormOfDeclaration} = "W-2" THEN "X"
  6. cyreports

    Help with formula to suppress correctly

    I am needing some assistance with how my report is currently returning results. I currently have 3 grouping levels: Group 1: Data.Code Group 2: Data.ProcCode Group 3: Data.NotesType What I am having issues with is when I have more then 1 ProcCode. If I have more than 1 ProcCode, I am getting...
  7. cyreports

    Suppress a field if another field does not exist. Crystal Reports 11

    I am using Crystal Reports 11 and I need to suppress a field if another field does not exist. I am trying to use this on my field and its displaying still. Trim ({Claims_txt.Proc6CPTCode}) = "" If Proc6CPTCode does not exist, I need my field to not appear. It continues to populate a 0.00 in...
  8. cyreports

    Help calculate a percentage with a formula

    Please disregard the last question. I created another formula to set to 0 if null and inserted that into this formula. Thanks to all for the help.
  9. cyreports

    Help calculate a percentage with a formula

    ...{#Scheduled Doctor} - {#Scheduled Doctor New}. If I have nothing in {#Scheduled Doctor New} I am not getting a % back, only a blank space. Can I have it minus zero if null here to give me back a %? ({#Scheduled Doctor} - {#Scheduled Doctor New}) / ({#Scheduled Doctor} + {#Same Day Doctor})...
  10. cyreports

    Help calculate a percentage with a formula

    They show a 1 if they are true and if they are null they show a 0. The running totals I did sum them up and reset on the group.
  11. cyreports

    Help calculate a percentage with a formula

    Do you have some field that identifies an appointment as cancelled? Yes. Each of the canceled appointments are set up as Running Totals that sum that status and resets on the group for Doctor, Facility and Day. The specific fields are: [ado.Seen] for my Completed Appointments [ado.No Show...
  12. cyreports

    Help calculate a percentage with a formula

    ...+ {#No Show Doctor} + {#Clinic CX Doctor} + {#Completed Appts Doctor} + {#Patient CX Doctor})) / ({#Scheduled Doctor} + {#Same Day Doctor}) * 100 I thought I could take same logic and create a formula for the Scheduled Appts and did this: ({#Scheduled Doctor} - ({#Reschedule Doctor} +...
  13. cyreports

    Help calculate a percentage with a formula

    ...as I need): if ({#Scheduled Doctor} + {#Same Day Doctor}) <> 0 then ( ({#Scheduled Doctor} + {#Same Day Doctor}) / ( {#Same Day Doctor} - ({#Reschedule Doctor} + {#Patient Left Doctor} + {#No Show Doctor} + {#Clinic CX Doctor} + {#Completed Appts Doctor} + {#Patient CX Doctor} ) ))*100...
  14. cyreports

    Suppress Formulas

    Thanks to all that helped to get the issue resolved! Thanks again!
  15. cyreports

    Suppress Formulas

    Turkbear, I am not getting back my patients that have English as their language. I think this one will be the tricky one.
  16. cyreports

    Suppress Formulas

    In my report, I have 3 detail sections. On Details A, I have a English letter. On Details B, I have a Spanish letter. On Details C, I have a Somali letter. What I need is to pull the letter based on the patients language. My field name is {data.PrefLang}. If the patient has a value not...
  17. cyreports

    A string is required here Error in Formula

    {rpPatProfile.WorkersComp} is a number. I am using crystal 9. It must be coming from somewhere else then. If I have that as my detail suppress statement, shouldn't other formulas in that section matter since I am suppressing it overall? For example - in that one detail section i have close to...
  18. cyreports

    A string is required here Error in Formula

    I am using this unexpecting value on my Details band to suppress if my paient has work comp. I am getting a string is required here error when it executes in my database. When I check the formula it say no errors but wont work in my db. Can I cast or change this somehow...
  19. cyreports

    Help with a formula

    Ian, Thank you so much for the hand. I really appreciate you.
  20. cyreports

    Help with a formula

    I apologize for not stating my issue correctly. Right now, due to the SQL my SSN would populate as such: 455-55-1234 What I need it to look like is: XXX-XX-1234 I am getting the numbers now for the First 5.

Part and Inventory Search

Back
Top