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 wOOdy-Soft 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: awaywifye
  • Content: Threads
  • Order by date
  1. awaywifye

    nthLargest on same line

    Using CR 8.5 and Active Data (field definitions). Report is run in a VB program. The report points to a table that contains a project code and sum of time. IE: Code Time A12 10.5 2847 2.75 1112 5.75 On the report I want to display the time and code from largest to smallest on one...
  2. awaywifye

    Stop automatic Presentation Server Client mode?

    Enduser using ica 8.0.2x Recently I added a second monitor to my system and split the desktop over both monitors. As soon as I did, all the applications opened within citrix windows open in a "MetaFrame Presentation Server Client[SpeedScreen On]" window. This window spans both monitors with...
  3. awaywifye

    Thinkpad Dock II USB

    Has anyone else had issues with the USB connections on the Dock II (2877). It seems as though there's a weak connection or the cards easily die... We received a group of 8 IBM T42's with Dock II's: 1 Dock II was bad out of the box. Couldn't get USB on the dock to power anything. Interchanged...
  4. awaywifye

    Subreport bombing out CR8.5

    Quick background. 90% of the reports I write are fed their data from a VB program with a SQL DB. So I write the queries, use the program for the parameters and pass the results to the report. 10% I actually use Crystal's linking/parameters. The report uses 2 tables. The first has a listing...
  5. awaywifye

    SP to file using OSQL getting rid of 1>

    I have 1 "master" database with several disconnected offsite databases. At the offsite locations, new records are identified, and we are given this information. We add the record to the "master" database and in turn send this new record out to the offsite databases using proprietary packages...
  6. awaywifye

    Selecting from multiple databases

    To set things up: I have a server with ~23 databases. 14 use a standard naming convention aaa_001, aaa_002, aaa_003, etc... Is there an EASY WAY to pull data from all 14 of these using one select statement (ie- SELECT * from aaa_*..table1) I currently write a select statement for database...
  7. awaywifye

    Suppress details based on group

    This is probably going to be really basic, but... Using CR8.5, SQL7. Report is using recordsets (not live data). I feed the report xx many records, then only dislay a random 10% of those records. I have 3 groups (RecordCount = 10): Group1 - Based on a formula // Rnd() Group2 -...
  8. awaywifye

    DB Warehousing

    I have approx 15 databases that I run though and collect certain tables/colums into one central database. I was told that I should use master as the warehouse as it already touches all the databases. Currently the setup looks something like: Views in each of the DB Tables in Master Stored...
  9. awaywifye

    CURSOR to find n-1

    For one singe item in the database I could have multiple dates that it has appeared in the database(see below). Record Barcode Date 1 123 3/25/2005 2 123 3/24/2004 3 123 11/12/2003 4 345 3/25/2005 5 345 3/24/2004 6 345...
  10. awaywifye

    Powerloss, 4400 crashed, RAID 5 d:\ missing lights green

    Tried to make it as compact as possible. About 6 months ago one of our sites abruptly lost power. The 4400 crashed, and they lost the container (RAID 5 - 3x18GB HDD). After about a week we had the sight completely up and running (our servers are imaged - only this site hadn't imaged their...

Part and Inventory Search

Back
Top