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 TouchToneTommy 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: GaryCWL
  • Content: Threads
  • Order by date
  1. GaryCWL

    Formula for last 4 or 6 months of data

    Backend: SQL Server 2000 Crystal Version: BO Crystal XI Is it possible to set up a formula that returns the last six months worth of data? I tried something like: {order.date} in DateTime (CurrentDate - 180) to DateTime (CurrentDate) But, the problem with that, is depending on when the...
  2. GaryCWL

    Unable to select Full Outer Join in Database Expert

    Backend Database: SQL 2000 Crystal Version: XI Background Information: I'm trying to create a report that shows me ALL the parts and various attributes between two databases whether or not a specific part exists in one and not the other. Currently, I've been able to somewhat achieve what I need...
  3. GaryCWL

    Need help with If Then Else or Nested If Then Else

    Backend: SQL Server 2000 Crystal Version: XI I have a total of 10 columns that I'm trying to concatenate; however, whether or not I concatenate 2, 4, 6, 8, or all 10 columns would depend if the source column is null. For example: My data consists of the following tables and columns...
  4. GaryCWL

    Linking / Joining Tables with differing data types

    Backend: SQL Server 2000 Crystal Version: XI I need to link two tables Cart.ItemID with Design.Serial_Number; however, they Data Types differ. Cart.ItemID is a Varchar and Design.Serial_Number is an Integer. Is it possible and if so, how do I do link/join the two tables in Crystal? When I...
  5. GaryCWL

    Help with custom table joins

    I know in Crystal that I can perform the following joins: - Inner Join - Left Outer Join - Right Outer Join - Full Outer Join Is it possible to perform a custom join similar to the following SQL join? SELECT * FROM CO_DOC JOIN Market_Type ON...
  6. GaryCWL

    Exclude Duplicate Records from Running Totals

    Database: SQL Server 2000 Application: Crystal Reports XI Background Information: I've created a report for Marketing that shows Win/Loss ratio bases on Quotes that turned into Orders. I've created a report that already has three groupings Calendar Month/Year, Sales Rep, and Discounted %...
  7. GaryCWL

    Filtering out duplicate records in a Specified Grouping

    Reporting Environment: BO Crystal XI SQL Server 2000 Reporting Issue: I’ve created a detailed sales/quote report that displays the Quote, Project, Discount %, Gross $, Net $. Then grouped the report based on three groupings listed below: • Group 1: Calendar Month • Group 2: Sales...

Part and Inventory Search

Back
Top