Recent content by brutus6294

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

Thanks Mawdawc. So I need to use the Report Dist Expert, if I want the user to have the ability to export Crystal reports without Crystal being installed on the PC? With just the exe file (without the Expert installed) they could probably run the report, but not export, etc... Is that it? Thanks..

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

Still having an issue.. Must be Monday!!! =IF((F4="ABC" or F4="ABD"),"ABCD",F4) My or statement is incorrect... If I take it out, works ok.. Is my syntax wrong? Thanks!!

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

Guess it's ok - at one point in the past I think there were issues with it, but it's an accepted practice now.Thanks

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

Could be easily 20000+ rows.... Having enough difficulty getting them used to pivots not sure I want to switch up on them now. It's not that big of a deal, it's just odd that it moves the field name when there is only one item in the Data section..

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

I think I was able to get what I needed using BlueHorizons suggestion. The other solutions I'm sure would be fine also but BlueHorizon's is very simple and seems to work for me..(so far) Thanks All!!!

That will not give column names, will it? Thanks

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