Recent content by cathyg18

Doing a group selection worked perfectly. Thanks for your help. Cathy

Thanks LB. I'll give that a try a bit later on today. I appreciate your help.

Hi guys, Using Crystal 2016. I have a scheduled report that I need to export to a csv format. I'm working with patients and appointment times. There are times when a patient has more than one appointment on the same day. I created a group on patient account number, and am sorting that group...

We moved an ODBC database from one server to another. I can't find anywhere that identifies the server my reports are pointing to. In Database Expert, add new connection, the only options I get are the same ones I previously had. Where, oh where, can I identify and change the server the...

You guys are THE BEST!! The row_number over partition select worked perfectly. My poor bruised head that has been banging against the wall thanks you, and I thank you too. Cathy

I want to have a counter column in a temp table that resets to 0 when account number changes. It looks like IDENTITY gets me part of the way there, but won't reset when account numbers change. Example: Account Color Counter 123 Blue 1 123 Yellow 2 123 Orange 3 456 Red 1 789 Blue 1 789 Yellow 2...

In Access 2003 is there a way to base a parameter selection on a partial string using wildcards? For example, I want a user to input 'CAT' and return records containing 'CAT', not just records that exactly match 'CAT'. Thanks. Cathy

I'm using Crystal 7 and have a report that is not printing correctly to my pdf printer. The group footer (only one group) and report footer intermittently do not appear in the Adobe document. I can see them in Crystal, and if I print to a paper printer, they show up. It's just in the Adobe...

It just says 'Dos error' and stops. It goes though about 2 million records before it crashes. It's going against a SQL database. We're running SQL server 2003, and Windows XP. Hope this helps! Thanks, Cathy

I'm using Crystal 7 and have a particular report that begins well, but eventually stops giving me a 'dos error' message. Any ideas why I'm getting that, and how I can get rid of it? Thanks, Cathy

goldwhispers, have you found anything out about this error message? We are getting the same one, also on crystal 7. Thanks, Cathy

I need to be able to search across multiple documents for a string that includes both numbers and letters. Using the 'Search' feature does not return any results, whether I am searching in a single document or across multiple documents. Using 'Find' locates the string within the open document...

Thanks for your comments. MrDenny, I checked as you suggested, and the slide bar for the database shows approx 28 gig used with approx 29 gig free. For the tx log it show approx 137 meg used with approx 8 gig free. The drive itself has only 2 gig free. So I seem to be in a pickle. Any...

I have a database that is about twice as big as it should be. Trying to shrink it results in error message tx log is full, backup tx log and try again. The backup log command takes maybe a second, returns a message that the task is complete, and I have the same size everything, data files and...

I'm a relative newbie. Can someone help me figure this out? I have names stored in a table like this: Name Smith MD, John Name is all one field. I want to update that field without the MD, so it would be like this: Name Smith, John Using Charindex, I can locate the starting position...