rdlc报表 矩阵控件下的按组分页

8/3/2015来源:C#应用人气:2170

rdlc报表 矩阵控件下的按组分页

场景:使用rdlc开发报表,例如订单产品报表,显示多个订单,一个订单有动态生成的固定的多个产品组成,同时统计每个订单里多个产品数量总数。数据库层面分析:此报表属于交叉报表,例如5个订单,3个产品,总共的数据库记录应该为15条,而不是5条。存在的技术难点:(1)动态列生成使用Matrix矩阵控件(2)统计每个订单里多个产品数量总数确保每个订单的第一条数据是正确的,第二条或第三条数据为NULL都没关系(3)控制每页显示33条记录,而不是通过默认的高度来控制分页(4)由于是使用矩阵控件,所以分页下序列号需从数据库中控制好最终完成的效果:ipPS30NH+sJTH2Rmoa4fFAjnwQjfXEA/EELhNO8CIejHzgjeTQ05IQRD4IPSPyUejB0IPBBPhjI/LR0BXjAE6GShaj0NPSGEQh9Caa50M/qD+iRyM5majxWAlGsj/W/ICMPez7ZjwxkokWT2DgwcDDnl8DQw+GnhFPaur6WIFH6lq9lTQygwmoSULijfQ8sUdD2Q/1IDLCCY48EnhwONJ8304Cuxpq+UjzPDIOSDKG6ViLPTX01djTYk8LPRhOcOARz7MmPvF8nIxxOjaSiRF7WugZoWcEHgw9Ixrr8VjNfRL0tdSzggGMPOKN9NCDwURPQuCN5MgHeWL6Ay2YgNAnfkDGQy0OiTfRohD6YyUOjMjXQ0+rLVz3XRKZgQfjAA9dOfbNLHKCMUpDOxgjbwjS0PaGi+3NYuKPF2v1tsb521ju6wleOQaisR6N9SREk6ESB9AbqWEAJuNF+9T9svKMkY8iH02GWhKScGSkPo6GRurjeHIRlYknMJ+Y6VhLAi5NucmEm0wEP5KiBIQTEkycYDwIJk46gslECz3N82E4scIJSSZq7LNe1PUiJvHkeAI9z/E8Enty4rNBIAa+EY5GyXCQjrXEEyeBNgnVxGdSj00mWjwxQl8NfM3znGDi5CMjH6uBhz2PBB5eaaJ/SOqO9kcwGKPII5FHAg8HE2sywf4Ehz4KfeR7ejDRQ89Y+hQJJ2Tx4x5cHj957Ia+OXCMsgwh0tIsnExGb483+MdOmoWjYX84cGmeAVWieRyMzXBCloaZ8XYzxbhgLqycHYt7F+fXkkda9pOkHoGBrwW+ulQMLjkQHHjnvVky0WpiT6vnRV0g8GDgG/HEWJ5ZS9MQx3/LCLnYme7BwINhADzf8MdGFlv1UIkjEAaa5xthRPyxGflo5DYyn6O+G7l2PCaLNVzGNwL/7Ww4weHiXjUIxCDgw4APfXFxcA6czBsFjpVNrGyMgr5AAzXx5CCw/IBkI6UY8HSo5I6ejMbeeDIMnGFAPI/4I5RPrGpiJUOQ+UutWOwRLVy0ueYPtDK2vb6eeCT3SeqBcKjmEUx9GEz0PLEjH8UB9kZ6Hrv+6E1+7zzvwQQrrLLKKhfF1MSWx5Y0tMSBKfRtcejKriUQ2PNGet8WXUuwCdMn/MSVRrYwdMVBXzT0hmsJQ1e0CTN0RRczE1caWuIyfUtexBb7Nm+TrmsxA0cYOMLAkQaO1LdFx+SHrjwZGBZmgwkYD+S+LdqEcS1m6PJ9V7BN3rIFxxJsi3UtxhuIY5cf21ziAdvkiSn0h9A0lYEpDE3ONSXHkixLXsSWHEtwLWFg1kiuKTum6piqa8quKb0VAtihow5sZeioNhawwQRjRBBjO7xlc31bHPf1YV+xbMG1tKGp+IT1CGs7suUoI1Mcm+zQZvsOM7TZoc32bbFvya6t2LZmOYrtyCNTHhNxZPFDm+3bfN/mXVvs2/zQ4ocm5zlKn4ieawxsdTIAQ0cdD1TX4iZDZTyQB47Qt0UL9Aa20ncUt6/apjjsK7bJ912hNpprMY7Zcy3OtTjH5AeONHBlxxJswo1czSEiAWzfkm0sjFzdIaJrypOBMRkYo75iYdYx2b7Nj/pS3xYvjuW+tuSVY2Bo8QOTG/Ulx2TrJoyH2qC/1GSL79v8yuMMHGnoyo7Jj/pKn/AjW+ojrh6T75yhJU5MyQVtCy44VnPQ50dD2XZ4ALuOqTqm7piqY8lDIgyJ4FiCZcmOCVxTHViMa7cst2E5nYHJDYhsmcCy9IHFDKyOY/ccS3AJHGA4JMLA6lk2Z9ncwOoNzd6QSANTci3GsQTHBC4BQ5MbmoxjSZalOpbsmj8a+pYydLSRqw8drW8pDpEsIvb7oN/XB67m2qJFOMtkbMK4FrfUiUrfUup11xZdW8Sg648NpPcGrjbqw/e+d2rqkqnLLp/6gcsl/7i55NKpqUumLr1k6p+89/LLpqb+x594z+VTUwNb71vK0jDjl1g59vgL5sLK2bG4d3HW14N/hZ9U+pbWtxTXYV2HueDIluzasmvLtrN4kJHF1gwtvm+Lri3WBc57EptdefyhJQ9XTM83c7Ez3RZdW+wPFMdVHBMMLOxgYCPdJgpBPMaSY+Nhf0SA4Y+1sctPTHWAtL6l1DU8j8O7ztvZ0JL75wswrtvtO91+bRNLHhC1j7WRpY9M2YXsxOEd0By7vGVLCHOpp4cOHzq8bysjBxGsW65uD1TbkW3CDYkwIpwL2aG11IrFs7N9h6m7xuurfSIOTMnFwsTVXMwNTW5kC8EEGGpz1FeQ0ZkMDG8ITMiN+/qFfu8878Kqq6yyyioXxZQNmYEpuFgwDcaEnIV42xT7jgKNnqF1TMwj0HVNaeBIUG9j0CWIGQ1UE/NAbw8cycKsg1jT6DqIXcZC/CKYtXDPRF0COwT2TMSYkDMhRwDrmhJQO1DruaYEta6uNGws2IQzEWNh1iKcRQSLCCbmTczahCOwB/Um0TuKsEAQD6FgABlCyUKCg3gLSSaSMD6PiQUTCxbiLSRYSLKgYiLNRIqJFne9iYGrAb2HAAv0nm1Ko4GhSM2Bq1m2BGDXNLou5jBhIWKxwROlN4TtPmpjwmIsuJDvA9bCHYu0HdxxcMfCrIX4+sgYCybmHcS7kHVQz0E9C/cs3DMxa+GeBTqm3rJAD2tdG/BIZ0zIY8hahNOUhqG1gN5GRschoo0Fh0gE8cQUCOJskyeIsUyGwI6JujZh6sPahLEJZxPOxDxBnENECwk2FqHWMyEP1K5DFBPy2OCxwWKDJYB1iDhwJMfkCexZmL04lvsa8ReMAdAjeofAHtTbBDHQ6BDE4XoMLAM5gs5jEcGEnENEG3IuFizQsyFzUZVxUM8y2n3MDC3ZQpKJNIx0gg0EVQJlgniCuwR3bcjZQERQRdAgAJpAMxFjojbCHEKiCWQTqAhqCGomkE3IE8QjxBMoE6iaUDQhbwPehCKCGgGGoxu2oSLEIyTaOrQNjeAuwW0TiiZQCZQJFP/hQQZfA3UOaCzUORNJjqlqGoMQbxGRIAaBrknqAcMsdaJgoXrW8CZmTdJzLcEmnENE11ZUqXPJJVNllVY0o7SktKSLS/ljQ0WzvIgX35YFzZPLp6YIECwkLA2z3hLskot7m7lw4cjsWbhTf+rNHnLR5vwFh106mol5EwuYLDpSF3Vc1FnyIayJ+SVYC/cc1HOWzvIDa/U2dbsITMwiwhtQxcaYqKFlTExj4OLR0PIIHCriAKrVwKZcTxvYlomUpaZdhDNZcsh1o9jltrimZGHWUJt9wjqIdTFH9I6JGIQ5THjTEiW5gUkP4pYBOo4rIczYJm+SDsEt22xYpGmBzoU9UnfKosWQ3gNqd2CrDpEsJDhEdLHgmDzUun1HMTE/cFXblCwi6mrHseTa8ivtudiz79a2q6yyyirvkCkHsbVwt7HgmpKJeYL4vqO6tjIaGK6t2KZkY9EhEgFc31EtItavGLIOER2TdzFXe9JlbCwsQjjH5PuO5FqCiXmHiI4l21i0iGhj0cQCAYI3Rn1LMbHQtxTXlBwiLn95cCzZNkXXVlxbHtjKnp0PPLV361P7Htu///HHtj70+K5tT+zZuXvnI3t2PLJ759bHL2T3zkd273xkz84te3Y8smfH1t07t+7e8djuHY/tXtr1JnY89uCBfY/v3vnIk3u2Pb59y+Pbt2zf+sBjjz2QFRO3rw5MYWjxpsXbjjwg6gCLA9zp445lMhbh+lAcQMEmjGV2bdJ18aJ0tohgEdEiokUEFwtL9mEWpRLhbFLfrODrewJ9S7OJYhPFseSBq7q23HcUiwgm5EeuPnQMDAQAWLJ0TBPzjiU4Jl/Hy/s275isa3G1Cjcxb5vSeAhksTF0jKELCBAsLDtYc0y1bxoYCH1LI4gfOhrQu/VFqK75RbDc1+cbyLmYm7jK0BJdS3BNybVl25RsU3Is2SFSTb1lGQRYi4j1cRzED0ypT/g+ubj6uJjrY2ZsKQ7QFmamX3np5SOHDh8+eOzwwSNHD+4/emjP0SPbjh3eduzg3qMH9x8+dODQoQOHDx46evDA0UN7jh7ac/jQgcMHjxw9cOTowUOHDx04fOjA0YMHjh7cf/jwnsOH9xw+tK/m6KF9xw/uPXZw/6GDTx868Nyxp44dO3Dg8KH9hw/tP/7UoeMH9h8+8vihozuOHdx77OC+o4d+NDxz7OAzxw4+feSpY4f3Hzu8//jRA88/c+Sl54/yfAsA3rUVxxLqOzYDR3BMdqkTRRuL9cyt4/EWZidDDWpdoPdCz7788ilKc0rzH1fhTmmeF3FZ5mka53FEq/zyqamhY9hYtAlXz9zF78ZLLu5t58KK7cxKXMy5K4u9TfkLDlg7kLpAHzN93F10IFiwiEBMgZj1ZxkXMy7pnq/e29bqbznXO8Aigmrwp87Ovfo8//wR5sQr7WeOfv/Q/pcO7H3pwL6Xd+989a7vPXP7rcdu/vYWWSbENOqA90U5EwvLFlYtrFpYXh6KNmEIbAFjwZsolskgwIz60CaaoUumqRlI0QnQLEjG2BobGuxg0sMG0ye8Rdq23XSHTdNp2hZrm+KFnbLCXFgcucAhiokUQ+kNHAMbrIkFZPCOoyODJ1A0kWQTZTQwlr36SnsuXvverW1XWWWVVd4hU64lWJitQ+AjV3dthUARIVFVe7atqSrrOAADwcKyTRTX0sYDJIot19ImQ0wA55qSaTBjR71AuK84AdC7tiM7lgQhZxHRslQLy4TIGAj9PiBQluVO39YdR7ewXItIAjgLCX1LqbdYWLawbKjMk3u2Xv2FT33+85+4+qorvnTd1ddcc/XnPveZ6679Ys21S1x37VXLXH9NzRevu/aL111z7XXXXLtc/k184fOf+/L111191Rc+8+lPXv+la6/8whXXf+na4cCmNLNtrU94FzMQ9SxbGiBpALk+7tpmxzI7NmEGUBhA0V5OPLhAuF9wvVxpH8tkLJOxcA+DNtJ7DpFcU7WJZmHVsnTD4ExTcRzVcVQLyyZSLKxjINUb+45aB9SXb0fUVyATMTbh+pZsIR5DbuBqBIq6zmIgOQ7AQDJNzcK6aWoDB1uWbmEVQsG1NNtW+o5q/v2u6yvHgIN402DqdjmmahOFELnu/RWohKiEyITIpqk4jl7XYfHOz2K7LqoCgmPwA6QNkAk13Zv0k9Rf0pYVLTNaxrSMaVVUVVHRuKJxRdOKZlVVVNWiIq1KWtWx16qoKlpVBaUhpT6t6mIFrTJapbSsaE6r4kLVV6WUxrRKaZXRsi6W0epHQJHHZZFUZVq/LYskTYIonEhSF2Op76iOJZiYtS3WJgwG7R8k3DHomohxTanvqFDnLrlkKowmtbQty7xcXPIfG+qOXFwpC5on75maImB5XqyQxSsny1vXz8+jC4T7DxTQi8Z/8/b6y/8K4c5cINyJeHHC/YL58paSfxeEyNi2XnylcfyIcea1SVUsfmurSppXNC/pQw82fvd3bvvsZ+4xUIgdAhD7Jrfwd0jb2ghIPQ+uE7q6ttXtD3nLYXTQc1zICSwxXWL2iekSd8KjsTxMmsDqQmCPLV1nB0T1HM1GbdNsmv0GsOaxxWDCW2RlPy4GUCwiECi6lqHJHEZa6A0I1k2kuC4cDW1VE3xvUOfOASAiJC6FTsRFD/9u7bnKKqus8i6YMhGDQdfGgm2KFhFHI5xlXp6FWRrkWRgGY1plcTQps7DMwjgYBf6Q0iwORnEwyKKBhYQ+lmzI2ZBZZjkXgiDOtpUkGWbZOAzdLPOKIkjTSZ6FZREnsZfEHqXZaGjnuR9Fw6oKIt+xkECA4JoqAQLUufq+v4XVPbu3X3vNF2iVZWkcBh6taBRFYZTUREtLHAUXEEZLJHGYrHh7AVmSZkkaBSGtaJHlWZLGYWRoelFkUBdsg7VAR9NbxORso2dpLRN1CW4T0rBRa2AwrsERxCHMmIixYXep+YwJORty9lJOiAm5ZfvUaRuuxdmEc4gYB24ajdLEj8JxnoVFHmWZ53lOHI9oEWexl8cBzZMg6EdRP/Idi4gE8RiyFmah3sagbaIuMjoE9uqUfRMLke+E4YDSLPCHUTiuyiRN/LJI0sT3JoMij5LYS9NJEPQpTTzPwVgiiLsgm+ViWDkGBks3aup25cvtSoOaLA2yNMwWV4LAH0bRsG5XnUxVt+ti69DHkgMVCyCo6VWZUJpQSss6NFyVtChpWVaUFpRSmlAaUZpUNK8orapF8V1VtDov9mlFS0ojSoP6LaW03lgtBZorSqulrZRmlCa0PhQtz0em69I/2teyKotM10SMJYuIGPag0UGwTWCHwM5SGhtfJ7Mtj8/6xpwJORMLus7+5E9eQmlelMmPa8Q9DH1Ky6LIiiJbjrhjg69tYqKuibrLiV5LG99ufXHLivL1+qKRVx6wbaKuCcU6C+tNJyKIJ4g3Ib/kY7u1e6n9CUI8wosncmDXrg91/oxvrc/KyfKWkn8XCMkGco8eazy1V3/hGRJnNK3iMKVpQf2MJhW9++6z7/+DtX/9sbsATnRsYFN8k1tYeXV4exbtIy4bhCCG4LZmzAHcinNnFLpBlgQF9VLa5sHWXfvuf3j7mkf3rt/7zFnFHVLq51UQeEXglcHAQSxGLUjaKmxii1u01ZstzBHE58mkLOLli8tdd39vw/p719xzx5133r5+47p77rl7MhmF0aQs4jSdVFVAoEgQv+jV3609V1lllVXeBVPI6GDQdSyJIB7qXByPKM2CcFyUSX9gUVrGcTiZjKLQT5Mgif1a/BZ5nCY+pQnUuZGr63LLAr1lCFwEQ9YwuDAaZrkfhIM0C7I8jOJJmoVJGnj+kNI8SYMkDcoq8fxBWcRlNrGxbOpsnZyDDdZEEjJ4wxCeOvDEJz7513meZmkchX4WhXmaRVkZZlWUlUmap2mapmktwVcseU2W5FmSL799E1VFPS8oiioM49FoUhRVUVSGYVBaIkMeIGlIJAx7g744QF0XtDHsQdTDqGnBhYHe6us9CAWABAJYC/QI7GDUwahDYM/Re7bRg4gFiCWAtRYL9OoCGHUQ6JqYz+JhkQZFHseRV5SJH4wozeLEC6NxfTlJojhL4zwLiyLIk0l9OwIBxjH5uhMtzGLQJbDnEBEbrIXlMptkaTAY2kkaBOG4olkYTfI8jWKvKLK8iIsyieJJUcZJ6gfhyLY1DNnl7rtYLhgDgMUGayEpi8dL7QrKIkuTIE2CNImSlaRBlkd5EaXphJAL2nWRdejUT1PYSCdAozTLq7io8rzMqjqcnlNa0pzShNKK5pRmFc0KWhaLUp7Wmr5YEqMFLXOaVzSqaFTQvFgqkFKaLsnWgtKClpRmlGbFCkG/LP9/JEtV0aIosqxI0zTLiqIoqopSWhq6ZBgcAiwC3Vq41w9ILBoQsIssjU/XEoDWUqSGiQWExEsuWUyVqaqievNSvN3Gf2TLYr8X9RAollNlapssD7Dztlpc584XACwB3NKWztKWxXUMOQwEDLmlidY