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 dencom 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: *

  • Users: jollyreaper
  • Content: Threads
  • Order by date
  1. jollyreaper

    Display full contents of database with a simple script

    I know that there's a way to do this, I know my pseudocode should be close (hopefully) to correct. I want to be able to take a given table from the database and display all records for all fields without having to manually type in the field names. I remember that you're supposed to be able to...
  2. jollyreaper

    Excel won't accept formatting of numbers

    Ok, so I have a cell that shows 38718. That should be a date. Ah, so it's obvious I should format the cell and say "number is date", right? You followed my line of thinking. Wrong! It refuses to take that formatting. I checked on one of the other sheets in the workbook and it has no problems. If...
  3. jollyreaper

    Insert Line Break into Concatenation

    I need to change the way a formula is working. Right now it's taking variables and making them look like this: "variable 1, variable 2, variable3" I need to make it look like: "Variable 1 Variable 2 Variable 3" I'm using logic to remove variables that are blank. dim text as string if...
  4. jollyreaper

    AD and Permissions and Insanity

    Anybody have good recommendations for learning up on Active Domain and how permissions work? It's kicking my butt right now with inexplicable craziness. I'm trying to lock down certain directories to make them more secure. I have administrator as owner for everything so I can make sure the...
  5. jollyreaper

    Excel / Sever 2003 permissions problem -- cannot access file

    Not sure whether I should post this in the Office forum or here. Hopefully here is more applicable. We're running an intranet and keep our important company forms on pretty little pages. The company is growing in an ad hoc fashion so we're implimenting some security features a little later...
  6. jollyreaper

    Smartest way to align text

    I have a report that is trying to present several calculations lined up properly. What I'm trying to do is something like this: Units: @unitformula Options: @option formula ======================== Total: @total formula When I first started using Crystal, I would have done that by making...
  7. jollyreaper

    What to do about those garrish intelitxt ads?

    Very annoying. I assume they're using javascript to make these ads pop up in the discussions. Do we have to disable javascript to make them go away? It's like the bizarro world cousin of hyperlinks -- hyperlinks link to good and useful information, these intellitxt links bear no relation to the...
  8. jollyreaper

    Terminal services: average bandwidth per session?

    I've been trying to find some documentation on how much bandwidth (on average) each terminal services session should consume. As I understand it, if you aren't doing anything in the session and nothing is causing the screen to update, the consumption is just about zero. What is considered to be...
  9. jollyreaper

    Rendering inconsistency between Reports and Server

    This is my report as it appears in Crystal Reports preview. Very pretty, yes? This is how it appears when delivered via Crystal Server, emailed as a PDF. See how it's messed up? The text is all screwy, parts getting lopped off. Lines are also wrapping far before they've encountered the...
  10. jollyreaper

    Outlook 2003 / Word 2003 / Exchange Sluggy and Slow

    XP Pro. When I boot my computer and log-in, if I try to open Outlook it takes at least a minute or two. If I try to open a new email, Word takes even more ages to open. I don't have too many TSR's in the background, I have a gig of ram and a 2ghz processor. Is Outlook's performance this pig-like...
  11. jollyreaper

    Excel: Fill down formulas in columns adjacent to data does not work!!!

    Fill down DOES NOT WORK. I have a big data dump in one of my sheets and I have column A serve as an index for it -- the dump starts in column B and goes off to the right for a zillion columns. Based off of conditions in that dump, I concatenate a reference number that is then referred to from...
  12. jollyreaper

    Passing Formula to Subreport to use in SQL -- bad idea?

    I'm calculating the current accounting period to use in several sub-reports. The slow and dirty way to do this is to just put that formula in every sub-report and things will work fine. I wanted to make this quick and elegant by calculating the formula once in the main report, then passing it to...
  13. jollyreaper

    Am I using too many subreports? Is there a better way?

    I've got a report that I need to put together. I pretty much know how to do it with subreports but I'm wondering if I'm making myself a lot more trouble than its worth. I'm pulling this information from a package that does our scheduling and accounting. Business Objects XI, OBDC=topspeed 5.0...
  14. jollyreaper

    Duplicate contacts even when "check for dupes" checked!

    Exchange 2003, Outlook 2003. Outlook currently is not checking for duplicate contacts when I drag in new contacts. According to everything I can find, you're supposed to go into tools / options / contact options and check the box by "check for duplicate contacts." Doesn't work. Works on other...
  15. jollyreaper

    Smartest way to share information in Exchange (public folders?)

    Exchange 2003, SP2. I'm trying to figure out the smartest way to do things in Exchange. We have several departments and I set them up their own public folders. Those folders have shared tasks, contacts, calendars, etc. We have a few issues with it, though. 1. The public contacts are...
  16. jollyreaper

    Best n00b resource for BES 4.0???

    Just installed BES 4.0 on Exchange 2003, all users on Blckberry 7520's. Where is the best place to go for a nice, simple, organized introduction to all this? I'd like to avoid as much wheel-spinning as possible. Thanks!
  17. jollyreaper

    Multi-column report

    Crystal XI, looking to do the following: Read from construction schedule: lot number, task, cost code, vendor Display format: arranged in columns by day of week. Group 1 - Week Span -- by day of week Group 2 - Lot Number Group 3 - Vendor Details - Task, Cost Code The results should...
  18. jollyreaper

    Make running total formula value available in sub-report

    Crystal XI I have a running totals formula that I would like to make available globally so it can be used in a sub-report. I will be using that running total value in a comparison in the sub-report to see if it is equal or not to another value in said sub-report. Do I have to create a function...
  19. jollyreaper

    Skip nulls in database

    Crystal Reports / Server XI Windows 2003 Topspeed ODBC I have a query that seems to be choking on nulls. Some of the date values in the database are null. Now SQL nulls are not the same as '' so saying where startdate<>'' wouldn't work, more's the pity. When I remove all references to...
  20. jollyreaper

    Reading files from another computer via ASP FSO

    There's been a lot of discussion about this on here but none of what's been sugggested has gotten me close to a resolution yet. Here's the situation. I'm running ASP on one computer, we'll call it webserver. I want to read a directory off another server, we'll call it otherserver. By default...

Part and Inventory Search

Back
Top