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 gkittelson 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: *

  1. jhomrighaus

    CAST Function issue in CR9

    I think that might have fixed it Thanks SOOO Much
  2. jhomrighaus

    CAST Function issue in CR9

    Hi, I am attempting to use a cast function as a part of a SQL query in CR9 this is the SQL code I am using; SELECT "OfCustod"."CLCODE", "OfCustod"."PJCODE", "OfCustod"."CUCODE", "OfCustod"."SDG", "OfCustod"."ReceivedDate", "OfCustod"."ReceivedTime", "OfCustod"."Receiver"...
  3. jhomrighaus

    CAST Function issue in CR9

    Hi, I am attempting to use a cast function as a part of a SQL query in CR9 this is the SQL code I am using; SELECT "OfCustod"."CLCODE", "OfCustod"."PJCODE", "OfCustod"."CUCODE", "OfCustod"."SDG", "OfCustod"."ReceivedDate", "OfCustod"."ReceivedTime", "OfCustod"."Receiver"...
  4. jhomrighaus

    Excluding Outlier Data from Calculations

    In this case I import the date which consists primariy of %recovery of expected results. This is groupped by The test and further by the type of extraction used. Then finally it is grouped by the type of QC(duplicate, control etc) on each of these groups you calculate the Average and Standard...
  5. jhomrighaus

    Excluding Outlier Data from Calculations

    I can do that the problem is the summary formulas still use the data to calculate even though it is suppressed in the details section.
  6. jhomrighaus

    Excluding Outlier Data from Calculations

    Hello, I am attempting to generate a report to calculate a set of statistical control limits from QC data contained in an external database. I can aquire the data without issue and I can calculate all the of the various statistics without issues, where I am encountering difficulty is that...
  7. jhomrighaus

    Advanced Union Field

    Hello, I am working to extract data from a Laboratory Information Management System. The LIMS is an AdvantageDB, and I am interfacing with an ODBC conduit. I am trying to develop a summary report of QA data and this involves cross connecting about a dozen tables with 6 relationship "lanes"...
  8. jhomrighaus

    crw32.exe strange error

    Strange problem occuring with 2 machines that are on about a 200 foot leg from the main switch. The following is the error log entry for the most current occurance, others are identical, however report sometimes runs without error. This seems to happen at the moment when the report finishes...
  9. jhomrighaus

    Maps in Crystal Reports

    Is there a source for additional maps for use with crystal reports, or are we stuck with the ones that come with it. this is for crystal 8 and 9
  10. jhomrighaus

    CR 8.5 to 9.22 Data Type Problem

    Hello, Software involved; CR8.5, CR9.22, CE 9, Synergy, xfODBC Here is what happened; I had a basic report setup in CR 8.5 that had 2 parameter fields for start and end date(date type = date). Report worked great. Published to CE for web access and began to get Error on parameter...

Part and Inventory Search

Back
Top