Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. brutus6294

    HOME Directory on TS

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

    Crystal Error on Term Server

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

    Can't copy files

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

    Report Distribution Expert

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

    Report Distribution Expert

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

    Formula problem

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

    Formula problem

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

    Access - delete query

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

    Progression client on Server

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

    Progression client on Server

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

    Another Pivot Question

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

    Another Pivot Question

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

    Pivot - Select column 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!!!
  14. brutus6294

    Output Query Analyzer

    That will not give column names, will it? Thanks
  15. brutus6294

    Output Query Analyzer

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

    Pivot - Select column data

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

    Pivot - Select column data

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

    Pivot - Select column data

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

    Pivot - Select column data

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

    Pivot - Select column data

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

Part and Inventory Search

Back
Top