Search results for query: *

Thanks for your suggestions. I've used Union joins in the past when I had multiple db's of the same type (MS SQL). The situation now is a MS SQL db and a Pervasive db. I don't see how a Union would work here since the database field names are different.

I've written a CR (v11.5) to produce a flatfile. All of the fields have been placed in a single text object. After the report runs, the results are exported to a CSV disk file. Before exporting, the file extention is changed to TXT instead of CSV. On the Separated Values Export Options...

Thanks, Borislav. It did the trick. Greg

I have a MS SQL table structure that looks like the following: Table a: Employid SSN 12345 123456789 23456 456789123 34567 789123456 Table b: Employid Chekdate Paytype Paycode Hours Amt 12345 2006-05-01 1 Hourly 40 900 12345 2006-05-01 2 401K 0 50 12345 2006-05-08 1 Hourly 40 900...

synapsevampire - Thanks for replying. Shrinking the fields did the trick.

Using the HP Design Jet 3500CP driver and a page size of 24x108 inches, I have a report containing 38 fields. Picturing the report columns lettered like the columns are in Excel, when I export using Excel 8.0 Extended, column A in Excel begins with report columns X through AL. Column AL of the...

That's it! Thank you! -Greg

I am using CR v8.5 and have limited experience with it. Here is what I trying to accomplish: The SQL table structure: Employid EndDate PayCode Amount 12345 03/17/2006 2 100.00 12345 03/17/2006 3 50.00 67890 03/17/2006 2 30.00 The report output structure I'm after is the following...

No offense taken. Even though I altered the names, they do appear to be real.

That did it. Thanks, George.

George - The data was changed to protect the innocent!

I am have a problem with the ROLLUP operator. The table that I am querying is as such: EMPLOYID EmplName Dept WCCode Gross SS MED FUTA SUTA 11000217 FLEURIMOND, ROSE 100002 NY8394 369.26 369.26 369.26 369.26 369.26 11000253 LAMBERT, JOY 100002...

Found out that the IM CNK file also had to be in the Darwin (Great Plains) subdirectory. That fixed the problem.

While attempting to run a script in IM, I get the following error: "Could not locate the Integration Manager sanScript library." I set a global variable in a Before script and attempt to access it in another script that is run off of a field in the Destination Mapping area. However, the...

Update - I was able to work around the problem.

I have a script that successfully queries SQL for the employee id based on the SSN. However, the problem is in trying to do some error handling code. When testing for the record count returned, which should be either 0 or 1, the Recordcound property always returns a negative 1 (-1). Does...

Thanks all for your help. Dave - Your view suggestion is what I figured would have to be done if CR couldn't do it -Greg

I have about 20 company databases on a single MS SQL2000 server which all have identical tables. I would like the report to prompt the user to select which company to report against. There isn't any problem with the prompt, but how do I get the company selected to be part of the SQL command...