Search results for query: *

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

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

{?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)

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"

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

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

I need help with one formula (below) in snippet. I need the percent of Same day appointments by Doctor minus the canceled appointments. I think the best way to describe this is by telling you about an example I have. I have 16 appointments on my demo schedule. 2 were scheduled appointments and...

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

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

Per my clients request, they need to only report the last 4 digits of the patients SSN. In SQL I formatted it to already do the dashes between. I could change the SQL, however this SP is shared with some other reports and its only on this one form they need the SSN formatted this way, so I think...

Not sure why, but I am getting a value of DoctorsNPI when I test and I know the specialcase = 2 and the carrier equals MEDICAID IA. if {Claims_txt.SpecialCase} = 1 then "" else if {Claims_txt.SpecialCase} = 2 and {Claims_txt.InsuranceCarrierName} <> "MEDICAID IA" then...

I need to have this report "" as my value versus '0' as it is currently. I tried to add in an ELSE "" and it threw an error telling me a number was reqd. Not quite sure what I need to change this to. If {Claims_txt.OrthodonticPlacementDate} <> #01/01/1800# and...

I have three fields in my crystal report that I need to conditionally format. Field #1 - LastDental (field type is String). Per my clients request, please bold and increase font by 2 points (currently set to Arial 8 regular) when the LastDental < Today - 365 days or equals "Never". Field #2...

I have two issues in my report I hope to resolve. I think when I fix the formula, the suppress will work. I created a report titled: Date @Date is set up as follows: if {?SUMMARY} = true then "" else {ado.Date} I am getting this error: "A String is required here" and it highlights the...

In my report, I am grouping 4 levels. Group 1 - {Data. ApptStart} Group 2 - {Data.Facility} Group 3 - {Data.Resource} Group 4 - {Data.FinancialClass} On my Group 3 Header and Footer, I have on the 'Suppress (No Drill-Down)' (under the 'X-2') the following statement: {?FACGROUP} = TRUE...

In my report, I have 3 Grouping Levels: Group 1 - ApptDate Group 2 - Resource Group 3 - Financial Class In each group footer, I am doing a Distinct Count of AppointmentId. What I need to do is calculate percentages and unsure how. In my Group 2 footer, I would like to have the percentage...

In my Page footer, I have Page N or M and its currently counting each page. What I would like to do is reset the page count for each patient not as a whole like it is now. Any suggestions is appreciated.

I have a report with two grouping levels. Group 1 = Data.PaymentType Group 2 = Data.CreditCardType Per my clients request, they would like Cash and Check Payment Type on the first page and Credit Cards on a separate page. I am not sure how to do this. I have tried the "New Page Before", "New...

I need help with a formula. I would like to set ado.rvufee equal to 20% of its normal value if {ado.Mod1}, {ado.Mod2},{ado.Mod3} or {ado.Mod4} equals 80.

I am getting the following error: "The string is non-numeric" from this formula: IF ToNumber({aaUDS7;1.ObsValue}) < 7 and ToNumber({aaUDS7;1.ObsValue}) > 0 then 1 else 0 It specifically highlights this section: ToNumber({aaUDS7;1.ObsValue})