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...
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...
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...
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...
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...
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...
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 -...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.