Search results for query: *

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

Using Crystal 7, I am struggling with this scenario. TABLE1 TABLE2 Client -------> Client Account ------> Account OtherField1 Table2Field OtherField2 This is a left outer join. I want everyone in Table1 regardless if they show up in Table2. However, I only want those in...

Fabulous! Thank you.

I am using Crystal 7 (hello from the dark ages!). I have data stored in a table in all upper case. I want to display the data with each word beginning in upper case, the remainder in lower case. Example: Data: THIS IS MY DATA Display: This Is My Data How can I do this? Thanks, Cathy

I have a backed up database that I want to restore onto another server. Using Enterprise Manager with SQL Server 2000, I have followed these steps: Click Tools Click Restore Database Click Restore from Device Click Select device Click Add Click Navigation button next to file name I get a box...

I have successfully backed up my tx log. I have successfully shrunk my tx log. It is now taking up .20 mb of space. Now I want to reduce the amount of space allocated to the tx log, which for some reason is set at 250 mb. Yikes! The only adjustment SQL server is allowing me to make is to...