按着帮助里面的做法我建立了一个产品表,但是我在表中的产品列前加一列的话就出现了下图的情况,产品名称填到了id那一列,然后数量和金额没有获取不到产品的信息进行统计出来
![图片点击可在新窗口打开查看](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfIAAAECCAIAAACKYcKeAAAWSklEQVR4nO2dTa8jSVaG40/5L/Q/YYGEhITEAgmpSi2xQAIhIXmBRHnPvmWp9gOIL9OAhi5ADTVMd89Ut6npdn1ND0hmYSbJiYg8+WY6nXEy4nl0dJU3r6+d983jx3HDdjg8efb8z37w6v769LMvL/vd9y/+lFLqst99+MX/UNStDsdT8WPwX6QkphSW1frPP/sTSqnLfvfu+/+uu0II9k8jih9wwTocT2veXJf2baP/Nb2knzO1ckpDodl5Fs/qAVr/5z2l1GW/e/PhF5VVVgF9ogsb37ZWh+Np5Vu8Bd4/L9lTkO4seKbWTymNK92f7fCyKS2t9R/+MaXUZb+7vP++1gohGN/ql2mnDsfTmjeXPuJGO41LFjxTK6fUDyG7nf1R8azu1fr7D99HWv/wT3/koUII2Z3Z/UXqst99+/bnFVcIIdpILxBR/JjXD6erw/FU5DDS0xQdW3qoBc9UqZTsPVEP939aJKu7tP7m7fs3b9/HWv/HP/BcIYTix3Cry373+vKhvsoO7jqiSxrf1l3pH3s4noocQ3deukPqb+hnc51aOaV+ONEf3k8g2ki/rp/STK1/+93bW0Vaf/8Pv++5QgjFj+FWl/3u/N37+iqEUPwY/Fea0uF4KnIAt43069Alswe/Wq2c0lBo6c6b5YciXT+lOVo/v750FWv9098rXreIszvT/aXqst99/bN39VUIQblMR/St8usVVPpnHo6n4ofRnY5oZ0qp3IqkNBRXur8fYDbM1VKarPVX33zbr1jrf/+xhwohZL+N9hesy37309dv66sQgn6Z20b/V5Rfr6DSP/NwPK18ABFDB5b+qOA5WjmlbFBpYtHO9Ov6KU3T+k9evY4q0vq7v3vioUII2W+j/QXrst99dX5TX4UQ9MvcNvq/ovz6puvp06dPnz4NIdw2uv2H42nlI4nOQjZ/Q2pF0ls/pWxQaUqjSa6c0gStf/HVN2nFWv/b3/VQIYTst9H+gnXZ7774+lJZhRDEi3VE34rXsOnK/qWH46n4kXSnY+jCxaMrklKUTJpDFOBokiukpGr9Rz/OV6T1t3/zO8Wra9bszmh/qbrsd//50+8qqxDCpIvdNvq/JV7D1iv9Mw/H08oHEMWengVjqB5dfrUqktJoAtGe4v2sav3zlz8Zqljrf/3blFKX/e7lV99S1K0Ox1PxY/BfpCSmNK71f/38C6Nirf/Vb1FKXfa7//jyZxR1q8PxVPwY/BcpiSktvHjAm7/8TUqpy373+Y9fU9StDsdT8WPwX6QkprS01v/iNyilLvvdv/3ovyjqVofjqfgx+C9SElNaWOuXP/91Sqr97l9eninqVofjqfgx+C9SElNaWus/+DVKqv3us3//hqJudTieih+D/yIlMaXw5NnzTz/7cpG67HeUXofjiaIoavEKT549X8pTX5/fUWKdX724AvwS+kGBlBTOr16EJ8+eX3/4h/cXWkfrMBv6QYGUFNC6L62HELLb9iWhAhCWAikpoHUXWh99j3L/ktEG1AHCUiAlBbTuQusdo6P1rNZRfAUgLAVSUpC0/tHHn6D1dbRuI47oYYsgrD5DXd1yStn/3YdSGtH6Rx9/gtZX07o9x8IIvWJaFlaE0efNppRmYqfEaN2L1u059OjMofXKaFZYKWg9Ba1vo6IGzT41mrqbGZhaaVZYBkzCpGSdEO1B6y60nn34tWWNyisDYUVkO7zxlBSnX9G6E633z5DxosbR0wnbpXFhRQy1d8spiU6/onWHWre3R88obJSWhRVh9HazKelOv+qvhFHMjtaX1Xo0dT40q870eh00K6wUo7GbTWlUCP0L83YkR1qHlqEfFEhJAa2jdXAB/aBASgpoHa2DC+gHBVJSQOtoHVxAPyiQkgJaR+vgAvpBgZQU0DpaBxfQDwqkpPB/Wl/qQ+/Or15QFEVRZYvROqN1KA/9oEBKCmgdrYML6AcFUlJA6760PrpmgPhT2BwIS4GUFNC6C63rCwN022i9MhCWAikpoHUXWu/QV/jSx/WwCRCWAikpjGudpb7W1LoNS31VDMLqM9TVLaeU/d99KCVL632bj5odrd+vdXuOhRF6xbQsrAijz5tNKc3ETgmte9G6PYcenTm0XhnNCisFrduk9/2ZC/MyCfNorWefGs2eP2ZgqgRhpTAJE5He2edMwuhOR+v3aD37X5Uta1ReGY0LKyXb4aR0XWS0Ljodrd+j9f65yT4xopxa2DQIq89Qe5PS9X6t605H60tp3d62d8J2QVgdRm83m9LCT5n2C62vqfVo6nxoVp3p9TpoVlgpRmO3nFL2//j5c+uM1tfROrQM/aBASgpoHa2DC+gHBVJSQOtoHVxAPyiQkgJaR+vgAvpBgZQU0DpaBxfQDwqkpIDW0Tq4gH5QICWFM59lSlEUVVkxWme0DuWhHxRISQGto3VwAf2gQEoKaN2X1kfXDBB/CpsDYSmQkgJad6F1fWGAbhutVwbCUiAlBbTuQusd+gpf+rgeNgHCUiAlhXGt81mma2rdhqW+KgZh9TEWsSpyPD6ZudQXH3q3stbtORZG6BWDsDqMPielDjsldRIGrT9a6/YcenTm0HplIKwOtD6VOVpnEmYFrWefGk3dzQxMrSCsFCZhRpkzCcNofR2tpxIflTUqrwyEFZHtcFLKwiSMlxqahDFe1GicSNg6CKvPUHuTUpZpWucp0/W1bm/bO2G7IKwOo7dJqeOup0x5gWMprUdT54MvbGR6vQoQVofR2KTUZ+i+z9uRHGkdWoZ+UCAlBbSO1sEF9IMCKSmgdbQOLqAfFEhJAa2jdXAB/aBASgpoHa2DC+gHBVJSQOtoHVxAPyiQksKZzzKlKIqqrBitM1qH8tAPCqSkgNbROriAflAgJQW07kvro2sGiD+FzYGwFEhJAa270Lq+MEC3jdYrA2EpkJICWneh9Q59hS99XA+bAGEpkJKCqnWW+lpH6zYs9VUxCKuPsYhVkePxQPZ/9/lLfbGC42pat+dYGKFXTMvCijD6vNmU0kzslMYX5mW0vo7W7Tn06Myh9cpoVlgpaN0mve+jdS8VNWj2qdHs+WMGpkoQVgqTMBHpnX3OJExnc7T+UK1n/6uyZY3KK6NxYaVkO5yUrkuN1sUPSELrs7XePzfZJ0aUUwubBmH1GWpvUrouonVG6ytr3d62d8J2QVgdRm83m9LCT5nqL4ZB68tqPZo6H5pVZ3q9DpoVVorR2C2nlP0/fs7c+qRC63dqHVqGflAgJQW0jtbBBfSDAikpoHW0Di6gHxRISQGto3VwAf2gQEoKaB2tgwvoBwVSUkDraB1cQD8okJLCmc8ypSiKqqwYrTNah/LQDwqkpIDW0Tq4gH5QICUFtO5L66NrBog/hc2BsBRISQGtu9C6vjBAt43WKwNhKZCSAlp3ofUOfYUvfVwPmwBhKZCSwojW+6vystTXClq3YamvikFYHSz1JTJzqS9lPV60vqDW7TkWRugVg7A6jN4mpQ7DBmjdkdbtOfTozKH1ykBYHWh9KpO1Ls7AoPU7tZ59ajTtb2ZgagVhdRiNTUoRcyZhJo3c0fpsracSH5U1Kq8MhJWFuXWFaaN1tL6O1vvnxnhRo3EiYesgrCxoXWH+3DpaX0fr9ra9E7YLwuqwnwxc/XCcMv8p0/70OnPrK2s9mmEcmlVner0OEFYf5tYVjJR4O5IXrUPL0A8KpKSA1tE6uIB+UCAlBbSO1sEF9IMCKSmgdbQOLqAfFEhJAa2jdXAB/aBASgpoHa2DC+gHBVJSOPNZphRFUZXVkqP16/UlJdb51Yvix0D5KfqBlBZMCa0Xi774MVB+in4gpQVTeqzWQwjZbfuSLZTRoKNBJe8vnXC73eVvG/2vozd05zkyfr1/VAve4oYKYZHSgik9ROvCO93//5LRRiPVb1A9rjSoGbl1KrfDT3fec47CwOPHaGM0UgiLlBZMqfBoPWuWFu7S2QZVlH2n1rOPGUNitR9gjCs3jtk4/vRgWuiE63A/UKQ0L6WSc+tZcTRyfx5q0OzjnB3ajFvv/+LQLdp2No7c2B66of7fYv9urYWwSGnBlFYarWfvn23egbvooyjER7g75Xv91UFx9hzZB6PoO72J1N3Z281+Ff+uTRfCIqUFU3qg1rP3yXQj+231lWp9ndsVHZpecvQgRxVs7Ewtnz2kigthkdKCKT1K69lhXXovHR0P1loztJ4d8M5LLGvwdOek8zJP69cpjzQVF8IipQVTetQrYa7J/VyXQgs1T+tGvOLtDpk6vYb0RzO0nn1siG432onWKVK6M6WHT8KkA71JQ7laq5TW0+vJXsOojo2rHdoeenhQjqf6QliktGBKa8+tX9H6L6Of+reno9qsbcVHiP5v2UNjUeXp1UYXG7qVIe8P2b/KQliktGBK62ndtlJK8XQeHX02KKMM6+lxpY8B6fUsdWrE64n2zPu7tl4Ii5QWTIk1YYpFX/wYKD9FP5DSgimh9WLRFz8Gyk/RD6S0YEpovVj0xY+B8lP0AyktmBJaLxZ98WOg/BT9QEoLpoTWi0Vf/BgoP0U/kNKCKaH1YtEXPwbKT9EPpLRgSnyWKUVRVFW15Gj96/M7Sqwzn6EOPegHBVJSQOtoHVxAPyiQkgJa96j1EMLomVMuAxsCYSmQkgJad6T1ztRDyjbfhQ/bBmEpkJICWveldVvZyjZsFISlQEoK41r/6ONPboXWH6p1RdPRcH50dA8bAmH1Gfo3lJT6GClZWu9sjtb9aD29JFqvAITVYdwXSKnDTknSOpMwj9b60AmL9mdH6Gi9AhBWB1qfymStMwmzgtaN50IVlaP1CkBYfZiEEblrEkYZuaP12VpPT5W9n7n1+kBYHYzWpzJ/EgatO9E6c+tVgrA60PpU0LqXume0Lu6HDYGwOtC6wvynTK+8wNG31oemIGFzIKw+zK0rzHyB46RC60tpHRqEflAgJQW0jtbBBfSDAikpoHW0Di6gHxRISQGto3VwAf2gQEoKaB2tgwvoBwVSUkDraB1cQD8okJLCmc8ypSiKqqwYrTNah/LQDwqkpIDW0Tq4gH5QICUFtO5R68q7RnlnaWUgLAVSUkDrjrQ+uiLj6Mq9sF0QlgIpKaB1X1q3lc166xWDsBRISWFE6/2P0WAFx4dqXdE0661XDMLqw1JfCjOX+uKzTB1qnfXWqwRhdbAwr8JdC/Oi9XW0PnTCov3ZETparwCE1YHWpzJH6+IHVaP12Vo3ngtVVI7WKwBh9WESRmTOJAxaX0fr6amy9zO3Xh8Iq4PR+lQYrXup2Vpnbr1KEFYHWp8KWvdS94zWxf2wIRBWB1pXuPcpU7TuVutDU5CwORBWH+bWFWa+wHFSofWltA4NQj8okJICWkfr4AL6QYGUFNA6WgcX0A8KpKSA1tE6uIB+UCAlBbSO1sEF9IMCKSmgdbQOLqAfFEhJ4cxnmVIURVVWjNYZrUN56AcFUlJA62gdXEA/KJCSAlr3qHXlXaO8s7QyEJYCKSmgdUdaH12RcXTlXtguCEuBlBTQui+t28pmvfWKQVgKpKQwrnXxg0zR+p1aVzTNeusVg7D6sNRXSnacN2epr77N+YhqJ1pnvfUqaVlYESzMm2Lf66ctzIvWV9P60CmM9mdH6Gi9ApoVVgpat8ku0N3/lkkYF1o3ngtVVI7WKwBh9WESJkuaCZMwvmreaL2/wdx6TTQurD6M1m3uHa2jdYdaZ269ShBWB1q3Qet+657RurgfNgTC6kDrKUs+ZcrcunOtD01BwuZoVlhZmFtPSTMxUuLtSO60Dg1CPyiQkgJaR+vgAvpBgZQU0DpaBxfQDwqkpIDW0Tq4gH5QICUFtI7WwQX0gwIpKaB1tA4uoB8USEnhzGeZUhRFVVaM1hmtQ3noBwVSUkDraB1cQD8okJICWveodeVdo7yztDIQlgIpKaB1R1ofXZFxdOVe2C4IS4GUFNC6L63byma99YpBWAqkpDCudZb6WkfriqZZb71iEFaf1pb6UpbxGspk8lJfLMzrUOv2Ep2wUWoV1gzsJWdXP5yHY9+jh/Z022jdUc14yrR/CpmEqYwqhTWP1rTeRxmMD/3X3oHWXWjdeC5UUTlar4DqhTWJ1iZhrtrnlGafbJus9f7cOlp/nNbTE2zvZ269PioW1lQYrSt7jLv/hFfCoHUnWmduvUqqF5YOWhf3pP/Q35BG62jdldb1/bAhqheWTmtav+cp0/TbKy9w3LrWh6YgYXNUKazZtDa3nv69yp7+/v4e3o7kUevQIPSDAikpoHW0Di6gHxRISQGto3VwAf2gQEoKaB2tgwvoBwVSUkDraB1cQD8okJICWkfr4AL6QYGUFM58lilFUVRlxWid0TqUh35QICUFtI7WwQX0gwIpKaB1j1pX3jXKO0srA2EpkJICWnek9dEVGZP1evML/cAWQVgKpKSA1n1p3Va2sg0bBWEpkJKCpfVoea/RNb/Q+j1aVzQdDedHR/ewIRBWn9aW+hoiu7DX6J5BrUcGVz4mCa2vo3V70U7YKK0Jy6C1hXmHSB/YlD1XfbSO1h+t9ehUjZ5mJmEqoylh2aD165SF19G6o+o3qPFcqKJytF4B7QhLgUkYtL7Jmjdaz55OtF4B7QhrFEbr6V1b2ehA69vTOnPrVdKIsBTQ+jX3OaXKnhtofXta1/fDhmhHWKOg9Y70rq3sGXklTGRzXuDoTetDU5CwOVoTlg1z6zfSEJQ9vB3Jo9ahQegHBVJSQOtoHVxAPyiQkgJaR+vgAvpBgZQU0DpaBxfQDwqkpIDW0Tq4gH5QICUFtI7WwQX0gwIpKZz5LFOKoqjKKjx59vyL84f763A8Xa8vKbHOr14UPwbKT9EPpLRgSmi9WPTFj4HyU/QDKS2Y0hpaDyGMHopymZrKaFA7itz6jhNut7v8baP/dfSG7jxHxq/3j2rBW9xQISxSWjClB2o9MkhaWXE0cmfuN6iRQ5qG/a1SncrtE5TuvOe8DD1+DP2lLfRAvxAWKS2Y0mO1bktK2a61sg2qKPtOrWdPx9DZsR9gjCs3jtk4/vRgWuiE63A/UKQ0L6VHaV3RdPjV0WIwB4+V1VCDjoYwVbXGldi3aNvZOHJje+iGoscY8RZrKoRFSgumVF7r2fFa8WhWiD6KwmAo2GxWo+l1IQ89mtoHo+g7vYnU3dnbzX4V/65NF8IipQVTKvmUafa+bVy+pkq1vs7tig5NLzl6kKNn0NiZdkL2kCouhEVKC6b0EK2Lwz1l3FdrzdB6dsAbRSpW1uDpzqETN3qdutavUx5pKi6ERUoLplR4tN7fyOq+1pqn9WxckxJTHmKzNzd6K9njyT42RLcb7UTrFCndmVJ5rac6aOHOXErr6fVkr2FUx8bVDm0PPTwox1N9ISxSWjCl8lrX99dU0evWlV9JR7VZ24qPEP3fsh9NRZWnVxtdbOhWhrw/ZP8qC2GR0oIp+dL66JCwmpqn9f7GvLFt+hiQXk8YY9JtjV5PtGfe37X1QliktGBKrAlTLPrix0D5KfqBlBZMCa0Xi774MVB+in4gpQVTQuvFoi9+DJSfoh9IacGU0Hqx6IsfA+Wn6AdSWjAltF4s+uLHQPkp+oGUFkwJrReLvvgxUH6KfiClBVP6X9Z+leRZnpRFAAAAAElFTkSuQmCC)
。如果把id一列去掉就正常了,如下图
![图片点击可在新窗口打开查看](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYsAAAEGCAIAAAAbrC7aAAATkElEQVR4nO2dX8skRxnF60vNV8g38SIgCIIXguAS8EJQBGEuhDheex8GxAtvoiFRx6jEbJToqknMbsZNMrvZzUalvRjo1NZTVX26p/pf9e/w46Wnp6a7+sl7Tqrrna51v/hLAwCwTNyPfv4hAMAycd/+8c8AAJaJ++mr92/kzbffv+x3z975CcCzd35y2e+e/fd/kOdwPM3eh+VzOJ7KJdTdlwGe3X35st89/eK/kOdwPM3eh+VTMqE+f/tHFeOcy78baPYOz8hlv/vs2X8mwznnb/g/bUurKbvqczie5jp1qj62nrPXqmhC/WlfE9Hf5ucy6PnGmZdb47LfPXr6xZQ4564/rxvtnmiz/J7JOBxPc526LZfd72shVSqXUG/9sEqcc5mXepvtcNnvLk+eTYb9n0ewM9PSf3diDsfTLOcNCpJ/a/ZaDU+oJ0+fBQn19I8/qBXnXLBhGwSavc/TF6flst998vjzibmWvd0ONqIvo3sm43A8zVKl/B7/dzh4d5ZaDUyoR4+fPHr8JEyoP3yvMqL/y/0yg55vmXlZN/ZiL/vdw8vTKXHOXX+2G/7+9q2MJu7ww8vTw/E0cYn8KvkX7lcg2LA/p69S74T65NPHV4KEevL771aGc272PiwfW6XLfnf+9MlkOOf8Dfsz1dI2mJLD8TTXqVMX3hYtU9Lpq9Qvoc4PLy1hQr35ncpwziltWgUvlY9XgL3My3734OPPJsY5Z1/anVbTd/XK4Xia69S2Mna/X8BoMSerUo+Euv/RJz5hQv3upcpwzultrhv+R5SPV4C9zMt+9+HDx5NhQ6fdb1umNqbncDxNfMZoQAcVC3ban9NXSU2of91/GBAk1Ge//XZlOOf0NtcN/yPKx1fNnTt37ty545y7brT7L/vdB+dHU+KcCzaC7evLlCbu7ZXD8TT9SW2hbJU6KzlxlaSEeu+DjyxhQv3mWzXhnBObtQpeikdYNdErvex37z24TEzbk/Zl+zPaePoeBhyOp1nO61fG1iEoYGclJ6hSd0L9/Z9xgoR6/Otv1oRzrlez64b/KfEIa8de5mW/+8eHn07GNZgyL9udGU3Z4SuH42n6KnVWINhjKzl9lToS6t17/0oRJtQb3wB4/MY3LvvdvQ8+gTyH42n2PiyfjoT687vvZQgT6vWvAzx+/euX/e5v738MeQ7H0+x9WD4ln3p59NrXAB699rXLfvfuPx9CnsPxNHsflk/RhPrVVwEe/eqrl/3uL3//N+Q5HE+z92H5lEyoyy9fBLj88sXLfvfOvTPkORxPs/dh+RRNqFe/AnB59SuX/e7tv34EeQ7H0+x9WD6H48m9+fb7t3PZ7wBaDscTQBFckd/IB+fPAK6c799tUJeokqLz/buueev7N0JCgQ/eU0SVFI2YUM656Ha+JVQA3lNElRSVT6jOL9f7LYMNqAO8p4gqKZpzDBVNKNKqAvCeIqqkqCOhXnjplZHmocRxFqwRvOer/a0O9m+5SrYmmSolE+qFl165JaHyN3GMmypmy94LFJjQf2uzVbI1yVdplDFUfr4piCQSqjI26z0rEspq/oSKzojbGOIWr1Y2672MuMuzsjXpd5c3LKFsHnXmDqlUGXgvkDVes/mEUuKpGfsuL/MNA9sYqmHj3gsUNV6z7YQS46mZeB7qAQm1DbbsvUAp4zUbTig9nhrlb3lKSHUmVDDNlJqBYiqqDjbrPavgF9t/a7NVsjXJV4nn8qAwm/VeL1ElRSQUlAfvKaJKikgoKA/eU0SVFJFQUB68p4gqKSKhoDx4TxFVUkRCQXnwniKqpOh8/26ZVYDP9+8CABSHMRQU5szoQBBVUkRCQXnwniKqpGjEhOp82EV8F1YH3lNElRSVTyj9iRaXXeIO1gveU0SVFM05hoomFGlVAXhPEVVSlEuoW54c7oQnhysG7/mKPhDbbDuhbE0yVYonlB9MnSHFOuXgs2XvBXKsAmxka5Kv0igJlZ9vCiKJhKqMzXrPioTKyw6aeq++MuAuLzojbmOIW7xawXtW3OUFsvd0/e7y9Hiyf8t7EFvBLvMLTSpVxsa9Z2WN12w+oa66aQwlxlPmLs8OizrnpKAC8J6vaDw1JFTTNLcklB5P+jzUAxJqG+C9Vql4ajacUMVmyn1uTKhgmik1A8VUVB1s1ntWwS+2/9aWq2QLEi1Rw3N5MAZb9p4uqqSIhILy4D1FVEkRCQXlwXuKqJIiEgrKg/cUUSVFJBSUB+8pokqKSCgoD95TRJUUnVmnHACWDGMoKMyZ0YEgqqSIhILy4D1FVEnRiAnV+bCL+C6sDryniCopKp9Q+hMtLrvEHawXvKeIKimacwwVTSjSqgLwniKqpCiXUKxTDsPAe74yz8TO0p9lqveTw6xTDoPBe60cqwALylep+y6PdcqhF3ivFQnVV/0SathdXnRG3MYQt3i1gvesuMvrVL+7vMFjKJtHnblDKlUG3gtkjdeQUAlNepeX+YaBbQzVgPd8ReOpIaESUhNqjH8v7wEJtQ3wXqtUPDUklKeBM+W3fNvA3uX546nktwyYiqoCvNcq+MX236JKvqIlanguD8YA7ymiSopIKCgP3lNElRSRUFAevKeIKikioaA8eE8RVVJEQkF58J4iqqSIhILy4D1FVEnRmXXKAWDJMIaCwpwZHQiiSopIKCgP3lNElRSNmFCdD7uI78LqwHuKqJKi8gmlP9HiskvcwXrBe4qokqI5x1DRhCKtKgDvKaJKiroTinXKoS94z1fmmdhZ+rME2ZoMfHL4ln9JIX8Tx7ipYrbsvUCOVYCNbE3yVcqtvjJ4DJWfbwoiiYSqjM16z4qEyssOmqZIqOiMuI0hbvFqBe9ZcZcXyN7T9bvLa4Opb0LZPOrMHVKpMjbuPStrvGbzCXXVrWMocZlN1ikHH7znKxpPDQnVNM2NCXXL3/JSqURCbQG81yoVT82GE6rYTLn+5zzWKQefzXrPKvjF9t/acpVsQaIlanguD8Zgy97TRZUUkVBQHryniCopIqGgPHhPEVVSREJBefCeIqqkiISC8uA9RVRJEQkF5cF7iqiSojPrlAPAkmEMBYU5MzoQRJUUkVBQHryniCopGjGhOh92Ed+F1YH3FFElReUTSn+ixWWXuIP1gvcUUSVFc46hoglFWlUA3lNElRQlE8pfemXAk8Od8ORwxeC9Vjw5LKr3k8PKoiviGCo/gEo1gPWC91pZy7WiSq3cgNVXbkyo/HxTEEkkVGXgvVYkVF/1SCjxFs8mVHRG3MYQt3i1gvdapW7xGhLKqN9dXq/xFOuUgw/ei4p5KEXqGGpwQl1xz6+lGeyPNoZqwHtRkVCKhsxD3b4KcHQ7vxPWC95rlZ8Dnrw7C9WQmXJ/Kur2mfJgmik1A8VUVB3gPV/MQynKVInn8qAweE8RVVJEQkF58J4iqqSIhILy4D1FVEkRCQXlwXuKqJIiEgrKg/cUUSVFJBSUB+8pokqKzqxTDgBLpswYqmnuAQCUhYQCgOUyekI55zKnt98mVzrtN+s8fq8DXjf8n50dFk8xoId+rwqeEWBFlE+ozida/NPnXwboRw4SR6FNpfxn7c5b8sIlorDzugA2wohjKCV9eiVUtFn+sKK9o2GXyohMMnYeWbwK+5Z4xlQDog1Wyrh3edGkCBrobheJhoieJvme9zV/5sLze4I+Z+Isut+ZVC37ewMwDaMklJ4Rw/yfDz7FzKlP2UTwN8TrynfAP4WNoeh5oz/z54p+HGB1jJVQ4/U440N7arEnYhwoZ7RHthHW2cNUYOXjhoSC+pgtoaLDh7yZm+dN26Tt5xLq7JJ9aXf2PWy+LJ1xY7Opsz5+VfX/IgALZM6E8jei//+PfiRomT+X6MxU6ESzL7XR65JTijZo5ITKn2vU3ySAMVhTQgXtA9dFPzUsPlIf70yWfAei26mkU/ojXkWvOgAsilG+D6Wc2I4Rooa3R+v0fKqx3iX/s6kjiKlkDxs0S50lFWH56Mmci5CCNTJnQvkb+kghaJlPOqvUMe1hgzMOO3LqXJ3HsdfVt8IAFcBzeQCwXEgoAFguJBQALBcSCgCWCwkFAMuFhAKA5XJmnXIAWDL8Wy9QmDP/iokgqqSIhILy4D1FVEnR6AnlnOv8hVbawIrAe4qokqKxEqoNnVT6ZB77mN1gcCN4TxFVUjRiQuXTR9mGlYL3FFElRbmEeuGlV670TSglcYJBVueYC1YE3vPlPQH+nKiSr0yV4gnVBtOoCWVbklAVgPda+ZYL7EeVWuWr1JFQI82U+zd93OVVBt5rRUL1VY+EGnaXl5kCV1KJhKoAvOeLuzxRA+/ylPHUsDGUv8E8VE3gvVaMofpqyF3eeAnFPFSV4L1WJFRfLSuh9P2wIvBeKxJK0ZCZ8uaGbxv46ElkvzMFKwXv+WIeSlHvbxv0gufywAfvKaJKikgoKA/eU0SVFJFQUB68p4gqKSKhoDx4TxFVUkRCQXnwniKqpIiEgvLgPUVUSdGZdcoBYMkwhoLCnBkdCKJKikgoKA/eU0SVFI2eUMp3xPkeeWXgPUVUSdFYCdW5VkHn8iywXvCeIqqkaMSEyqcP60NVDN5TRJUUJRPKX8Gu79oGSuKwPlTF4D1fPDmsqPeTw6xTDoPBe61YfUXRwNVXBieUT34eyrYhoSoA77UiofqqX0KJ/54C65SDD97zxV2eqH53eYMTKoB5qA2C91oxhuqr0cdQAcxDbRC814qE6qtlJZS+H1YE3mtFQikaPlM+ZULZ70zBSsF7vpiHUtT72wa94Lk88MF7iqiSIhIKyoP3FFElRSQUlAfvKaJKikgoKA/eU0SVFJFQUB68p4gqKSKhoDx4TxFVUnRmnXIAWDKMoaAwZ0YHgqiSIhIKyoP3FFElRaMnlPIdcb5HXhl4TxFVUjRWQnWuVdC5PAusF7yniCopGjGh8unD+lAVg/cUUSVFuYQSFym3CaUkDutDVQze88WTw1a2Jr2fHPaDabx/SYH1oapky94LxOorVrYmQ1ZfuSWhfPLzULYNCVUBm/WeFQmVlx009VgfathdXmYKXEklEqoC8J4v7vKisjWZ7i7Ph3moDbJx7/liDJXX8DHUNAnFPFSV4L1WJFReS08ofT+sCLzXioSyKjNTPngeKkBPomCiCtbLZr0XFfNQVrYmmSrxXB4UZsve00WVFJFQUB68p4gqKSKhoDx4TxFVUkRCQXnwniKqpIiEgvLgPUVUSREJBeXBe4qokqIz65QDwJJhDAWFOTM6EESVFJFQUB68p4gqKRo9oZTviPM98srAe4qokqKxEqpzrYLO5VlgveA9RVRJ0YgJlU8f1oeqGLyniCopyiUU65TDMPCer609Oaw8FZyqSY8nh1mnHAZTq/cGKL+uyOTdGV32epU97fZECeWTn4eybUioCqjSe8O0tYTypQyR2j02vK4qn1CZKXAllUioCqjee720tbu8RluD3N73Nb0Syp+HYp1y6EXF3usrxlDKnmAk5Uv6Wx7rlEMvqveeLhJK3OPfZvkNOsZQYyeUvh9WRPXe07W1hLplpty+bFinHMagSu8N1tbmoez1Knv8/f4ensuD8tTqvbKiSopIKCgP3lNElRSRUFAevKeIKikioaA8eE8RVVJEQkF58J4iqqSIhILy4D1FVEnRmXXKAWDJMIaCwpwZHQiiSopIKCgP3lNElRSNnlDKd8T5Hnll4D1FVEnRWAnVuVaBWZTlS81uMLgRvKeIKikaMaHy6aNsw0rBe4qokqJ4QgVPC3c+Qsw65eCD93xt7cnhlKLPCXfuiSRUEEbKYpusUw4+W/NeRltbfSUlm9HKnkYZQw1IKJ/8PJRtQ0JVwKa8lxcJ1fRZKGqKhMpMgSupREJVwHa8p4i7vGUlVADzUBtkO97rFGOo9qp7bbSaOaGYh6qSjXhPEQnVxNYgV/ZcNf8YStwPK2I73usUCdXKjo+UPcm/5QXB1OvbBj56EgUTVbBetua9vJiHusoWQdnDc3lQnq15b5iokiISCsqD9xRRJUUkFJQH7ymiSopIKCgP3lNElRSRUFAevKeIKikioaA8eE8RVVJ0Zp1yAFgy7r3z0xs5HE9Ncw8AoCwkFAAsl9ETyjmXOb1d+UDvutJYPGDb7Lrh/+zscK8+9+qh36uCZwRYEeUTKurhlLvyL6MEaRJtoJw6eli/WSqhOvfopKIw1W2yCbbGiGMoJX2GJVQ+fZTtzmMGO/Nn13ubutjOt8QzZjqcOb54LQDTM+5dnsuOR5r+9y8ZV6dO2tmHoDP5ntuDdCaUuN+eyK9Jrwu31x5cUWq//nsDMA2jJJTNnVQG9fW/btS8XTOfSuVa/qJSHYtekX8u/+P+cYIN+3NYETKfytcHYBbGSqgJup4xp/V5vldiHNiWnRcbjbDOq0gFVrRLmcv3O5A/KfEEy2S2hIoOHzrNnJc9u5hQ0QaphEqdV7lkcWfTJzQzH9dLQULBMpkzofyNXlGSb5Y6cuawSthFD673NvhIStEGDQkFW6XahLIHzB82mjjBRzqTJd/J6HYq6ZT+dJ6LhIK1M8r3oZQT2zFC1PCi+W/Zb7vktx9wtFSuRZulzpKKsFSQpc6l7NH/qwFMzJwJ5W/oI4XOZlG3RzMiaJB56R8kJbHi4nGCPQPqA1ABPJcHAMuFhAKA5UJCAcByIaEAYLmQUACwXEgoAFgu5/t3/w9e6yxjMFzLwQAAAABJRU5ErkJggg==)
、
代码如下:
Dim t As Table = Tables("产品")
Dim g As Subtotalgroup
t.SubtotalGroups.Clear()
t.GroupAboveData = False
t.TreeVisible = False
g = New Subtotalgroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "产品"
g.Caption = "{0}"
t.SubtotalGroups.Add(g)
t.Subtotal()
Dim r As Row
For i As Integer = 1 To t.Rows.Count(True) - 1
r = t.Rows(i,True)
If r.IsGroup '如果是分组行
Dim f As String = "产品 = '" & r("产品") & "'"
Dim v As String = " 数量:" & t.Compute("count(数量)",f)
v = v & "金额:" & t.Compute("Sum(金额)",f)
r("产品") = "产品:" & r("产品") & v
End If
Next
请问这是怎么回事呢