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

    Crop Tool flipping image in PSP x3

    New to Paintshop. Must have inadvertently changed a setting. When I import an image, select the Crop tool icon and then double click to accept the cropped area, my image flips. Not seeing where to correct this. Thanks.
  2. ehk

    Assistance with Correct Link Option/Record Selection

    Crystal XI with Advantage Database Server Two tables: Batch.dbf and Ledger.dbf have a one to many relationship Batch.dbf contains Batches opened to track Insurance Payments in a doctor's office. Ledger.dbf contains records for all ledger transactions. Only Insurance Payments are posted into a...
  3. ehk

    SQL statement and report processing speed

    Crystal 8.5 Advantage SQL I’m designing a daily appointment schedule printout for medical office mgmt software. Primary table is APPT.DBF with left outer joins to PATIENT.DBF (for patient name and date of birth) and APPTCMTS (for appointment comments). Parameters are Appointment Date...
  4. ehk

    Start/End Time Parameters

    Crystal 8.5 Data Source: Advantage SQL Report: Appointment Statistics I would like to add Start and End Time parameters to this report. These would be based upon field {Appt.Time} which is String-5. Data is stored in military time as HH:MM. Should my parameters be number or time? Unsure...
  5. ehk

    Appointment Report with 4 Source Tables

    Crystal 8.5 Data Source: Advantage SQL I'm designing Appointment Scheduler output for medical offices. Primary table is APPT.DBF for Date, Time, Appt Reason. Have linked by Patient ID with equal join to PATIENT.DBF to display patient name and date of birth. I would like to display data from 2...
  6. ehk

    Time Clock Report and Displaying Minutes

    Crystal 8.5 and Advantage SQL Time Clock table has 4-sets of In/Out string fields we have converted using IsTime/CDateTime formula. These values display in the report in military time "8:58/19:53". Then we've calculated the difference between each In/Out using Datediff("n")formulas and added...
  7. ehk

    String field containing characters 0-9 only

    Crystal 8.5 Datasource: Advantage SQL Can you please tell me how to select records that contain only numbers within the field {Payldgr.Invoice} which is String/10? I would like to exclude any invoices containing characters other than 0-9. Valid records can contain any combination of numbers in...
  8. ehk

    Error 539 Invalid Date reporting previous month end

    CR 8.5 Advantage SQL Errors running financial reports for previous month end when prior month has 31 days and current month < 31. Daysheet - for 03/31/05 and print date is 04/01/05 Error 539 - Error in file Invalid Date Print Date.Set Day <PESetPrintDate> thanks - Ellen
  9. ehk

    Can subreport fields be used to create groups on main?

    Crystal 8.5 Datasource: Advantage SQL Application: Medical office management software Creating an A/P Check Log for patient refund payments. Main report has A/P tables to report check information. Invoice number assigned to each refund check is equal to a patient’s account number. Linked a...
  10. ehk

    Maximum Last Sold Date for Stale Inventory Report

    Crystal Version: 8.5 Datasource: Advantage SQL I’m writing a Stale Inventory report that is using a parameter for Days Stale based upon a string field {Sales.DateSold} @NoSale – if no Sales history, calculates Days Stale based upon Received Date DateDiff ("d",{@RecToDate} ,CurrentDate )...
  11. ehk

    Conditionally Suppress a Group Footer

    Crystal 8.5.0.217 - Data Source Advantage SQL 1st post...apologies if format of my question is incorrect Report calculates response statistics from our call center. I have a Group for Client Issue Type and would like to display summaries in Group Footer for a single type - 'K'. If...

Part and Inventory Search

Back
Top