Search results for query: *

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

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

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

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

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

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

I have a query with a left outer join, and a formula that calculates based on comparing one field in each table. I am having difficulty in making the value 0 when the field does not exist in the right table. This is the formula I'm using right now. IF {LEFTTABLE.VALUE} <> {RIGHTTABLE.VALUE}...

This is a really really basic question from a relative newbie. I have a production database and a test database. Once a month, I want to UPDATE the test database with changes in various tables that have taken place since the last time. How do I do this? It's not really append, because some...

Hi there, I have a parameter that accepts multiple values, and want to display those values on the report header or footer. Placing the parameter itself in either of these places just displays the first value in the list. Is there a way to tell it to show ALL values selected? Thanks, Cathy

This is probably not as difficult as I'm making it to be, but I'm having difficulty untangling this process. I want to have an initial parameter, which will control the parameter for the next level. Example: The first parameter would be something like {?SORTBY}, with default values such as...

How can I filter a column in an Excel spreadsheet for the presence of an asterisk? I've tried *'*'*, and get nothing. '*' gets nothing. * gets everything. I'm flummoxed! Thanks. Cathy

I have a macro that runs three queries consecutively. The first two are make table queries, so the user has to click 'Yes' six times. Is there a way to incorporate the click 'Yes' into the macro so that it is invisible to the user? In these cases, the answer would ALWAYS be 'Yes'. I don't...

I want a subreport to open only when a command button is pushed to open it, and have the subreport correctly connected to the current record in the main report. I have been able to either insert the subreport and have the records correctly connected, but always visible; or insert the command...