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

    Crystal not showing all decimal places

    The driver is pdsodbc.dll. How would I configure the driver or what other type would you suggest? Thanks.
  2. samprocom

    Crystal not showing all decimal places

    I have a crystal report linking to Sage Line 50 and Sage Manufacturing tables. In Sage the standard cost field is set to 4 decimal places so it appears 1.9765, I have formatted the field in Crystal to show 4 d.p. and round to 0.0001 but when I run the report the standard cost is rounded to 2...
  3. samprocom

    Crystal v10 report missing records when criteria entered

    Thanks. Here's the sql code for the query join in Access. I want to return all records that exist in the nominal ledger table and matching records from the nominal transactions table which is what the query does but as soon as I enter criteria to only see records for a specific department I...
  4. samprocom

    Crystal v10 report missing records when criteria entered

    I have a crystal report set up based on an access query, the query is using linked tables from Sage MMS accounts. The query has been set up with left outer joins and I can see that all data exists in the query, however, when I enter criteria I only get matching records. I have tried pulling...

Part and Inventory Search

Back
Top