Search results for query: *

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

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

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

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

Crystal XI Here's the start of my formula - if GroupName ({vwBatchPrintChgs.Procedure_Code}) = ["90806FP"] then Count ({vwBatchPrintChgs.Procedure_Code}, {vwBatchPrintChgs.Procedure_Code})*50.00 My problem (my preceived problem) is that I have up to 5 codes to add to the @Total amount with...

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

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

Thanks, that works extremely well!

Thanks for your help. The formula will only show true in the detail line formula for the last entry. so the records retuned look like this: False 26590 10/15/2006 False 26590 10/22/2006 False 26590 11/05/2006 False 26590 11/18/2006...

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

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

You have saved me another step; thanks so much for all of your assistance!

I see a problem...In the description column because this was imported from excel, the net revenue is a total and is indented one space before the number actually starts. If I go back to the original spreadsheet in excel and set the columns to all left align, bring the table back into crystal...

OK, I'm only looking at the formula in the report footer. Problem is with MyRev as it returns a value of 0; while Myvists does return the correct number.

Thanks so much for continuing to work on this with me. I changed the formula in the detail area to your suggestion which makes more logical sense, but now it's returning a 0 value. It's so close!

Now I have made the change to the detail area formula to be: whileprintingrecords; numbervar MyVisits; numbervar MyRev; If {'Clinic_Networkwo_'.DESCRIPTION} = "Visits" then MyVisits:= {'Clinic_Networkwo_'.ACTUAL} else if {'Clinic_Networkwo_'.DESCRIPTION} = "Net Revenue" then MyRev:=...

Thanks for the help with this formula, however I still have a small snag. I'm not getting the desired result and ending up with the formula returning the original value of visits. This is what my formula placed into the detail area looks like. I have not put any grouping in place for the...

OK, I'm following, but not quite the result I need. What should be the result from dividing the net revenue dollar amount ($100.00) from the visit number (100) so $100/100. I will need to do this for both the actual side and for the YTD side in seperate formulas. Thanks

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

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