Search results for query: *

gmmastros - This is good info as a reminder In my case, I spoke with the user and we have a high degree of confidence that she will never enter more than a couple lines. To suppress the rtf control codes, I created a number of fields in CR (6) (probably could have done this in SQL too, but I...

mmmmm - I like this. The data users enter in here will probably be short enough that I will be ok with this as a solution. Good way to end a Friday - Thanks VERY much!

Thank you both SQLDenis and gmmastros - I tried this as well: SELECT dbo.drlicense.dr_nbr, dbo.drlicense.lic_dcmnt, CONVERT(varchar(8000), CONVERT(varbinary, dbo.drlicense.lic_dcmnt)) AS Expr1, dbo.doctor.dr_mnc FROM dbo.drlicense INNER JOIN...

I am using a database that has a field defined as image. The data in the field is binary. Practically speaking, the only data that could be entered into the field is text (in the application the field actually opens an RTF editor). For what it is worth, I have spoken to the vendor about why...

Thank you donutman...of course the users have modified the request. Oh well - I appreciate the response.

I am trying to create summary totals on a dataset. Data is like: seq_num ring_start_time abandoned call_pu_time 775544 2/17/2005 10:30:02 F 2/17/2005 10:30:15 775545 2/17/2005 10:30:22 F 2/17/2005 10:50:35 775546 2/17/2005 11:30:42 T 775547 2/17/2005...

Great! Thanks for the quick reply - star for you.

Using CR 9.0 I have a report that is essentially a letter sent to physician staff when they are given hospital privileges. The data in the letter varies by doctor, and is based on dictionary's established in the software. It has the following sections: RH PH GH1a GH1b D GF1 The GF1 line has...

Thank you for all the replies...I tried them out, but still having trouble. Not an urgent issue, and we have finally scheduled someone to come in and do training, so I will take it up with them. Thanks again, though...I have found many valuable tips on this page.

crystal 9.0 SQL database 7.0

I am trying to refine a select for a report. sample data: urn status date on staff last status date 2059 A 10/8/1997 <NULL> 2059 T 10/8/1997 1/10/02 1050 T 1/1/1996 9/30/01 I need to select all records where status is 'T' and last status...