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!

Register Log in
  • Congratulations bkrike 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: greg52
  • Content: Threads
  • Order by date
  1. greg52

    Report Exporting

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

    Sub Query Problem

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

    Export To Excel Problem

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

    Subreport problem

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

    Rollup Problem

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

    Integration Manager sansScript 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...
  7. greg52

    Integration Manager Script 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...
  8. greg52

    Multiple Databases - How to select

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

Part and Inventory Search

Back
Top