Search results for query: *

Thanks! I had to mess around with spacing between the fields (it has to print into specific areas on the report), but it worked great.

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

Ok, did a little more research here. 1) The applications are supposed to open in a "seamless" mode which they appear to do when only one monitor is enabled. 2) The monitors are at 2 seperate resolutions...

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

Also run SELECT * FROM Orders WHERE OrderNumber = 8145 How many LocationID 21's are there....

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

The subreport has 1 group of Tree1UID Informaton is placed in the Details. I tried a group of tDate and placing the information in the group header, but wound up with similar results.

Sorry about that: Group#1 - Model(suppressed) Group#2 - Barcode Row is placed in group#2 header. The subreport has 2 links: Table1.UID = Table2.Table1UID and ?ParameterDate = DATE{tDate}

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

I looked at using sp_MSForEachDB but it appears to hit all databases. Using NoCoolHandle's approach, I took my select and turned it into a stored procedure. Declare @dbname varchar (7) select distinct tb1.chickenname from '@dbname'..table1 tb1 Then using DTS I wrote a quick cursor...

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

Madawc - Thanks for the suggestion, but I have to select truly random records based on x% and daterange. I should get a different report each time the report is run for the same x% and range. lbass - The formula works, but I only get x% of my detail records. In effect I am passing the report...

You aren't going to like this, but it looks like you have to specify the start character (A B or C) with (Start A), then the message, a check character and at the end (Stop). http://www.morovia.com/education/symbology/code128.asp

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

You might be looking in the wrong place: 1) What NT rights do the users in DomainB have on your server? 2) What NT rights do the users in DomainB have on their own machines? We use a similar method (program has it's own SQL user). If the users don't have the correct NT rights on their...

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

The most important thing to understand is how the database is used: 1) Talk to the end users. Watch them use the program, see how information is entered, where and how it is used. 2) You can then use the diagrams function in Enterprise Manager to see how the backend works. (Log into Enterprise...

1) Thanks for the quick response! 2) DOH! It works. I got so hung up on the cursor idea that I didn't even consider this.

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