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

    exclude items in a table

    I'm running Crystal 11 over a BOXI universe. I want to report on Items NOT bought by a customer. I have a query of available_items and a query of items_bought by the customer. I want to list all available_items that are NOT in the items_bought query. What is the correct link between the two...
  2. JRine0101

    convert numeric date to date

    That sounds good, but apparently I do need to download it. Where do I get it?
  3. JRine0101

    convert numeric date to date

    I have a field in my database that is defined as a numeric field but it is a date in format yyyymmdd. I would like to display it as "mm/dd/yyyy". First choice is to convert it to a date so I can do whatever formatting I want, but it would make me happy just to have be able to display it as I...
  4. JRine0101

    Crystal Reports XI parameter creation

    I am trying to create a parameter to be used as part of the selection critieria when running my report. The create parameter screen has changed quite a bit since Crystal Reports 10 and I can't figure it out, nor is the help helping me. I want to create a parameter for customer name and have a...
  5. JRine0101

    Average of a count

    I'm trying to display an average (in my group 2 footer) of a formula, but get a message that says "this field cannot be summarized". This is the formula I tried. It should reside in group footer 1 (product family): Average ({@Penetration},{QryCustomerAvg.Family Description}) The...

Part and Inventory Search

Back
Top