Search results for query: *

Hi - I'm a database guy trying to trouble-shoot a Crystal Report issue for a terminal server. I'm trying to find the users Home directory in Terminal Server. If I log into TS as user, they have restrictions on DOS so I can't go to DOS. I can log in as administrator to TS, but they don't have any...

Have one of my users getting error "The Remaining text does not appear to be part of the formula" while accessing Crystal thru a terminal server session. Environment is Progression 400a, SQL Server 2005. One of my TS users is getting the above error, presumably because of a NumberToDate...

I'm trying to copy the C: drive of my laptop to a USB drive. I have stuff all over the place, so I was hoping to copy the whole drive over and I can search thru the USB drive for what I need if I need it... However, I keep getting can't copy file - file may be in use by another user or process...

Am a little confused by the Report Distribution Expert in Crystal 8.5. Can I not, with the Compile Report option, compile a Crystal Report into an .exe format and throw it on a network share so that all users with or without Crystal loaded on their PC could execute it? Or do I need to also go...

For some reason I'm having difficulty with this formula. All I want to do is look in the value in the next column. If the value is ABC or ABD, return ABCD . These are all text. If it is not, ABC or ABD, return whatever the value was unchanged.. Something along these lines... =IF(F2='ABD' or...

Tried to run a query in Access 2003 using a delete query to delete all orders with order date<1/1/2007. The Orders are 2 linked SQL tables (header and detail) and want to delete from both in my query. Get "Could not delete from Specified tables" when I try to execute delete query. However I...

Quick question.. Progression 76.300C SQL. Is it ok to install Progression client on a server with both SQL and Macola installed on it?

Have 3 fields in the DATA section of a Pivot. Looks something like this. Sum of Field1 99999 99999 999999 9828282 Sum of Field2 88888 88888 888888 888888 Sum of Field3 7777 7777 77777 77777 The fields and field descriptions appear in the data...

This is a very stupid question, but I have about 10 Queries in query analyzer I would like to capture the output to. Ideally I'd like to capture the query and the output in one readable file, but will settle for capturing the results (including the column headers). Is there a good way of doing...

I have a pivottable with Year and Quarter in the Column Data of the pivot table. Is there a way for an end user to not display Quarter information at all if they just want results by year? I've tried de-selecting Quarters using the pull-down, but it seems at least one quarter must be selected...

I need to write a crystal report for Progression designating customer ship-to's as inactive or active based on if anything has been shipped to that address in the past year. An active ship-to would be one which has had an OE order delivered to in the past year. Inactive one would be one with no...

I've created a pivottable. Data file for pivot is very large, approx 15000 rows. Pivot table was created fine, but when I try to add an additional field to the row area of the pivot, I get "Microsoft Excel cannot make this change because there are too many row or column items. I only have 4 row...

Getting a Torn Page IO error on a table. Get error when opening up table in EM (SQL 2000).Tried DBCC Checktable REPAIR REBUILD on the table - killed it after hours. No response.... Any thoughts?

Installing SQL Server 2005 on a server for use with an app that uses Windows authentication. However, potential down the line to also use a different app that requires mixed mode authentication. My question is - does it do any 'harm' to install with mixed mode now (just in case future app is...

Think I know the answer, but is it possible to do a "point-in-time" restore to an individual SQL table? Leave the rest of the database intact but restore a single table back to a certain point in time.(using SQL 2000). I think the answer would be to restore the whole database to a new database...

I've inherited a huge pivottable. If I add a column to the end of a data.xls pivottable data file, should my pivottable be able to recognize the change and make that added column accessible to the Pivot? I typically would run a crystal report, export to excel. this becomes my data file. I have...

When installing SQL Server 2005 on a server, should the selection 'workstation components, books, on-line development tools' be typically selected? Does it do any harm to install workstation components on a server?

In Enterprise Manager, all users typically have a username and a username_sql entry. I understand the username_sql is used for Progression, but what is the other non_sql account user for? I've heard it is used for 3rd party apps like Crystal, but wouldn't the standard method be to create a...

I'm trying to edit a stored procedure.. I want to add the clause that if doc_type=I or doc_type=C to perform the below Case statement, but am having problems with an acceptable format... Below is the existing statement. How do I add "or doc_type=C" case when doc_type = 'I' then sum(amt_1)...

Just looking for some general help. The drive that my SQL 2000 database lives on is getting full. I would like to move it to a new drive on the same server. Is there a documented series of steps I should take to do this? Thanks