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

 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,4587,5211,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,3742,4536,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,1497,2574,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,2632,3681,2,1049,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,9615,10182,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,7447,9545,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,6327,7404,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,5255,6276,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,'Line1', -20,10195,10206,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,9565,9576,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,7415,7426,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,6290,6301,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,5225,5236,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,4560,4571,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', -15,3705,3716,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,2595,2606,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', 443,1435,10223,1,8788,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,1440,1451,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', 1267,4656,5136,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,3846,4431,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,1911,2151,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,3036,3276,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,7926,9066,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,6681,7041,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,5451,6081,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', 1275,9615,10140,1,525,-10,'رديف','B Nazanin',12,1,315)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 240,7806,9921,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,4966,7801,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,'LBLpagehead', 750,8205,9810,1,1605,-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', 750,5450,6500,1,1050,-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', 750,6456,8157,1,1701,0,'@<افراد.شماره نامه خروجي برابر با>@','B Nazanin',12,0,390)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'LBLpagehead', 750,4281,5406,1,1125,0,'افراد.تاريخ ابلاغ','B Nazanin',12,0,390)
insert into zreprec (repid, objname, objtop, objleft, objRight, Chinesh, objWidth, objtag, objcap, objfonname, objfonsize, objfonbold, objheight) values (xxxY,'Line2', 1684,1456,10216,1,8760,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,10196,10213,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,9566,9583,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,7416,7433,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,6286,6303,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,5221,5238,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,4561,4578,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,3706,3723,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,2591,2608,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,1446,1463,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,1436,10224,1,8788,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', 1190,1461,10206,1,8745,0,'zpptz67','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)
