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

    Table join on formula field?

    Crystal 10, SQL database. Need to link Item Master(IV00101) to Item Master Summary (IV30101) by a formula. Desired results: Item Number Item Number (summary) QTY Last Year Sales 111+C 111+O 2 0 222+C 222+O 5 2500 I need...
  2. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    I need to create a report where customer sales increased x$ for this 12 month period over the last 12 month period. Parameters are period, year, and increase. If the user enters parameters of 12, 2005, and 5000.00 then they can see the customers whose sales for period 1 - 12 of 2005 increased...
  3. leftfldr5

    Group sort on formula field

    I need a way around not being able to group sort on a formula field. Here is the layout of my report: 2 tables and Inventory Master and Work Order table with a possible 1 to many relationship. Item # -- Qty -- Standard Cost -- Ext Cost The report is grouped on Item # and Ext Cost is Qty *...

Part and Inventory Search

Back
Top