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

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

SkipVought, Possibly because of my ignorance.. There are 10-20 different pivottables based off of the same data file. Most are on different tabs of the same excel file. Each one has it's own unique formatting. For example one may be sales by state or sales by category... one showing detail...

Thanks zahead32.. That was pretty good... My problem is I have probably 20 different Pivottables in one excel file. Your solution worked with one pivot that I created the Macro for, but would not work on others....I'm not familiar with VBA so forgive my ignorance..

Blue Horizon, That sounds like what I was looking for. If I go up to PivotTable menu and select Hide Detail, it removes the QTR entries. However, when I want to put it back, I get a "Choose the field containing the detail you want to show" with a list of fields. However QTR is not listed among...

Thanks, I've thought of that, but my hope is to make a pivottable accessible to a group of users. That's easy enough to do, but not sure I want the end users changing the form of the pivottable.. Next guy who looks at the pivottable may not realize that he needs to drag qtr's back in if he...

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