SQLName:فهرست پرتوكاران مركز بر اساس وضعيت كميسيون و شناسه مركز
GozareshName:خروجي جداگانه مراكز بر اساس شناسه مركز
SQLCODE:select personview.aztarikh, personview.eblaght, personview.gp, personview.melli, personview.perdarsad, personview.perfam, personview.pername, personview.shomare, personview.tatarikh
 , personview.marname FROM personview
 where 
( personview.hadaf=@<افراد.وضعيت برابر با>@ and ( personview.marid=@<افراد.شناسه مركز برابر با>@))

 order by perfam , pername
ZgozareshSQL: insert into zgozaresh(repname, porsid, arz, ertefa, sarsafhe, pasafhe, sargozaresh, pagozaresh, badane, Tofoghi, landscap) values ('خروجي جداگانه مراكز بر اساس شناسه مركز', xxxZ, 206, 294, 30,20, 0, 0, 8,0,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 0,5721,6345,2,624,0,'افراد.گروه','B Koodak',12,1,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 5,4876,5670,2,794,0,'افراد.درصد فرد','B Yekan',11,1,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 5,2631,3708,2,1077,0,'افراد.امتياز تا تاريخ','B Nazanin',11,0,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 0,3756,4833,2,1077,0,'افراد.امتياز از تاريخ','B Nazanin',11,0,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 5,10749,11316,2,567,-20,'/شماره رديف/','B Nazanin',11,0,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 0,8581,10679,1,2098,0,'افراد.نام خانوادگي','B Mitra',12,1,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 5,7461,8538,1,1077,0,'افراد.نام','B Mitra',12,0,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 5,6389,7410,2,1021,0,'افراد.كدملي','B Yekan',8,0,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 0,1419,2553,2,1134,0,'افراد.شماره نامه خروجي','B Mitra',9,0,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBL', 0,499,1349,1,850,0,'افراد.تاريخ ابلاغ','B Mitra',9,0,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -20,11319,11330,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -25,10699,10710,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -5,8549,8560,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -5,7424,7435,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -25,6359,6370,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -25,5694,5705,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -25,4849,4860,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -25,3719,3730,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -25,1379,1390,1,11,0,'482','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', 443,459,11345,1,10886,0,'11','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', -5,2584,2595,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line1', 0,469,480,1,11,0,'454','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 255,3560,5525,1,1965,-10,'شناسه مركز در سيستم:','B Titr',12,1,465)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 290,1820,3521,1,1701,0,'@<افراد.شناسه مركز برابر با>@','B Yekan',12,1,390)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1267,5790,6270,2,480,-10,'گروه','B Mitra',12,1,390)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1267,4980,5565,2,585,-10,'درصد','B Mitra',12,1,390)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1267,3045,3285,2,240,-10,'تا','B Mitra',12,1,390)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1267,4170,4410,2,240,-10,'از','B Mitra',12,1,390)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1267,9060,10200,2,1140,-10,'نام خانوادگي','B Mitra',12,1,315)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1267,7815,8175,2,360,-10,'نام','B Mitra',12,1,315)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1267,6585,7215,2,630,-10,'كدملي','B Mitra',12,1,390)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1260,1440,2550,2,1110,-10,'شماره نامه خروجي','B Mitra',8,1,285)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1267,570,1275,2,705,-10,'تاريخ نامه','B Mitra',9,1,300)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 1282,10785,11280,1,495,-10,'رديف','B Nazanin',12,0,315)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 240,8940,11055,1,2115,-10,'فهرست پرتوكاران مركز:','B Titr',12,1,465)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 290,6100,8935,1,2835,0,'افراد.نام مركز','B Mitra',12,1,454)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1684,460,11346,1,10886,0,'17','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1170,11330,11347,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1170,10700,10717,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1165,8550,8567,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1175,7420,7437,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1175,6365,6382,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1165,5695,5712,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1170,4840,4857,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1170,3725,3742,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1190,2580,2597,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1175,1375,1392,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1165,465,482,1,17,0,'510','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1170,460,11346,1,10886,0,'17','Arial',1,1,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'ImgPagehead', 1185,480,11355,1,10875,0,'zpptz64','FontName',10,0,0)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagefoot', 795,4680,5775,1,1095,-20,'/صفحه x از y/','B Nazanin',12,0,390)
