Recent content by ehk

Yes, that's displayed when I select the icon.

This has corrected itself. No clue how.

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.

Thanks, LB {Ledger.PostDate} can be >= {Batch.OpenDate} Does this rule out linking the Batch and Ledger tables by that field? If so, should linking by BtchUnique only give me the same results? Thanks.

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

{APPT.DATE}={?DATE} and UPPERCASE({APPT.LOCATION}) like {?LOCATION} and UPPERCASE({APPT.DOCTOR}) like {?ID} AND UPPERCASE({APPT.DEPT}) like{?DEPT} AND NOT({APPT.APPTSTAT} IN{?FILTER})

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

When I run the report through our application, the window where I choose my parameters shows the following defaults: Start Date: 11/28/2005 End Date: 11/28/2005 Start Time: 11/28/2005 End Time: 11/28/2005 I just ran the preview in Crystal and it is showing the correct defaults. I will...

That's exactly what I have and my parameters appear as 11/28/2005. I believe the parameters are set properly (Time); my default values are appearing in HH:MM:SS:TT format. Here's my selection statement: ctime({APPTDATA.TIME}) in {?StartTime} to {?EndTime} I'm stumped. Appreciate the help.

Even though I changed my StartTime and EndTime parameters to type "time", when I run the report, they appear as Dates in the window where I enter my parameters. They're both defaulting to 11/28/2005. Double checked and the Value Type=Time. I set defaults of 12:01:00 and 11:59:00 respectively...

so - let's say I have two records in my Appointment table. One is {Appt.Time} 8:01 and the other is 8:06. They are strings but the field contains the colon. I create StartTime and EndTime parameters that are Strings? I want my user to be able to filter for Appointments scheduled between 8:00...

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

Hello, That does seem cleaner but I need to include those appointments booked with no associated Patient record in my output since these slots are also scheduled. Think that APPT needs to remain my 'defining' table. Thanks, though.

Thanks for the speedy reply. I may need to change the join between APPT.DBF and PATIENT.DBF to Left Outer. Had overlooked the fact that some of our users do not connect every Appointment booked to a Patient record. Example: Patient has not been seen in the office yet. Call to schedule an...

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