{"ReportVersion":"2018.2.1","ReportGuid":"2d87f3f042e50f1c03eaca40a4ae18cb","ReportName":"Report","ReportAlias":"Report","ReportFile":"zzvit_pos_sert_agr2020.mrt","ReportCreated":"/Date(1523922217000+0300)/","ReportChanged":"/Date(1523922217000+0300)/","EngineVersion":"EngineV2","CalculationMode":"Interpretation","ReportUnit":"Centimeters","Dictionary":{"Variables":{"0":{"Value":"IIF(Day(dp2_zajavka_obsteg.zajav_date)<10, \"0\"+Day(dp2_zajavka_obsteg.zajav_date), Day(dp2_zajavka_obsteg.zajav_date))","Name":"day_zajav_date","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"day_zajav_date","Type":"System.String","InitBy":"Expression"},"1":{"Value":"IIF(Month(dp2_zajavka_obsteg.zajav_date)<10, \"0\"+Month(dp2_zajavka_obsteg.zajav_date), Month(dp2_zajavka_obsteg.zajav_date))","Name":"month_zajav_date","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"month_zajav_date","Type":"System.String","InitBy":"Expression"},"2":{"Value":"IIF(Day(dp2_zajavka_obsteg.resh_cert_date)<10, \"0\"+Day(dp2_zajavka_obsteg.resh_cert_date), Day(dp2_zajavka_obsteg.resh_cert_date))","Name":"day_resh_cert_date","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"day_resh_cert_date","Type":"System.String","InitBy":"Expression"},"3":{"Value":"IIF(Month(dp2_zajavka_obsteg.resh_cert_date)<10, \"0\"+Month(dp2_zajavka_obsteg.resh_cert_date), Month(dp2_zajavka_obsteg.resh_cert_date))","Name":"month_resh_cert_date","DialogInfo":{"DateTimeType":"DateAndTime"},"Alias":"month_resh_cert_date","Type":"System.String","InitBy":"Expression"}},"DataSources":{"0":{"Ident":"StiMySqlSource","Name":"k2firms","Alias":"k2firms","Columns":{"0":{"Name":"OblastId","Index":-1,"NameInSource":"OblastId","Alias":"OblastId","Type":"System.String"},"1":{"Name":"adress_firm","Index":-1,"NameInSource":"adress_firm","Alias":"adress_firm","Type":"System.String"},"2":{"Name":"bankname","Index":-1,"NameInSource":"bankname","Alias":"bankname","Type":"System.String"},"3":{"Name":"code1с","Index":-1,"NameInSource":"code1с","Alias":"code1с","Type":"System.String"},"4":{"Name":"codfil","Index":-1,"NameInSource":"codfil","Alias":"codfil","Type":"System.String"},"5":{"Name":"comment","Index":-1,"NameInSource":"comment","Alias":"comment","Type":"System.String"},"6":{"Name":"directorname","Index":-1,"NameInSource":"directorname","Alias":"directorname","Type":"System.String"},"7":{"Name":"directorname_r","Index":-1,"NameInSource":"directorname_r","Alias":"directorname_r","Type":"System.String"},"8":{"Name":"directorname_short","Index":-1,"NameInSource":"directorname_short","Alias":"directorname_short","Type":"System.String"},"9":{"Name":"docstatut","Index":-1,"NameInSource":"docstatut","Alias":"docstatut","Type":"System.String"},"10":{"Name":"dolgndir","Index":-1,"NameInSource":"dolgndir","Alias":"dolgndir","Type":"System.String"},"11":{"Name":"dolgndir_r","Index":-1,"NameInSource":"dolgndir_r","Alias":"dolgndir_r","Type":"System.String"},"12":{"Name":"edrpou","Index":-1,"NameInSource":"edrpou","Alias":"edrpou","Type":"System.String"},"13":{"Name":"email","Index":-1,"NameInSource":"email","Alias":"email","Type":"System.String"},"14":{"Name":"firmid","Index":-1,"NameInSource":"firmid","Alias":"firmid","Type":"System.String"},"15":{"Name":"ipn","Index":-1,"NameInSource":"ipn","Alias":"ipn","Type":"System.String"},"16":{"Name":"ismycompany","Index":-1,"NameInSource":"ismycompany","Alias":"ismycompany","Type":"System.Int16"},"17":{"Name":"ismycompany","Index":-1,"NameInSource":"ismycompany","Alias":"ismycompany","Type":"System.Int32"},"18":{"Name":"mfo","Index":-1,"NameInSource":"mfo","Alias":"mfo","Type":"System.String"},"19":{"Name":"name_firm","Index":-1,"NameInSource":"name_firm","Alias":"name_firm","Type":"System.String"},"20":{"Name":"phone_firm","Index":-1,"NameInSource":"phone_firm","Alias":"phone_firm","Type":"System.String"},"21":{"Name":"projid","Index":-1,"NameInSource":"projid","Alias":"projid","Type":"System.Int16"},"22":{"Name":"raschschet","Index":-1,"NameInSource":"raschschet","Alias":"raschschet","Type":"System.String"},"23":{"Name":"rayid","Index":-1,"NameInSource":"rayid","Alias":"rayid","Type":"System.String"},"24":{"Name":"siteid","Index":-1,"NameInSource":"siteid","Alias":"siteid","Type":"System.Int16"},"25":{"Name":"svidnum","Index":-1,"NameInSource":"svidnum","Alias":"svidnum","Type":"System.String"},"26":{"Name":"typefirmid","Index":-1,"NameInSource":"typefirmid","Alias":"typefirmid","Type":"System.Int16"},"27":{"Name":"typefirmid","Index":-1,"NameInSource":"typefirmid","Alias":"typefirmid","Type":"System.Int32"}},"NameInSource":"k2","SqlCommand":"select * from k2firms where firmid=\"{mainfirmid}\""},"1":{"Ident":"StiMySqlSource","Name":"dp2_zajavka_obsteg","Alias":"dp2_zajavka_obsteg","Columns":{"0":{"Name":"CodKult","Index":-1,"NameInSource":"CodKult","Alias":"CodKult","Type":"System.String"},"1":{"Name":"Kultura","Index":-1,"NameInSource":"Kultura","Alias":"Kultura","Type":"System.String"},"2":{"Name":"NameUA","Index":-1,"NameInSource":"NameUA","Alias":"NameUA","Type":"System.String"},"3":{"Name":"NameUA1","Index":-1,"NameInSource":"NameUA1","Alias":"NameUA1","Type":"System.String"},"4":{"Name":"NameUA2","Index":-1,"NameInSource":"NameUA2","Alias":"NameUA2","Type":"System.String"},"5":{"Name":"NameUA3","Index":-1,"NameInSource":"NameUA3","Alias":"NameUA3","Type":"System.String"},"6":{"Name":"OblastId","Index":-1,"NameInSource":"OblastId","Alias":"OblastId","Type":"System.String"},"7":{"Name":"OblastNameUA","Index":-1,"NameInSource":"OblastNameUA","Alias":"OblastNameUA","Type":"System.String"},"8":{"Name":"SortID","Index":-1,"NameInSource":"SortID","Alias":"SortID","Type":"System.String"},"9":{"Name":"SortID1","Index":-1,"NameInSource":"SortID1","Alias":"SortID1","Type":"System.String"},"10":{"Name":"SortID2","Index":-1,"NameInSource":"SortID2","Alias":"SortID2","Type":"System.String"},"11":{"Name":"SortID3","Index":-1,"NameInSource":"SortID3","Alias":"SortID3","Type":"System.String"},"12":{"Name":"VirobnikNameUA","Index":-1,"NameInSource":"VirobnikNameUA","Alias":"VirobnikNameUA","Type":"System.String"},"13":{"Name":"act_auditor_fio","Index":-1,"NameInSource":"act_auditor_fio","Alias":"act_auditor_fio","Type":"System.String"},"14":{"Name":"act_brak_fio","Index":-1,"NameInSource":"act_brak_fio","Alias":"act_brak_fio","Type":"System.String"},"15":{"Name":"act_date","Index":-1,"NameInSource":"act_date","Alias":"act_date","Type":"System.DateTime"},"16":{"Name":"act_n","Index":-1,"NameInSource":"act_n","Alias":"act_n","Type":"System.String"},"17":{"Name":"address_jur","Index":-1,"NameInSource":"address_jur","Alias":"address_jur","Type":"System.String"},"18":{"Name":"agr_aud_fio","Index":-1,"NameInSource":"agr_aud_fio","Alias":"agr_aud_fio","Type":"System.String"},"19":{"Name":"agronomid","Index":-1,"NameInSource":"agronomid","Alias":"agronomid","Type":"System.String"},"20":{"Name":"akt_brak_auditid","Index":-1,"NameInSource":"akt_brak_auditid","Alias":"akt_brak_auditid","Type":"System.String"},"21":{"Name":"akt_brak_date","Index":-1,"NameInSource":"akt_brak_date","Alias":"akt_brak_date","Type":"System.DateTime"},"22":{"Name":"akt_brak_n","Index":-1,"NameInSource":"akt_brak_n","Alias":"akt_brak_n","Type":"System.String"},"23":{"Name":"akt_pol_ocen_auditid","Index":-1,"NameInSource":"akt_pol_ocen_auditid","Alias":"akt_pol_ocen_auditid","Type":"System.String"},"24":{"Name":"akt_pol_ocen_date","Index":-1,"NameInSource":"akt_pol_ocen_date","Alias":"akt_pol_ocen_date","Type":"System.DateTime"},"25":{"Name":"akt_pol_ocen_n","Index":-1,"NameInSource":"akt_pol_ocen_n","Alias":"akt_pol_ocen_n","Type":"System.String"},"26":{"Name":"cat_name","Index":-1,"NameInSource":"cat_name","Alias":"cat_name","Type":"System.String"},"27":{"Name":"cat_name_use","Index":-1,"NameInSource":"cat_name_use","Alias":"cat_name_use","Type":"System.String"},"28":{"Name":"catid","Index":-1,"NameInSource":"catid","Alias":"catid","Type":"System.String"},"29":{"Name":"cert_date","Index":-1,"NameInSource":"cert_date","Alias":"cert_date","Type":"System.DateTime"},"30":{"Name":"cert_dateto","Index":-1,"NameInSource":"cert_dateto","Alias":"cert_dateto","Type":"System.DateTime"},"31":{"Name":"cert_n","Index":-1,"NameInSource":"cert_n","Alias":"cert_n","Type":"System.String"},"32":{"Name":"cert_podg","Index":-1,"NameInSource":"cert_podg","Alias":"cert_podg","Type":"System.String"},"33":{"Name":"clone_name","Index":-1,"NameInSource":"clone_name","Alias":"clone_name","Type":"System.String"},"34":{"Name":"cpn_b","Index":-1,"NameInSource":"cpn_b","Alias":"cpn_b","Type":"System.String"},"35":{"Name":"cpn_k","Index":-1,"NameInSource":"cpn_k","Alias":"cpn_k","Type":"System.String"},"36":{"Name":"cpn_z","Index":-1,"NameInSource":"cpn_z","Alias":"cpn_z","Type":"System.String"},"37":{"Name":"datecreate","Index":-1,"NameInSource":"datecreate","Alias":"datecreate","Type":"System.DateTime"},"38":{"Name":"dateupdate","Index":-1,"NameInSource":"dateupdate","Alias":"dateupdate","Type":"System.DateTime"},"39":{"Name":"doc_mayna_date","Index":-1,"NameInSource":"doc_mayna_date","Alias":"doc_mayna_date","Type":"System.DateTime"},"40":{"Name":"doc_mayna_n","Index":-1,"NameInSource":"doc_mayna_n","Alias":"doc_mayna_n","Type":"System.String"},"41":{"Name":"doc_yakost_date","Index":-1,"NameInSource":"doc_yakost_date","Alias":"doc_yakost_date","Type":"System.DateTime"},"42":{"Name":"doc_yakost_num","Index":-1,"NameInSource":"doc_yakost_num","Alias":"doc_yakost_num","Type":"System.String"},"43":{"Name":"dolgnname","Index":-1,"NameInSource":"dolgnname","Alias":"dolgnname","Type":"System.String"},"44":{"Name":"dp_posad_name","Index":-1,"NameInSource":"dp_posad_name","Alias":"dp_posad_name","Type":"System.String"},"45":{"Name":"dstu_name","Index":-1,"NameInSource":"dstu_name","Alias":"dstu_name","Type":"System.String"},"46":{"Name":"dstuid","Index":-1,"NameInSource":"dstuid","Alias":"dstuid","Type":"System.String"},"47":{"Name":"fio","Index":-1,"NameInSource":"fio","Alias":"fio","Type":"System.String"},"48":{"Name":"firmid","Index":-1,"NameInSource":"firmid","Alias":"firmid","Type":"System.String"},"49":{"Name":"fullname","Index":-1,"NameInSource":"fullname","Alias":"fullname","Type":"System.String"},"50":{"Name":"generation_name","Index":-1,"NameInSource":"generation_name","Alias":"generation_name","Type":"System.String"},"51":{"Name":"generation_name_use","Index":-1,"NameInSource":"generation_name_use","Alias":"generation_name_use","Type":"System.String"},"52":{"Name":"generationid","Index":-1,"NameInSource":"generationid","Alias":"generationid","Type":"System.String"},"53":{"Name":"generationid_use","Index":-1,"NameInSource":"generationid_use","Alias":"generationid_use","Type":"System.String"},"54":{"Name":"k2firms_our","Index":-1,"NameInSource":"k2firms_our","Alias":"k2firms_our","Type":"System.String"},"55":{"Name":"kol_pack","Index":-1,"NameInSource":"kol_pack","Alias":"kol_pack","Type":"System.Decimal"},"56":{"Name":"mass_part","Index":-1,"NameInSource":"mass_part","Alias":"mass_part","Type":"System.Decimal"},"57":{"Name":"mesto","Index":-1,"NameInSource":"mesto","Alias":"mesto","Type":"System.String"},"58":{"Name":"mi_b","Index":-1,"NameInSource":"mi_b","Alias":"mi_b","Type":"System.String"},"59":{"Name":"mi_k","Index":-1,"NameInSource":"mi_k","Alias":"mi_k","Type":"System.String"},"60":{"Name":"mi_z","Index":-1,"NameInSource":"mi_z","Alias":"mi_z","Type":"System.String"},"61":{"Name":"name_typezajav","Index":-1,"NameInSource":"name_typezajav","Alias":"name_typezajav","Type":"System.String"},"62":{"Name":"name_typezajavk","Index":-1,"NameInSource":"name_typezajavk","Alias":"name_typezajavk","Type":"System.String"},"63":{"Name":"order_ins","Index":-1,"NameInSource":"order_ins","Alias":"order_ins","Type":"System.Int32"},"64":{"Name":"part_num","Index":-1,"NameInSource":"part_num","Alias":"part_num","Type":"System.String"},"65":{"Name":"pidschep","Index":-1,"NameInSource":"pidschep","Alias":"pidschep","Type":"System.String"},"66":{"Name":"podpis_zajavnik","Index":-1,"NameInSource":"podpis_zajavnik","Alias":"podpis_zajavnik","Type":"System.String"},"67":{"Name":"pole_num","Index":-1,"NameInSource":"pole_num","Alias":"pole_num","Type":"System.String"},"68":{"Name":"pov_auditor_fio","Index":-1,"NameInSource":"pov_auditor_fio","Alias":"pov_auditor_fio","Type":"System.String"},"69":{"Name":"razmer_part","Index":-1,"NameInSource":"razmer_part","Alias":"razmer_part","Type":"System.Int32"},"70":{"Name":"razmer_part2","Index":-1,"NameInSource":"razmer_part2","Alias":"razmer_part2","Type":"System.Decimal"},"71":{"Name":"razmer_polya","Index":-1,"NameInSource":"razmer_polya","Alias":"razmer_polya","Type":"System.Decimal"},"72":{"Name":"resh_auditor_fio","Index":-1,"NameInSource":"resh_auditor_fio","Alias":"resh_auditor_fio","Type":"System.String"},"73":{"Name":"resh_cert_auditid","Index":-1,"NameInSource":"resh_cert_auditid","Alias":"resh_cert_auditid","Type":"System.String"},"74":{"Name":"resh_cert_date","Index":-1,"NameInSource":"resh_cert_date","Alias":"resh_cert_date","Type":"System.DateTime"},"75":{"Name":"resh_cert_fio","Index":-1,"NameInSource":"resh_cert_fio","Alias":"resh_cert_fio","Type":"System.String"},"76":{"Name":"resh_cert_otkaz_date","Index":-1,"NameInSource":"resh_cert_otkaz_date","Alias":"resh_cert_otkaz_date","Type":"System.DateTime"},"77":{"Name":"resh_cert_otkaz_n","Index":-1,"NameInSource":"resh_cert_otkaz_n","Alias":"resh_cert_otkaz_n","Type":"System.String"},"78":{"Name":"resh_cert_otkaz_podg","Index":-1,"NameInSource":"resh_cert_otkaz_podg","Alias":"resh_cert_otkaz_podg","Type":"System.String"},"79":{"Name":"resh_mog_cert_date","Index":-1,"NameInSource":"resh_mog_cert_date","Alias":"resh_mog_cert_date","Type":"System.DateTime"},"80":{"Name":"resh_mog_cert_n","Index":-1,"NameInSource":"resh_mog_cert_n","Alias":"resh_mog_cert_n","Type":"System.Int32"},"81":{"Name":"resh_mog_cert_podg","Index":-1,"NameInSource":"resh_mog_cert_podg","Alias":"resh_mog_cert_podg","Type":"System.String"},"82":{"Name":"typezajavid","Index":-1,"NameInSource":"typezajavid","Alias":"typezajavid","Type":"System.String"},"83":{"Name":"typezajavkid","Index":-1,"NameInSource":"typezajavkid","Alias":"typezajavkid","Type":"System.String"},"84":{"Name":"usercreate","Index":-1,"NameInSource":"usercreate","Alias":"usercreate","Type":"System.String"},"85":{"Name":"userupdate","Index":-1,"NameInSource":"userupdate","Alias":"userupdate","Type":"System.String"},"86":{"Name":"vladelec_sorta","Index":-1,"NameInSource":"vladelec_sorta","Alias":"vladelec_sorta","Type":"System.String"},"87":{"Name":"vlasn_name","Index":-1,"NameInSource":"vlasn_name","Alias":"vlasn_name","Type":"System.String"},"88":{"Name":"vlasnid","Index":-1,"NameInSource":"vlasnid","Alias":"vlasnid","Type":"System.String"},"89":{"Name":"year_urog","Index":-1,"NameInSource":"year_urog","Alias":"year_urog","Type":"System.Int32"},"90":{"Name":"zajav_date","Index":-1,"NameInSource":"zajav_date","Alias":"zajav_date","Type":"System.DateTime"},"91":{"Name":"zajavkid","Index":-1,"NameInSource":"zajavkid","Alias":"zajavkid","Type":"System.String"},"92":{"Name":"zajavn","Index":-1,"NameInSource":"zajavn","Alias":"zajavn","Type":"System.String"}},"NameInSource":"k2","Type":"Table","SqlCommand":"SELECT z.zajavkid, z.comment, z.fio, z.mesto, z.address, z.address_jur, addr.address_name, z.usercreate,  z.fix_usercreate, z.userupdate, z.datecreate, z.dateupdate, z.razmer_polya, z.CodKult, z.CodKult1, z.SortID, \r\n                    z.SortID1, z.SortID2, z.SortID3, z.is_aktpol,\r\n                    z.clone_name, z.pidschep, z.catid, z.agronomid, z.firmid, z.doc_mayna_n, z.doc_mayna_date, z.k2firms_our, z.podpis_zajavnik,\r\n                    z.zajavn, z.zajav_date, z.typezajavid, z.first_typezajavkid, z.year_urog, z.mass_part, z.part_num, z.kol_pack, z.doc_yakost_num, z.doc_yakost_date,\r\n                    z.dani_pro_oplatu_robit,\r\n                    z.dani_pro_oplatu_date,\r\n                    z.order_ins, z.razmer_part, z.razmer_part2, z.act_n, z.act_date, z.vladelec_sorta,\r\n                    k.Kultura as Kultura, kmp.Kultura as Kultura1, s.NameUA as NameUA, s1.NameUA as NameUA1, s2.NameUA as NameUA2, s3.NameUA as NameUA3,\r\n                    a.fullname, a.dolgnid, dolg.dolgnname, f.VirobnikNameUA, f.AdresPocht, f.AdresYurid,\r\n                    tz.name_typezajav, tz1.name_typezajav as firstname_typezajav, z.typezajavkid, stat.name_typezajavk, z.OblastId, obl.OblastNameUA, c.cat_name, cu.cat_name cat_name_use,\r\n                    z.generationid, g.generation_name, z.generationid_use, gu.generation_name as generation_name_use, z.dstuid,dstu.dstu_name,\r\n                    z.vlasnid, vl.vlasn_name, z.resh_cert_date, z.resh_cert_fio, z.resh_cert_auditid, z.pov_cert_auditid, z.resh_cert_otkaz_date, z.resh_cert_otkaz_n,\r\n                    z.resh_cert_otkaz_podg, z.resh_mog_cert_date, z.resh_mog_cert_n, z.resh_mog_cert_podg, z.akt_pol_ocen_n, z.akt_pol_ocen_date,\r\n                    z.akt_pol_ocen_auditid, z.akt_brak_n, z.akt_brak_date, z.akt_brak_auditid, z.cert_date, z.cert_n, z.cert_podg, cert_podg_aud.fio cert_podg_aud_fio,\r\n                    resh_aud.fio resh_auditor_fio, pov_aud.fio pov_auditor_fio, pov_aud.dp_posad_name dp_posad_name, vidm_aud.fio vidm_auditor_fio, act_aud.fio act_auditor_fio, act_brak.fio act_brak_fio, agr_aud.fio agr_aud_fio,\r\n                    z.rishtypeid, rish.rishtype_name, z.prichinid1, z.prichinid2, z.prichinid3, pr1.text_prichin as text_prichin1, pr2.text_prichin as text_prichin2,\r\n                    pr3.text_prichin as text_prichin3, z.is_seen, gk.group_name, gk.group_kod, z.sort_hand, z.is_del, z.is_cert, z.pole_num, z.dil_num, z.chystota, z.cert_dateto,\r\n                    z.mog_cert_auditid, mog_cert_aud.fio mog_cert_aud_fio, z.cert_podg_auditid, z.rishtypeid_shablon, rish_sb.rishtype_name as rishtype_namesb, pz.country_poh_nas as cpn_z, pk.country_poh_nas as cpn_k, pb.country_poh_nas as cpn_b, pz.vymog_markuv as mi_z, pk.vymog_markuv as mi_k, pb.vymog_markuv as mi_b\r\n\r\n         FROM dp2_zajavka_obsteg z\r\n\r\n                LEFT JOIN dp2Kultur k\r\n                ON z.CodKult=k.CodKult\r\n                \r\n                LEFT JOIN dp2Kultur kmp\r\n                ON z.CodKult1=kmp.CodKult\r\n                \r\n                LEFT JOIN dp2GroupKult gk\r\n                ON k.group_kultid=gk.group_kultid\r\n\r\n                LEFT JOIN dp2SortReestr s\r\n                ON z.SortID=s.SortID\r\n                \r\n                LEFT JOIN dp2SortReestr s1\r\n                ON z.SortID1=s1.SortID\r\n                \r\n                LEFT JOIN dp2SortReestr s2\r\n                ON z.SortID2=s2.SortID\r\n                \r\n                LEFT JOIN dp2SortReestr s3\r\n                ON z.SortID3=s3.SortID\r\n\r\n                LEFT JOIN dp2Categors c\r\n                ON z.catid=c.catid\r\n                \r\n                LEFT JOIN dp2Categors cu\r\n                ON z.catid_use=cu.catid\r\n                \r\n                LEFT JOIN dp2generation g\r\n                ON z.generationid=g.generationid\r\n\r\n                LEFT JOIN dp2generation gu\r\n                ON z.generationid_use=gu.generationid\r\n\r\n                LEFT JOIN dp2Agronoms a\r\n                ON z.agronomid=a.agronomid\r\n                             \r\n                LEFT JOIN dp2Virobn f\r\n                ON z.firmid=f.VirobnikId\r\n\r\n                LEFT JOIN dp2_typezajav tz\r\n                ON z.typezajavid=tz.typezajavid\r\n\r\n                LEFT JOIN dp2_typezajav tz1\r\n                ON z.first_typezajavkid = tz1.typezajavid\r\n                \r\n                LEFT JOIN dp2StatusZajavk stat\r\n                ON z.typezajavkid=stat.typezajavkid\r\n                \r\n                LEFT JOIN dp2Oblast obl\r\n                ON z.OblastId=obl.OblastId\r\n                \r\n                LEFT JOIN dp2_dstu dstu\r\n                ON z.dstuid=dstu.dstuid\r\n                \r\n                LEFT JOIN dp2vlasn vl\r\n                ON z.vlasnid=vl.vlasnid\r\n                \r\n                LEFT JOIN dp2_auditors resh_aud\r\n                ON z.resh_cert_auditid=resh_aud.auditid\r\n\r\n                LEFT JOIN dp2_auditors mog_cert_aud\r\n                ON z.mog_cert_auditid=mog_cert_aud.auditid\r\n\r\n                LEFT JOIN dp2_auditors cert_podg_aud\r\n                ON z.cert_podg_auditid=cert_podg_aud.auditid\r\n                \r\n                LEFT JOIN dp2_auditors pov_aud\r\n                ON z.pov_cert_auditid=pov_aud.auditid\r\n                \r\n                LEFT JOIN dp2_auditors vidm_aud\r\n                ON z.resh_cert_otkaz_podg=vidm_aud.auditid\r\n                \r\n                LEFT JOIN dp2_auditors act_aud\r\n                ON z.akt_pol_ocen_auditid=act_aud.auditid\r\n                \r\n                LEFT JOIN dp2_auditors act_brak\r\n                ON z.akt_brak_auditid=act_brak.auditid\r\n                \r\n                LEFT JOIN dp2_auditors agr_aud\r\n                ON z.resh_cert_fio=agr_aud.auditid\r\n                \r\n                LEFT JOIN dp2RishType rish\r\n                ON z.rishtypeid=rish.rishtypeid\r\n\r\n                LEFT JOIN dp2RishType rish_sb\r\n                ON z.rishtypeid_shablon=rish_sb.rishtypeid\r\n                \r\n                LEFT JOIN dp2PrichVidmov pr1\r\n                ON z.prichinid1=pr1.prichinid\r\n                \r\n                LEFT JOIN dp2PrichVidmov pr2\r\n                ON z.prichinid2=pr2.prichinid\r\n                \r\n                LEFT JOIN dp2PrichVidmov pr3\r\n                ON z.prichinid3=pr3.prichinid\r\n                \r\n                LEFT JOIN k2dolgnost dolg\r\n                ON a.dolgnid=dolg.dolgnid\r\n\r\n                LEFT JOIN dp2address addr\r\n                ON z.address=addr.address\r\n               \r\n                LEFT JOIN dp2_protokol_zern pz\r\n                ON z.zajavkid=pz.zajavkid\r\n\r\n                LEFT JOIN dp2_protokol_kart pk\r\n                ON z.zajavkid=pk.zajavkid\r\n\r\n                LEFT JOIN dp2_protokol_bur pb\r\n                ON z.zajavkid=pb.zajavkid\r\n\r\nwhere (z.typezajavid='d6e880adc8806b00404bd29e6284fa8b'  or z.typezajavid='tov288f9c84a33a5186e6be77bb4eea0' ) AND (cert_date<'2021-01-01') AND (cert_date>='2020-01-01') order by z.zajavn desc\r\n\r\n"}},"Databases":{"0":{"Ident":"StiMySqlDatabase","Name":"k2","Alias":"k2","ConnectionStringEncrypted":"43i5CUMDUdngTzmIzxTgXote0WPdVwHB6X6hlOFxoGfGevPr5lV7iENZeb1ntG0X98h3TsIDa6xDH+XYxIjhL4Zg2QLFFsOAQxo="}}},"Pages":{"0":{"Ident":"StiPage","Name":"Page1","Guid":"45bc3a709c75c634e199c216aa58fe7c","Interaction":{"Ident":"StiInteraction"},"Border":";;2;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiReportTitleBand","Name":"ReportTitleBand1","ClientRectangle":"0,0.4,40,2.4","Interaction":{"Ident":"StiInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiText","Name":"Text7","ClientRectangle":"0.4,0.8,3.6,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Область"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"},"1":{"Ident":"StiText","Name":"Text11","Guid":"87ceee1be8356b9d451099b52cd591da","ClientRectangle":"7.2,0.8,4.2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Повне найменування суб'єкта господарювання."},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"2":{"Ident":"StiText","Name":"Text12","Guid":"2881853bc0bd1dbe91bfb463f42abf6e","ClientRectangle":"14.8,0.8,2.4,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Культура"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"3":{"Ident":"StiText","Name":"Text13","Guid":"8dd48dbe3ab7f6e9b7b1c9ad1facd88d","ClientRectangle":"19.4,0.8,1.8,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Категорія"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"4":{"Ident":"StiText","Name":"Text14","Guid":"d4faa44ec17a6b3ba48309db3165c604","ClientRectangle":"23.2,0.8,2.4,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Номер партії"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"5":{"Ident":"StiText","Name":"Text43","Guid":"b6a6b6335b069af5c9f1481fa39000d9","ClientRectangle":"27,0.8,2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Країна походження насіння"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"6":{"Ident":"StiText","Name":"Text1","Guid":"7d487e9cf51a58ca2414991d709b7826","ClientRectangle":"17.2,0.8,2.2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Сорт"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"7":{"Ident":"StiText","Name":"Text3","Guid":"e2cc8cce5cf4350117f5b4f588ee39e0","ClientRectangle":"25.6,0.8,1.4,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Маса партії, кг/ тисяч штук"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"8":{"Ident":"StiText","Name":"Text5","Guid":"9d84649e013c34287e8da5201882a887","ClientRectangle":"11.4,0.8,3.4,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Місце знаходження посіву"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"9":{"Ident":"StiText","Name":"Text8","Guid":"a0070767f211393374285adcd80ebbbd","ClientRectangle":"21.2,0.8,2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Генерація"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"10":{"Ident":"StiText","Name":"Text10","Guid":"441b9f11e3e47431a3b22fdbabb07e7f","ClientRectangle":"31.6,0.8,2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":" Реєстраційний номер сертифіката"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"11":{"Ident":"StiText","Name":"Text16","Guid":"7aeb48f92685f61e35b86bb2d3fd6906","ClientRectangle":"33.6,0.8,2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Серія та номер бланку сертифіката"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"12":{"Ident":"StiText","Name":"Text17","Guid":"50f0ddb2573071cbf9ba1f71857609a4","ClientRectangle":"35.6,0.8,2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Дата видачі сертифікату (00.00.00)"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"13":{"Ident":"StiText","Name":"Text20","Guid":"15ea9057149d4091f562544747c700ec","ClientRectangle":"37.6,0.8,2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Сертифікат дійсний до (00.00.00)"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"14":{"Ident":"StiText","Name":"Text22","Guid":"d4df473a9116ff0b0fd15f336f14f21f","ClientRectangle":"29,0.8,2.6,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Відомості про маркування"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"15":{"Ident":"StiText","Name":"Text24","Guid":"920e84af90986cb6bf27fa1f7bfa78a2","ClientRectangle":"4,0.8,3.2,1.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"Агроном"},"HorAlignment":"Center","VertAlignment":"Center","Font":"Times New Roman;10;Bold;","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","Type":"Expression"}}},"1":{"Ident":"StiDataBand","Name":"DataBand1","ClientRectangle":"0,3.6,40,0.6","Interaction":{"Ident":"StiBandInteraction"},"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Ident":"StiText","Name":"Text26","ClientRectangle":"14.8,0,2.4,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.Kultura}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:Black","TextOptions":{"WordWrap":true},"Type":"Expression"},"1":{"Ident":"StiText","Name":"Text28","ClientRectangle":"0.4,0,3.6,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.OblastNameUA}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"2":{"Ident":"StiText","Name":"Text30","ClientRectangle":"7.2,0,4.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.VirobnikNameUA}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true}},"3":{"Ident":"StiText","Name":"Text31","ClientRectangle":"25.6,0,1.4,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{IIF(dp2_zajavka_obsteg.razmer_part2,dp2_zajavka_obsteg.razmer_part2,dp2_zajavka_obsteg.mass_part)}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"4":{"Ident":"StiText","Name":"Text32","ClientRectangle":"19.4,0,1.8,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.cat_name}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"5":{"Ident":"StiText","Name":"Text44","Guid":"e45ecab71056c54f41533eced2302dde","ClientRectangle":"27,0,2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.cpn_z}{dp2_zajavka_obsteg.cpn_b}{dp2_zajavka_obsteg.cpn_k}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"6":{"Ident":"StiText","Name":"Text2","Guid":"3bc716a579096490ba53dd466ce4b5a4","ClientRectangle":"17.2,0,2.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.NameUA}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:Black","TextOptions":{"WordWrap":true},"Type":"Expression"},"7":{"Ident":"StiText","Name":"Text4","Guid":"6e49133105c1c25deaf2ac647b6d6975","ClientRectangle":"23.2,0,2.4,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.part_num}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"8":{"Ident":"StiText","Name":"Text6","Guid":"2834bdcef29db5e2e557369982b46ae3","ClientRectangle":"11.4,0,3.4,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.mesto}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"9":{"Ident":"StiText","Name":"Text9","Guid":"aac23a9075523f7f612b2fe869362439","ClientRectangle":"21.2,0,2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.generation_name}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"10":{"Ident":"StiText","Name":"Text15","Guid":"48404e8aca85cd64264f71e15844a039","ClientRectangle":"31.6,0,2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.zajavn}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"},"11":{"Ident":"StiText","Name":"Text18","Guid":"0575a8671766c5a982a85ee8a222a289","ClientRectangle":"33.6,0,2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"СП№{dp2_zajavka_obsteg.cert_n}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"12":{"Ident":"StiText","Name":"Text19","Guid":"1fedd4db334d52da052611b2b9062fdc","ClientRectangle":"35.6,0,2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{IIF( (Year(dp2_zajavka_obsteg.cert_date) <2000), \"\" ,dp2_zajavka_obsteg.cert_date.ToString(\"dd.MM.yyyy \"))}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"13":{"Ident":"StiText","Name":"Text21","Guid":"a351a029e8211b8d48f5c57b52281a96","ClientRectangle":"37.6,0,2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{IIF( (Year(dp2_zajavka_obsteg.cert_dateto) <2000), \"\" ,dp2_zajavka_obsteg.cert_dateto.ToString(\"dd.MM.yyyy \"))}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"14":{"Ident":"StiText","Name":"Text23","Guid":"ab914927ca3d4c36ae33dcdb3eb92d9d","ClientRectangle":"29,0,2.6,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.kol_pack}, {dp2_zajavka_obsteg.mi_z}{dp2_zajavka_obsteg.mi_k}{dp2_zajavka_obsteg.mi_b}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"Expression"},"15":{"Ident":"StiText","Name":"Text25","Guid":"52c00cc98be9ae50c656f97e47e2b439","ClientRectangle":"4,0,3.2,0.6","Interaction":{"Ident":"StiInteraction"},"Text":{"Value":"{dp2_zajavka_obsteg.agr_aud_fio}"},"HorAlignment":"Center","VertAlignment":"Center","Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","TextBrush":"solid:0,0,0","TextOptions":{"WordWrap":true},"Type":"DataColumn"}},"DataSourceName":"dp2_zajavka_obsteg"}},"PaperSize":"A3","Orientation":"Landscape","PageWidth":42,"PageHeight":29.699999999999999,"Watermark":{"TextBrush":"solid:50,0,0,0"},"Margins":{"Left":1,"Right":1,"Top":1,"Bottom":2}}}}