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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by greg52

  1. greg52

    Report Exporting

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

    Sub Query Problem

    Thanks, Borislav. It did the trick. Greg
  4. 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...
  5. greg52

    Export To Excel Problem

    synapsevampire - Thanks for replying. Shrinking the fields did the trick.
  6. 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...
  7. greg52

    Subreport problem

    That's it! Thank you! -Greg
  8. 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...
  9. greg52

    Rollup Problem

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

    Rollup Problem

    That did it. Thanks, George.
  11. greg52

    Rollup Problem

    George - The data was changed to protect the innocent!
  12. 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...
  13. greg52

    Integration Manager sansScript Problem

    Found out that the IM CNK file also had to be in the Darwin (Great Plains) subdirectory. That fixed the problem.
  14. 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...
  15. greg52

    Integration Manager Script Problem

    Update - I was able to work around the problem.
See more

Part and Inventory Search

Back
Top