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!

  • Congratulations John Tel 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 davidmckee

  1. davidmckee

    Try to connect to XML using Crystal

    Good morning everyone, I am hoping someone can help. I am trying to create a crystal report to present weather based on the Weatheroffice database. They provided me with an email and link but I don't know how to set up Crystal to report on this. I want to bring in the Forecast weather for...
  2. davidmckee

    SQL Union/Join

    Sorry what about table 2 in the code? I only see table 1 in the FROM
  3. davidmckee

    SQL Union/Join

    Not sure how to do this have two table and trying to bring in data on one report Table 1 Item Quantity On Hand 123 5 Table 2 Item Sales Date 123 1 01/01/09 123 1 02/01/10 123 1 03/01/10 Create (for last 6 months only) Item Quantity On Hand Sales 123...
  4. davidmckee

    Most Frequent Text Value in Excel

    Sorry looked up frequecy and not sure how to apply it. Any suggestions? I keep getting a value of zero?
  5. davidmckee

    Most Frequent Text Value in Excel

    Good evening hoping someone can help. Looking for a formula which will identify the most frequent text value based on a lookup. The example I have all date for June with 4 different times and conditions. I want to get the most frequent description for that day with the date being a variable so...
  6. davidmckee

    Separating groups while printing (trying to staple/collate each group)

    Thanks for the quick response. I am interested in your comment re:set a parameter. I have Crystal Reports Pro Version 11 Thanks in advance
  7. davidmckee

    Separating groups while printing (trying to staple/collate each group)

    Good afternoon, if anyone knows if this is possible please let me know. Example: I have 50 groups representing multiple countries. I have one report which groups sales by Country. I would like to staple all the Canadian pages together and in a different package staple all the U.S. packages...

Part and Inventory Search

Back
Top