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

    sql statement

    Naith, thanks for the infos, my subreports are functioning now but I allways have to print them, if I supress, then I get the 0 in my shared variable. So this is not the solution I need so badly I am sure your suggestion writing my sql statement is the best solution, as I havent done before...
  2. hal3003

    sql statement

    Naith, tried the subreports out. now I have 2 subreports one for searching with item value being filled from table 1 and the second subrecord with an empty item value, in case there is no special conversion for the item. but I really need the second subreport only if I don´t have found a record...
  3. hal3003

    sql statement

    Naith, thanks for trying to help, I appreciate the situation: 1. Table (order informations): ordernumber, positionnumber, item, sales-unit, price quantity and so on 2. table (item standard informations): item, description basic-unit, standard price and so on. 3. table (convert dimensions -...
  4. hal3003

    sql statement

    Naith, thanx a lot it really sounds good, the problem is, as I`m just starting with crystal I don`t have the slightest idea how to do it, can you advice? I thought I would have to build some kind of sql statement in a formula field or in a sql expression field. the help file is really no help...
  5. hal3003

    sql statement

    hi, have following situation: 1st table has the informations about my order positions 2nd table has all my item informations, like base.item-unit 3rd table has the infos about how the sales unit and the standard item unit are connected to eachother, like 1 meter is 100 cm and so on. Table 3 has...

Part and Inventory Search

Back
Top