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 strongm 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. zcalebz

    Combine 3 fields

    Maybe this will explain the situation better. Table one(INVMST) is a list of all our products containing fields such as SKU, Price, Cost Description, etc. (so there is only one SKU per record) Table two (CONT_QTY) is a list of our products containing fields such as Quantity On Hand, Reorder...
  2. zcalebz

    Combine 3 fields

    I have three tables. Each table contains a field 'SKU'. Two of the tables only contain unique records for each 'SKU'. The third table field 'SKU' has many records for each 'SKU' (i.e. one record for 108976 in each of the first two tables, 49 records containing 108976 in the third table)...
  3. zcalebz

    Printing last date ordered when there are multiple dates ordered

    I'm building a report that shows all of our inventory that HAS NOT!! been ordered in the last (user input date range). For example I have product 138012 it's been ordered on 10/2/01, 1/03/02, 7/14/02, 6/03/03 etc... I've figured out that putting the field in the group footer it'll return...
  4. zcalebz

    Crosstab:: Inserting A Formula Based On Two Summarized Fields

    Hi I have this type of crosstab working now: 10AM 11AM 12PM Sales (total) 107 215 175 Transactions (count of) 10 16 14 Clerks (distinct count of) 2 3 1 What I want is One more Row: Transactions...
  5. zcalebz

    USING CR 9.0 and Some Tables in SQl 7.0 Databas don;t show up

    hi, I just upgraded From CR 8.5 to 9.0.... I have setup the CR 9.0 connection to my SQL 7.0 database, but for some reason not all of the tables show up... I went back and connected exactly the same way in CR 8.5, and the tables all show up... ANY HELP WOULD BE GREATLY APPRECIATED..... Thank...
  6. zcalebz

    percent of total in a crosstab (cr 8.5)

    I have a crosstab which has all of the sums , now I just want to add a percent of total next to the sums.... I've tried inserting another Sum Field and changing its summary function to percent of total, but it's not an option.... Here's an example of what I have: seattle portland...
  7. zcalebz

    Cannot format %of total in Cross Tab CR9

    Sorry This isn't and answer, but can you do "as percent of" in a crosstab in crystal reports 8.5

Part and Inventory Search

Back
Top