|
alihaidar
Starting Member
3 Posts |
 Posted - 2005-12-20 : 11:51:20
|
| Hi all,I have this stored procedure and I want it to produce the results to GROUP BY Style1, Style2, StyleColor, Whrse_No, Bin_No ...... This procedure is used by a crystal report file to produce a report.... Below is the code:( I think that the problem is in that some fields which are not summed have to be somehow gropued or modified)------------------ Seelct part simply slects several variables where sum of them are summedselect Style1 ,style2,StyleColor,Description,Whrse_No, Whrse_Desc, Bin_no, size_cd, Nbr_Sizes, Size_Desc01, Size_Desc02, Size_Desc03, Size_Desc04, Size_Desc05, Size_Desc06, Size_Desc07,Size_Desc08, Size_Desc09, Size_Desc10, Size_Desc11, Size_Desc12, Size_Desc13, Size_Desc14, Size_Desc15 , OnHandQty_Total = sum ( OnHandQty_Total), OnHandQty_Sz1 = sum (OnHandQty_Sz1), OnHandQty_Sz2 = sum (OnHandQty_Sz2), OnHandQty_Sz3 = sum (OnHandQty_Sz3), OnHandQty_Sz4 = sum (OnHandQty_Sz4), OnHandQty_Sz5 = sum (OnHandQty_Sz5) , OnHandQty_Sz6 = sum (OnHandQty_Sz6), OnHandQty_Sz7 = sum (OnHandQty_Sz7), OnHandQty_Sz8 = sum (OnHandQty_Sz8), OnHandQty_Sz9 = sum (OnHandQty_Sz9), OnHandQty_Sz10 = sum (OnHandQty_Sz10) , OnHandQty_Sz11 = sum (OnHandQty_Sz11), OnHandQty_Sz12 = sum (OnHandQty_Sz12), OnHandQty_Sz13 = sum (OnHandQty_Sz13), OnHandQty_Sz14 = sum (OnHandQty_Sz14), OnHandQty_Sz15 = sum (OnHandQty_Sz15), Total_OnHandNeg , CompanyName, Date from #rInventoryOnHandStyle_WhseWhere 1 = 1' + @sAND10 + '------------- Group RuleGroup By Style1, style2, StyleColor, Whrse_No, Bin_no' + @OrderBy + ' '--)EXEC(@cmd)GO |
|
How to use the group