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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hal3003

  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