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

    Error: This Field Cannot be Summarized - Crystal 11

    I'm getting the error message "This field cannot be summarized" for a field called {@VOIDEDPROC} in a formula called "Maximum" . The following are my formulas: VoidedProc if isnull ({PatientVisitProcs.Voided}) then 1 else IF {PatientVisitProcs.Voided} = 1 then (if cdate...
  2. GayleC

    Consolidate multiple data into one row Crystal 11

    I’m working in Crystal 11. Below is a sample of my data that is grouped by VisitID I need the multiple RCodes to be reported in total in the RCodeSumm column. I used the following formula: stringvar ReasonCode; if RecordNumber=1 then ReasonCode:=...
  3. GayleC

    Select the 2nd date from a list of dates

    I need to capture the 2nd time, where it exists, a claim was filed to a patients primary insurance for a specific visit, unless the 2nd time occurs after a claim has been filed to the patients secondary insurance. The number of dates for filed claims can range anywhere from 1 to infinity. The...
  4. GayleC

    Two Static Date Parameters where only one can be selected

    Hello, I'm working in Crystal XI and have been asked to write a report which contains two separate dates. A Date of Service (DOS) and an Entry Date. The end user wants the report to be run by either the DOS or the Entry date but not both. For example run the report for a DOS of 5/1/15...
  5. GayleC

    Combining components of multiple transactions from the same table into one row on a report

    I am trying to write a flat file report that calls for components of different transactions from the same table to be reported on the same row in a report. I am working in Crystal XI. The transactions I am trying to combine from the same table is the "Amount" with a TransactionType of "P" and...
  6. GayleC

    Selection query for last payment date

    I am trying to create a report that selects the last date that a non-zero payment was posted against an account. If there was no payment, the result should be a blank field. The date is listed in a batch table which is linked back to the account through several tables. I’ve created the...
  7. GayleC

    Converting String to Date and Calculating Date Lag - Crystal XI

    I have a string that contains a date in the format of "phs cey 070311 phsbord" I've written the following formula entitled "ManualDateConversion" to extract the date portion from the string: Mid ({Batch.Name},9,6) The formula returns 070311 I'm then using the following formula entitled...
  8. GayleC

    Sql expresion pulling data from records excluded by Record Selection

    Crystal XI I’m writing a report that includes a field that calculates the difference between two dates. My data contains multiple rows of data related to the same patient encounter with different Charge Entry Dates, I want to pull only data with a certain batch name, then apply the earliest...

Part and Inventory Search

Back
Top