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 Mike Lewis 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. 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