{"id":163981,"date":"2012-12-26T18:16:03","date_gmt":"2012-12-26T14:16:03","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=163981"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=163981","title":{"rendered":"<span class=\"post_title\">Zen Reports \u0438 %XML.Writer \u0434\u043b\u044f \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u043e\u0442\u0447\u0451\u0442\u043e\u0432 Excel \u0432 Cach\u00e9<\/span>"},"content":{"rendered":"<div class=\"content html_format\">   \t\u041a\u0430\u043a \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e MS Excel \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0445 \u0432\u0435\u0440\u0441\u0438\u0439 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 xml. \u042d\u0442\u043e \u043e\u0431\u0441\u0442\u043e\u044f\u0442\u0435\u043b\u044c\u0441\u0442\u0432\u043e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u043e\u0442\u0447\u0435\u0442\u044b \u0432 Excel \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 xml-\u0444\u0430\u0439\u043b\u043e\u0432. \u0412 \u0421\u0423\u0411\u0414 Cach\u00e9 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0441\u043f\u043e\u0441\u043e\u0431\u043e\u0432 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f xml. \u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u0431\u0443\u0434\u0443\u0442 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043d\u044b \u0434\u0432\u0430, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u043d\u0430\u0438\u0431\u043e\u043b\u0435\u0435 \u0443\u0434\u043e\u0431\u043d\u044b\u0445, \u0441\u043f\u043e\u0441\u043e\u0431\u0430 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0439 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u043e\u0439 \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u043e\u0442\u0447\u0435\u0442\u043e\u0432 \u0432 MS Excel: \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e Zen Reports \u0438 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c \u043a\u043b\u0430\u0441\u0441\u0430 %XML.Writer.<br \/>  <a name=\"habracut\"><\/a><br \/>  \u0412 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u043f\u0440\u0438\u043c\u0435\u0440\u0430 \u043e\u0442\u0447\u0435\u0442\u0430 MS Excel \u0432\u0437\u044f\u0442\u0430 \u043f\u0435\u0447\u0430\u0442\u043d\u0430\u044f \u0444\u043e\u0440\u043c\u0430 \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430 \u0438\u0437 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0443\u0447\u0435\u0431\u043d\u044b\u043c \u043f\u043b\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435\u043c, \u043e \u043a\u043e\u0442\u043e\u0440\u043e\u0439 <a href=\"http:\/\/habrahabr.ru\/company\/intersystems\/blog\/149704\/\">\u0437\u0434\u0435\u0441\u044c<\/a> \u0443\u0436\u0435 \u043f\u0438\u0441\u0430\u043b\u043e\u0441\u044c, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u043f\u0435\u0440\u0435\u0439\u0434\u0451\u043c \u043d\u0435\u043f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0435\u043d\u043d\u043e \u043a \u043f\u043e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0435 \u0437\u0430\u0434\u0430\u0447\u0438 \u0438 \u0441\u043f\u043e\u0441\u043e\u0431\u0430\u043c \u0435\u0451 \u0440\u0435\u0448\u0435\u043d\u0438\u044f. \u0422\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u043e\u0442\u0447\u0451\u0442 \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 MS Excel, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0434\u043e\u043b\u0436\u0435\u043d \u0441\u043e\u0441\u0442\u043e\u044f\u0442\u044c \u0438\u0437 \u0433\u0440\u0430\u0444\u0438\u043a\u0430 \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430 (\u0442\u0438\u0442\u0443\u043b\u044c\u043d\u044b\u0439 \u043b\u0438\u0441\u0442) \u0438 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u043d\u0438\u044f \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430 (\u043f\u0435\u0440\u0435\u0447\u0435\u043d\u044c \u0432\u0441\u0435\u0445 \u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d, \u0438\u0445 \u0445\u0430\u0440\u0430\u043a\u0442\u0435\u0440\u0438\u0441\u0442\u0438\u043a \u0438 \u0432\u044b\u0447\u0438\u0441\u043b\u044f\u0435\u043c\u044b\u0445 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432). \u0424\u0440\u0430\u0433\u043c\u0435\u043d\u0442 \u043e\u0442\u0447\u0451\u0442\u0430 \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u043d\u0430 \u0440\u0438\u0441\u0443\u043d\u043a\u0435, \u0433\u043e\u0442\u043e\u0432\u044b\u0439 \u043e\u0442\u0447\u0451\u0442 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c <a href=\"https:\/\/dl.dropbox.com\/u\/81078622\/Report.xls\">\u0437\u0434\u0435\u0441\u044c<\/a>.<br \/>  <img decoding=\"async\" src=\"http:\/\/habrastorage.org\/storage2\/0c6\/c02\/b1f\/0c6c02b1ff9ada6b40ae3f5e6a8bc435.jpg\"\/><\/p>\n<h4>\u041e\u0431\u0449\u0430\u044f \u0441\u0445\u0435\u043c\u0430 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u0442\u0447\u0451\u0442\u0430<\/h4>\n<p>  \u0412 Cache \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0441\u043f\u043e\u0441\u043e\u0431\u043e\u0432 \u0440\u0443\u0447\u043d\u043e\u0433\u043e \u0438\u0437\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u043e\u0442\u0447\u0451\u0442\u043e\u0432 (\u0437\u0434\u0435\u0441\u044c \u043d\u0435 \u0431\u0443\u0434\u0443\u0442 \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0435\u043d\u044b \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u043f\u043e\u043b\u0443\u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0439 \u0441\u0431\u043e\u0440\u043a\u0438 \u043d\u0430 \u0431\u0430\u0437\u0435 DeepSee). \u0421\u0430\u043c\u044b\u0439 \u0443\u0434\u043e\u0431\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d \u0432 ZEN \u0438 \u0432\u043a\u043b\u044e\u0447\u0430\u0435\u0442 \u0432 \u0441\u0435\u0431\u044f \u043d\u0430\u0431\u043e\u0440 \u0441\u0440\u0435\u0434\u0441\u0442\u0432, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044e\u0449\u0438\u0439 \u043f\u043e\u043b\u043d\u044b\u0439 \u0446\u0438\u043a\u043b \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u0442\u0447\u0451\u0442\u043e\u0432 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 XHTML \u0438 PDF. \u041e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u044d\u0442\u043e\u0433\u043e \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0432 <a href=\"http:\/\/docs.intersystems.com\/cache20122\/csp\/docbook\/DocBook.UI.Page.cls?KEY=GRPT_reports\">\u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438<\/a>. \u0422\u0435\u043c \u043d\u0435 \u043c\u0435\u043d\u0435\u0435, \u0434\u043b\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u044f \u043d\u0430\u0448\u0435\u0439 \u0437\u0430\u0434\u0430\u0447\u0438 \u044d\u0442\u043e\u0442 \u0441\u043f\u043e\u0441\u043e\u0431 \u043c\u043e\u0436\u043d\u043e \u0437\u0430\u0434\u0435\u0439\u0441\u0442\u0432\u043e\u0432\u0430\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u0447\u0430\u0441\u0442\u0438\u0447\u043d\u043e.<br \/>  \u0420\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043e\u0431\u0449\u0438\u0439 \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u0442\u0447\u0451\u0442\u0430 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 MS Excel \u0441 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0435\u043c \u043a\u0430\u043a \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0438 ZEN, \u0442\u0430\u043a \u0438 \u0434\u0440\u0443\u0433\u0438\u0445 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0435\u0439 Cach\u00e9 (\u0441\u043c. \u0440\u0438\u0441\u0443\u043d\u043e\u043a \u043d\u0438\u0436\u0435).<br \/>  <img decoding=\"async\" src=\"http:\/\/habrastorage.org\/storage2\/1fa\/c8c\/43a\/1fac8c43aa33f3141887181faefc8b49.jpg\"\/><br \/>  \u0414\u0430\u043d\u043d\u0430\u044f \u0441\u0445\u0435\u043c\u0430 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f xls \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 \u0432\u043a\u043b\u044e\u0447\u0430\u0435\u0442 \u0442\u0440\u0438 \u044d\u0442\u0430\u043f\u0430: 1) \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 \u0431\u0430\u0437\u044b \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u0438\u0440\u0443\u044e\u0442\u0441\u044f \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0438 ZenReport \u0438\u043b\u0438 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u043e\u0439 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0438 Cach\u00e9 \u0432 xml \u0444\u0430\u0439\u043b (\u0432\u0445\u043e\u0434\u043d\u043e\u0439 xml); 2) \u043f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c\u0430 \u0442\u0440\u0430\u043d\u0441\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 XSL (eXtensible Stylesheet Language) \u043c\u043e\u0434\u0438\u0444\u0438\u0446\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0439 \u0437\u0430\u0440\u0430\u043d\u0435\u0435 \u0448\u0430\u0431\u043b\u043e\u043d \u043e\u0442\u0447\u0451\u0442\u0430 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 xml; 3) \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442 Excel (xls) \u043f\u0443\u0442\u0451\u043c \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0448\u0430\u0431\u043b\u043e\u043d\u0430 \u043e\u0442\u0447\u0451\u0442\u0430 xml, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u043d\u043e\u0433\u043e \u0432\u0441\u0442\u0430\u0432\u043a\u0430\u043c\u0438 XSL, \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0438\u0437 \u0432\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml.<\/p>\n<h4>\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u0432\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml-\u0444\u0430\u0439\u043b\u0430<\/h4>\n<p>  \u041f\u043e\u0441\u043a\u043e\u043b\u044c\u043a\u0443 xml \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043d\u0430\u0448\u0435\u0433\u043e \u043e\u0442\u0447\u0451\u0442\u0430, \u0442\u043e \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 xml-\u0444\u0430\u0439\u043b\u0430 \u0434\u043e\u043b\u0436\u043d\u0430 \u0431\u044b\u0442\u044c \u043c\u0430\u043a\u0441\u0438\u043c\u0430\u043b\u044c\u043d\u043e \u0443\u0434\u043e\u0431\u043d\u043e\u0439 \u0434\u043b\u044f \u043f\u0440\u043e\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u044f \u043e\u043f\u0438\u0441\u0430\u043d\u043d\u044b\u0445 \u0432\u044b\u0448\u0435 \u044d\u0442\u0430\u043f\u043e\u0432 \u0438, \u0432 \u043a\u043e\u043d\u0435\u0447\u043d\u043e\u043c \u0441\u0447\u0451\u0442\u0435, \u0434\u043b\u044f \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u0442\u0447\u0451\u0442\u0430. \u041d\u0438\u043a\u0430\u043a\u0438\u0445 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0445 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0439 \u043d\u0430 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 xml-\u0444\u0430\u0439\u043b\u0430 \u043d\u0435\u0442.<br \/>  \u0418\u0441\u0445\u043e\u0434\u044f \u0438\u0437 \u0441\u043f\u0435\u0446\u0438\u0444\u0438\u043a\u0438 \u043d\u0430\u0448\u0435\u0439 \u0437\u0430\u0434\u0430\u0447\u0438 \u0438 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u0432\u0445\u043e\u0434\u043d\u043e\u0439 xml-\u0444\u0430\u0439\u043b \u0434\u043e\u043b\u0436\u0435\u043d \u0438\u043c\u0435\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0443\u044e \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443. \u041a\u043e\u0440\u043d\u0435\u0432\u044b\u043c \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u043c \u0432\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f  \u2013 \u0443\u0447\u0435\u0431\u043d\u044b\u0439 \u043f\u043b\u0430\u043d.  \u0432 \u0441\u0432\u043e\u044e \u043e\u0447\u0435\u0440\u0435\u0434\u044c \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u0432 \u0441\u0435\u0431\u0435 \u0432\u0441\u044e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u043e\u0431 \u0443\u0447\u0435\u0431\u043d\u043e\u043c \u043f\u043b\u0430\u043d\u0435 \u0438 \u0432\u043a\u043b\u044e\u0447\u0430\u0435\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u044b:  <\/p>\n<ul>\n<li>\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430<\/li>\n<li>\u0421\u0443\u043c\u043c\u0430 \u0444\u043e\u0440\u043c \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u044f \u0437\u0430 \u0432\u0435\u0441\u044c \u0443\u0447\u0435\u0431\u043d\u044b\u0439 \u043f\u043b\u0430\u043d: \u044d\u043a\u0437\u0430\u043c\u0435\u043d\u043e\u0432; \u0437\u0430\u0447\u0451\u0442\u043e\u0432; \u043a\u0443\u0440\u0441\u043e\u0432\u044b\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432; \u043a\u0443\u0440\u0441\u043e\u0432\u044b\u0445 \u0440\u0430\u0431\u043e\u0442<\/li>\n<li>\u0421\u0443\u043c\u043c\u0430 \u0447\u0430\u0441\u043e\u0432 \u043f\u043e \u0432\u0441\u0435\u043c \u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d\u0430\u043c \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430: \u0432\u0441\u0435\u0433\u043e \u0441 \u044d\u043a\u0437\u0430\u043c\u0435\u043d\u043e\u043c; \u0432\u0441\u0435\u0433\u043e \u043f\u043e \u0413\u041e\u0421 (\u0433\u043e\u0441\u0443\u0434\u0430\u0440\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442); \u0430\u0443\u0434\u0438\u0442\u043e\u0440\u043d\u044b\u0445 \u0447\u0430\u0441\u043e\u0432; \u041a\u0421\u0420 (\u0441\u0430\u043c\u043e\u0441\u0442\u043e\u044f\u0442\u0435\u043b\u044c\u043d\u0430\u044f \u0440\u0430\u0431\u043e\u0442\u0430 \u043d\u0430 \u043a\u0443\u0440\u0441\u043e\u0432\u043e\u0439 \u043f\u0440\u043e\u0435\u043a\u0442 \u0438\u043b\u0438 \u0440\u0430\u0431\u043e\u0442\u0443); \u0447\u0430\u0441\u043e\u0432 \u043f\u043e \u0441\u0430\u043c\u043e\u0441\u0442\u043e\u044f\u0442\u0435\u043b\u044c\u043d\u043e\u0439 \u0440\u0430\u0431\u043e\u0442\u0435<\/li>\n<li>\u0421\u0443\u043c\u043c\u0430 \u0447\u0430\u0441\u043e\u0432 \u043f\u043e \u043a\u0430\u0436\u0434\u043e\u0439 \u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d\u0435 \u0437\u0430 \u043a\u0430\u0436\u0434\u044b\u0439 \u0441\u0435\u043c\u0435\u0441\u0442\u0440 \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430: \u0447\u0430\u0441\u044b \u043d\u0430 \u043b\u0435\u043a\u0446\u0438\u0438; \u0447\u0430\u0441\u044b \u043d\u0430 \u043b\u0430\u0431\u043e\u0440\u0430\u0442\u043e\u0440\u043d\u044b\u0435 \u0440\u0430\u0431\u043e\u0442\u044b; \u0447\u0430\u0441\u044b \u043d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u0437\u0430\u043d\u044f\u0442\u0438\u044f; \u0447\u0430\u0441\u044b \u043d\u0430 \u041a\u0421\u0420<\/li>\n<li>\u0421\u0443\u043c\u043c\u0430 \u0437\u0430\u0447\u0451\u0442\u043d\u044b\u0445 \u0435\u0434\u0438\u043d\u0438\u0446 (\u0417\u0415) \u043d\u0430 \u0432\u0435\u0441\u044c \u0443\u0447\u0435\u0431\u043d\u044b\u0439 \u043f\u043b\u0430\u043d<\/li>\n<\/ul>\n<p>  \u0422\u0430\u043a\u0436\u0435 \u0432  \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442\u0441\u044f \u0446\u0438\u043a\u043b\u044b , \u043a\u0430\u0436\u0434\u044b\u0439 \u0438\u0437 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u0441\u043e\u0441\u0442\u043e\u0438\u0442 \u0438\u0437 \u0441\u0432\u043e\u0438\u0445 \u0441\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0445 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432. \u0410\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0442\u0441\u044f \u043e\u0441\u0442\u0430\u043b\u044c\u043d\u044b\u0435 \u0432\u0435\u0442\u0432\u0438 xml-\u0444\u0430\u0439\u043b\u0430 \u0432\u043f\u043b\u043e\u0442\u044c \u0434\u043e \u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d \u0438 \u0438\u0445 \u0445\u0430\u0440\u0430\u043a\u0442\u0435\u0440\u0438\u0441\u0442\u0438\u043a. <\/p>\n<div class=\"spoiler\"><b class=\"spoiler_title\">\u041f\u0440\u0438\u043c\u0435\u0440 xml-\u0444\u0430\u0439\u043b\u0430 \u0434\u043b\u044f \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u043c\u043e\u0433\u043e \u043e\u0442\u0447\u0451\u0442\u0430.<\/b><\/p>\n<div class=\"spoiler_text\">\n<pre><code class=\"xml\">&lt;?xmlversion=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt; &lt;Curriculum&gt;   &lt;CurrName&gt;\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430&lt;\/CurrName&gt;   &lt;Cicl&gt;     &lt;CiclName&gt;\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0446\u0438\u043a\u043b\u0430 1&lt;\/CiclName&gt;     &lt;CodeOfCicl&gt;\u041a\u043e\u0434 \u0446\u0438\u043a\u043b\u0430&lt;\/CodeOfCicl&gt;       &lt;Block&gt;         &lt;BlocName&gt;\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435\u0431\u043b\u043e\u043a\u0430 1&lt;\/BlocName&gt;         &lt;Disciplines&gt;           &lt;Discipline&gt;             &lt;DiscName&gt;\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435\u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d\u044b 1&lt;\/DiscName&gt;             &lt;Exam&gt;&lt;\/Exam&gt;             &lt;Zachet&gt;&lt;\/Zachet&gt;             &lt;KR&gt;&lt;\/KR&gt;             &lt;KP&gt;&lt;\/KP&gt;             &lt;chAll&gt;&lt;\/chAll&gt;             &lt;chGos&gt;&lt;\/chGos&gt;             &lt;chKsr&gt;&lt;\/chKsr&gt;             &lt;chAud&gt;&lt;\/chAud&gt;             &lt;chSamRab&gt;&lt;\/chSamRab&gt;             &lt;naBlock&gt;&lt;\/naBlock&gt;             &lt;Zet&gt;&lt;\/Zet&gt;              &lt;semestr1&gt;               &lt;Lec&gt;&lt;\/Lec&gt;               &lt;Lab&gt;&lt;\/Lab&gt;               &lt;Pra&gt;&lt;\/Pra&gt;               &lt;KSR&gt;&lt;\/KSR&gt;             &lt;\/semestr1&gt;             . . .           &lt;\/Discipline&gt;            &lt;Discipline&gt;             &lt;DiscName&gt;\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435\u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d\u044b 2&lt;\/DiscName&gt;             &lt;Exam&gt;&lt;\/Exam&gt;             &lt;Zachet&gt;&lt;\/Zachet&gt;             &lt;KR&gt;&lt;\/KR&gt;             &lt;KP&gt;&lt;\/KP&gt;             &lt;chAll&gt;&lt;\/chAll&gt;             &lt;chGos&gt;&lt;\/chGos&gt;             &lt;chKsr&gt;&lt;\/chKsr&gt;             &lt;chAud&gt;&lt;\/chAud&gt;             &lt;chSamRab&gt;&lt;\/chSamRab&gt;             &lt;naBlock&gt;&lt;\/naBlock&gt;             &lt;Zet&gt;&lt;\/Zet&gt;              &lt;semestr1&gt;               &lt;Lec&gt;&lt;\/Lec&gt;               &lt;Lab&gt;&lt;\/Lab&gt;               &lt;Pra&gt;&lt;\/Pra&gt;               &lt;KSR&gt;&lt;\/KSR&gt;             &lt;\/semestr1&gt;             . . .           &lt;\/Discipline&gt;           . . .         &lt;\/Disciplines&gt;       &lt;\/Block&gt;       . . .     &lt;\/Cicl&gt;     . . .      &lt;\/Curriculum&gt; <\/code><\/pre>\n<p>  <\/div>\n<\/div>\n<p>  <\/p>\n<h4>\u0424\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml<\/h4>\n<p>  \u0420\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0434\u0432\u0430 \u0441\u043f\u043e\u0441\u043e\u0431\u0430 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u044f \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml \u0444\u0430\u0439\u043b\u0430: \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u043a\u043b\u0430\u0441\u0441\u0430 %XML.Writer \u0438 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c\u0430 Zen Reports.<\/p>\n<h5>\u0424\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c %XML.Writer<\/h5>\n<p>  \u041e\u043f\u0438\u0441\u0430\u043d\u043d\u0430\u044f \u0432\u044b\u0448\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 xml \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0430 \u043f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c \u043a\u043b\u0430\u0441\u0441\u0430 XML.Writer, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442:   <\/p>\n<ol>\n<li>\u0421\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u043a\u043e\u0440\u043d\u0435\u0432\u043e\u0439 \u044d\u043b\u0435\u043c\u0435\u043d\u0442<br \/>  <font color=\"#0000ff\">do&nbsp;<\/font><font color=\"#800000\">fWriter<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">RootElement<\/font><font color=\"#000000\">(<\/font><font color=\"#008000\">&quot;\u0438\u043c\u044f&nbsp;\u043a\u043e\u0440\u043d\u0435\u0432\u043e\u0433\u043e&nbsp;\u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430&quot;<\/font><font color=\"#000000\">)<br \/>  <\/font><font color=\"#0000ff\">do&nbsp;<\/font><font color=\"#800000\">fWriter<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">EndRootElement<\/font><font color=\"#000000\">()<\/font><\/li>\n<li>\u0421\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u044d\u043b\u0435\u043c\u0435\u043d\u0442<br \/>  <font color=\"#0000ff\">do&nbsp;<\/font><font color=\"#800000\">fWriter<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">Element<\/font><font color=\"#000000\">(<\/font><font color=\"#008000\">&quot;\u0438\u043c\u044f&nbsp;\u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430&quot;<\/font><font color=\"#000000\">)<br \/>  <\/font><font color=\"#0000ff\">do&nbsp;<\/font><font color=\"#800000\">fWriter<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">Write<\/font><font color=\"#000000\">(<\/font><font color=\"#008000\">\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435&nbsp;\u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430<\/font><font color=\"#000000\">)<br \/>  <\/font><font color=\"#0000ff\">do&nbsp;<\/font><font color=\"#800000\">fWriter<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">EndElement<\/font><font color=\"#000000\">()<\/font>  <\/li>\n<li>\u0421\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0430\u0442\u0440\u0438\u0431\u0443\u0442<br \/>  <font color=\"#0000ff\">do&nbsp;<\/font><font color=\"#800000\">fWriter<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">WriteAttribute<\/font><font color=\"#000000\">(<\/font><font color=\"#008000\">&quot;\u0438\u043c\u044f&nbsp;\u0430\u0442\u0440\u0438\u0431\u0443\u0442\u0430&quot;<\/font><font color=\"#000000\">, <\/font><font color=\"#008000\">&quot;\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435&nbsp;\u0430\u0442\u0440\u0438\u0431\u0443\u0442\u0430&quot;<\/font><font color=\"#000000\">)<\/font><\/li>\n<\/ol>\n<p>  \u041a\u0440\u043e\u043c\u0435 \u0442\u043e\u0433\u043e, XML.Writer \u043e\u0431\u043b\u0430\u0434\u0430\u0435\u0442 \u043c\u0435\u0442\u043e\u0434\u043e\u043c, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0438\u043c \u0438\u0437\u0432\u043b\u0435\u043a\u0430\u0442\u044c \u0432\u0441\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 \u043f\u0435\u0440\u0435\u0434\u0430\u043d\u043d\u043e\u0433\u043e \u0432 \u043d\u0435\u0433\u043e \u043e\u0431\u044a\u0435\u043a\u0442\u0430. <br \/>  <font color=\"#800000\">Writer<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">RootObject<\/font><font color=\"#000000\">(<\/font><font color=\"#008000\">&quot;\u0438\u043c\u044f&nbsp;\u043e\u0431\u044a\u0435\u043a\u0442\u0430&quot;<\/font><font color=\"#000000\">)<\/font><\/p>\n<p>  \u0412 \u0437\u0430\u0434\u0430\u0447\u0435 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u0442\u0447\u0451\u0442\u0430 \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430 \u043c\u0435\u0442\u043e\u0434 RootObject \u043d\u0435 \u043f\u043e\u0434\u043e\u0448\u0435\u043b, \u0442.\u043a. \u043a\u043b\u0430\u0441\u0441 \u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d\u044b \u0438\u043c\u0435\u0435\u0442 \u0441\u0441\u044b\u043b\u043a\u0443 \u0441\u0430\u043c \u043d\u0430 \u0441\u0435\u0431\u044f, \u0438 \u0440\u0430\u0431\u043e\u0442\u0430 \u044d\u0442\u043e\u0433\u043e \u043c\u0435\u0442\u043e\u0434\u0430 \u0431\u044b\u043b\u0430 \u043d\u0435 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u0430. \u0412 \u0441\u0432\u044f\u0437\u0438 \u0441 \u044d\u0442\u0438\u043c \u0432\u0441\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u044b \u0432\u044b\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml \u0444\u0430\u0439\u043b\u0430 \u0431\u044b\u043b\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u044b \u0432\u0440\u0443\u0447\u043d\u0443\u044e. \u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0431\u044b\u043b \u0441\u043e\u0437\u0434\u0430\u043d \u043a\u043b\u0430\u0441\u0441 sp.Report.spExcelWriter, \u0432\u043a\u043b\u044e\u0447\u0430\u044e\u0449\u0438\u0439 \u043c\u0435\u0442\u043e\u0434 genWriterData (iDSelectCur As %Integer) \u0434\u043b\u044f \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 xml-\u0444\u0430\u0439\u043b\u0430, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u0435\u0440\u0435\u0434\u0430\u0451\u0442\u0441\u044f id \u0432\u044b\u0431\u0440\u0430\u043d\u043d\u043e\u0433\u043e \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430. \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0434\u0430\u043d\u043d\u044b\u0439 \u043c\u0435\u0442\u043e\u0434, \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0438\u0437\u0432\u043b\u0435\u043a\u0430\u044e\u0442\u0441\u044f \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 \u0411\u0414, \u0438 \u0432 \u043d\u0443\u0436\u043d\u043e\u043c \u043c\u0435\u0441\u0442\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u0438\u0445 \u0432\u0441\u0442\u0430\u0432\u043a\u0430. \u041f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0432\u044b\u0445\u043e\u0434\u043d\u043e\u0439 xml \u0444\u0430\u0439\u043b \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0434\u0440\u0443\u0433\u043e\u0433\u043e \u043c\u0435\u0442\u043e\u0434\u0430 OutputToFile(\u00ab\u043f\u0443\u0442\u044c\\\u0438\u043c\u044f \u0444\u0430\u0439\u043b\u0430.xml\u00bb).<\/p>\n<h5>\u0424\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c\u0430 Zen Reports<\/h5>\n<p>  Zen Reports \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0432\u044b\u0441\u043e\u043a\u043e\u0443\u0440\u043e\u0432\u043d\u0435\u0432\u044b\u043c \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c\u043e\u043c \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u0431\u0430\u0437\u044b Cach\u00e9 \u0438 \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0438\u0445 \u0432 xml, \u0447\u0442\u043e \u043d\u0430\u043a\u043b\u0430\u0434\u044b\u0432\u0430\u0435\u0442 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u0435 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f, \u043e \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u0431\u0443\u0434\u0435\u0442 \u0441\u043a\u0430\u0437\u0430\u043d\u043e \u043d\u0438\u0436\u0435. \u0414\u0430\u043d\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u0440\u0435\u0434\u043f\u043e\u043b\u0430\u0433\u0430\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043a\u043b\u0430\u0441\u0441\u0430 Zen-\u043e\u0442\u0447\u0451\u0442\u0430 \u0447\u0435\u0440\u0435\u0437 Cach\u00e9-\u0441\u0442\u0443\u0434\u0438\u044e, \u043d\u0430\u0441\u043b\u0435\u0434\u0443\u0435\u043c\u044b\u0439 \u043e\u0442 %ZEN.Report.reportPage, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0437\u0430\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0431\u043b\u043e\u043a XData ReportDefinition. \u0411\u043e\u043b\u0435\u0435 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u043e \u043e \u043f\u0440\u0430\u0432\u0438\u043b\u0430\u0445 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0431\u043b\u043e\u043a\u0430 XData ReportDefinition \u0438 \u0432\u044b\u0431\u043e\u0440\u043a\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0434\u043b\u044f XML-\u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043c\u043e\u0436\u043d\u043e \u043f\u0440\u043e\u0447\u0438\u0442\u0430\u0442\u044c \u0432 <a href=\"http:\/\/docs.intersystems.com\/cache20122\/csp\/docbook\/DocBook.UI.Page.cls?KEY=GRPT_report_definition\">\u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438<\/a>.   <\/p>\n<div class=\"spoiler\"><b class=\"spoiler_title\">\u0417\u0434\u0435\u0441\u044c \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u043e \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u043d\u0438\u0435 \u0431\u043b\u043e\u043a\u0430 XData ReportDefinition \u0434\u043b\u044f \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u0435\u043c\u043e\u0433\u043e \u043e\u0442\u0447\u0451\u0442\u0430<\/b><\/p>\n<div class=\"spoiler_text\"><font color=\"#000080\">XData&nbsp;<\/font><font color=\"#000000\">ReportDefinition&nbsp;[&nbsp;<\/font><font color=\"#000080\">XMLNamespace&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#800080\">&quot;<a href=\"http:\/\/www.intersystems.com\/zen\/report\/definition&quot;&nbsp;\">www.intersystems.com\/zen\/report\/definition&quot;&nbsp;<\/a><\/font><font color=\"#000000\">]<br \/>  {<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">report&nbsp;<\/font><font color=\"#800000\">xmlns<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;<a href=\"http:\/\/www.intersystems.com\/zen\/report\/definition&quot;&nbsp;\">www.intersystems.com\/zen\/report\/definition&quot;&nbsp;<\/a><\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Curriculum&quot;&nbsp;<\/font><font color=\"#800000\">sql&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;sp.cCurriculum&nbsp;WHERE&nbsp;ID=?&quot;&nbsp;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">parameter&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&#8216;..idCurr&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;CurrName&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;&nbsp;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urEx&quot;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getCountFCInCur(%val,1)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urZa&quot;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getCountFCInCur(%val,2)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urKP&quot;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getCountFCInCur(%val,4)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urKR&quot;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getCountFCInCur(%val,3)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urZET&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getComTimeInCur(%val,6)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urAll&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getComTimeInCur(%val,1)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urGos&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getComTimeInCur(%val,2)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urAud&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getComTimeInCur(%val,3)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urKsr&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getComTimeInCur(%val,4)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421urSR&quot;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getComTimeInCur(%val,5)&quot;<\/font><font color=\"#000000\">\/&gt;<\/p>\n<p>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCurseme1&quot;&nbsp;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCurLec&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getTimeInCur(%val,1,1)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCurLab&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getTimeInCur(%val,1,2)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCurPra&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getTimeInCur(%val,1,3)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCurKsr&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCurriculum).getTimeInCur(%val,1,4)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;\u2026<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicls&quot;&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;sp.cCicl&nbsp;WHERE&nbsp;Curriculum&nbsp;=&nbsp;?&quot;&nbsp;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">parameter&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&#8216;..idCurr&#8217;<\/font><font color=\"#000000\">\/&gt;<\/p>\n<p>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl&quot;&nbsp;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">attribute&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;CiclName&quot;&nbsp;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">attribute&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;CodeOfCicl&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;CodeOfCicl&quot;&nbsp;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCiclEx&quot;&nbsp;&nbsp;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getCountFCInCicl(%val,1)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCiclZa&quot;&nbsp;&nbsp;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getCountFCInCicl(%val,2)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421iclKP&quot;&nbsp;&nbsp;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getCountFCInCicl(%val,4)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421iclKR&quot;&nbsp;&nbsp;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getCountFCInCicl(%val,3)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCiclchAll&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getComTimeInCicl(%val,1)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCiclchGos&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getComTimeInCicl(%val,2)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421iclchAud&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getComTimeInCicl(%val,3)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421iclchKsr&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getComTimeInCicl(%val,4)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421iclchSR&quot;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getComTimeInCicl(%val,5)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sum\u0421iclZet&quot;&nbsp;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getComTimeInCicl(%val,6)&quot;<\/font><font color=\"#000000\">\/&gt;<\/p>\n<p>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCiclseme1&quot;&nbsp;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCiclLec&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getTimeInCicl(%val,1,1)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCiclLab&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getTimeInCicl(%val,1,2)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCiclPra&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getTimeInCicl(%val,1,3)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumCiclKsr&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;##class(sp.cCicl).getTimeInCicl(%val,1,4)&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2026<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Blocks&quot;&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;sp.cBlock&nbsp;WHERE&nbsp;Cicl&nbsp;=&nbsp;?&quot;&nbsp;<\/font><font color=\"#800000\">breakOnField<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">parameter&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;<\/font><font color=\"#000000\">\/&gt;<\/p>\n<p>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Block&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">attribute&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;BlocName&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;countEx&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getCountFCInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),1)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;countZa&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getCountFCInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),2)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;countKR&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getCountFCInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),3)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;countKP&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getCountFCInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),4)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBAll&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getComTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),1)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBGos&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getComTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),2)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBAud&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getComTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),3)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBKSR&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getComTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),4)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBSR&quot;&nbsp;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getComTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),5)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBZET&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getComTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),6)&#8217;<\/font><font color=\"#000000\">\/&gt;<\/p>\n<p>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBseme1&quot;&nbsp;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBLec&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),1,1)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBLab&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),1,2)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBPra&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),1,3)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;sumBKSR&quot;&nbsp;<\/font><font color=\"#800000\">fields<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl,Name,ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cBlock).getTimeInBlock(%val(&quot;ID&quot;),%val(&quot;Name&quot;),%val(&quot;Cicl&quot;),1,4)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2026<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Disciplines&quot;&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;sp.cDiscipline&nbsp;WHERE&nbsp;( Blok=? AND Cicl=? And Parent&nbsp;is&nbsp;null)&quot;&nbsp;<\/font><font color=\"#800000\">breakOnField<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">parameter&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">parameter&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl&quot;<\/font><font color=\"#000000\">\/&gt;<\/p>\n<p>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Discipline&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;DiscName&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Exam&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getFormContr(%val,1)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Zachet&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getFormContr(%val,2)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;KR&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getFormContr(%val,3)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;KP&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getFormContr(%val,4)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;chAll&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getComTime(%val,1)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;chGos&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getComTime(%val,2)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;chKsr&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getComTime(%val,4)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;chAud&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getComTime(%val,3)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;chSamRab&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getComTime(%val,5)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Zet&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getComTime(%val,6)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;naBlock&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getNameBlock(..idCurr,%val)&#8217;<\/font><font color=\"#000000\">\/&gt;<\/p>\n<p>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;seme1&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Lec&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getTime(%val,1,1)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Lab&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getTime(%val,1,2)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Pra&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getTime(%val,1,3)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;KSR&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;##class(sp.cDiscipline).getTime(%val,1,4)&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2026<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;&nbsp;<br \/>  &lt;\/<\/font><font color=\"#000080\">report<\/font><font color=\"#000000\">&gt;<br \/>  }<\/font>  <\/div>\n<\/div>\n<p>  Zen Report \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0441\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0433\u043e \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441\u0430 \u0434\u043b\u044f \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u043c\u043e\u0433\u043e xml \u2014 \u044d\u0442\u043e \u043d\u0430\u043a\u043b\u0430\u0434\u044b\u0432\u0430\u0435\u0442 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f \u043d\u0430 \u0444\u043e\u0440\u043c\u0430\u0442 \u0432\u044b\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml. \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u043e\u0433\u043e xml \u0444\u0430\u0439\u043b\u0430 \u043d\u0435\u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043e\u0442\u043b\u0438\u0447\u0430\u0435\u0442\u0441\u044f \u043e\u0442 \u043e\u043f\u0438\u0441\u0430\u043d\u043d\u043e\u0439 \u0432\u044b\u0448\u0435: \u0432 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u043c\u044b\u0439 xml \u0444\u0430\u0439\u043b \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u0443\u0437\u043b\u044b Cicls \u0438 Blocks, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442\u0441\u044f \u043f\u043e\u0434\u0443\u0437\u043b\u044b Cicl \u0438 Block.<br \/>  \u041f\u043e\u043a\u0430\u0436\u0435\u043c \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u0438 \u0432\u044b\u0432\u043e\u0434\u0430 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445. <\/p>\n<p>  \u041f\u0440\u0438\u043c\u0435\u0440 1. \u041f\u0435\u0440\u0435\u0434\u0430\u0447\u0430 ID \u0432\u044b\u0431\u0440\u0430\u043d\u043d\u043e\u0433\u043e \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430 \u0432 sql \u0437\u0430\u043f\u0440\u043e\u0441 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 .<br \/>  &lt;<font color=\"#000080\">report&nbsp;<\/font><font color=\"#800000\">sql&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;sp.cCurriculum&nbsp;WHERE&nbsp;ID&nbsp;=&nbsp;?&quot;<\/font>&gt;<\/p>\n<p>  \u0414\u0430\u043b\u0435\u0435 \u043d\u0430 \u043c\u0435\u0441\u0442\u043e \u00ab?\u00bb \u043f\u0435\u0440\u0435\u0434\u0430\u0435\u0442\u0441\u044f \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0441\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 ..idCurr<br \/>  &lt;<font color=\"#000080\">parameter&nbsp;<\/font><font color=\"#800000\">expression&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;..idCurr&#8217;<\/font><font color=\"#000000\">\/&gt;<\/font><\/p>\n<p>  \u041f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0430\u044f \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u043e\u043c \u043a\u043b\u0430\u0441\u0441\u0430 ZenReport \u0438 \u043f\u0440\u0438 \u0432\u044b\u0437\u043e\u0432\u0435 \u043c\u0435\u0442\u043e\u0434\u0430 \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u043e\u0442\u0447\u0435\u0442\u0430, \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 idCurr \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043f\u0435\u0440\u0435\u0434\u0430\u043d\u043d\u043e\u0433\u043e \u0432 \u043c\u0435\u0442\u043e\u0434 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 id \u0442\u0435\u043a\u0443\u0449\u0435\u0433\u043e \u0443\u0447\u0435\u0431\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u043d\u0430.<\/p>\n<p>  \u041f\u0440\u0438\u043c\u0435\u0440 2. \u041f\u0435\u0440\u0435\u0434\u0430\u0447\u0430 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430 \u0437\u0430\u0432\u0438\u0441\u044f\u0449\u0435\u0433\u043e \u043e\u0442 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0430 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f SQL \u0437\u0430\u043f\u0440\u043e\u0441\u0430, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0441\u0432\u044f\u0437\u044c \u0426\u0438\u043a\u043b \u2013 \u0411\u043b\u043e\u043a:<br \/>  &lt;<font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;sp.cCicl&nbsp;WHERE&nbsp;Curriculum&nbsp;=&nbsp;?&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">parameter&nbsp;<\/font><font color=\"#800000\">expression&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&#8216;..idCurr&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">sql&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;sp.cBlock&nbsp;WHERE&nbsp;Cicl&nbsp;=&nbsp;?&quot;&nbsp;<\/font><font color=\"#800000\">breakOnField&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&quot;ID&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">parameter&nbsp;<\/font><font color=\"#800000\">field&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&quot;ID&quot;&nbsp;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<\/font><\/p>\n<p>  \u0417\u0434\u0435\u0441\u044c \u043f\u0435\u0440\u0435\u0434\u0430\u0447\u0430 \u00abID\u00bb \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u0430 breakOnField = \u00abID\u00bb.<br \/>  \u041f\u043e\u043a\u0430\u0436\u0435\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0438 \u0434\u043b\u044f \u00ab\u0426\u0438\u043a\u043b\u043e\u0432\u00bb.<br \/>  &lt;<font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicls&quot;&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;sp.cCicl&nbsp;WHERE&nbsp;Curriculum&nbsp;=&nbsp;?&quot;&nbsp;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">parameter&nbsp;<\/font><font color=\"#800000\">expression<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&#8216;..idCurr&#8217;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Cicl&quot;&nbsp;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">attribute&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;CiclName&quot;&nbsp;&nbsp;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">attribute&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;CodeOfCicl&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;CodeOfCicl&quot;&nbsp;<\/font><font color=\"#000000\">\/&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2026<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u2026<br \/>  &lt;\/<\/font><font color=\"#000080\">group<\/font><font color=\"#000000\">&gt;<\/font><\/p>\n<p>  \u0411\u043b\u043e\u043a\u0438 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u0443\u044e\u0442\u0441\u044f \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e.<br \/>  \u0418\u0437\u043c\u0435\u043d\u0451\u043d\u043d\u044b\u0439 \u0444\u043e\u0440\u043c\u0430\u0442 \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0433\u043e XML-\u0444\u0430\u0439\u043b\u0430 \u0442\u0435\u043f\u0435\u0440\u044c \u0438\u043c\u0435\u0435\u0442 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0432\u0438\u0434.  <\/p>\n<pre><code class=\"xml\">&lt;?xml version=&quot;1.0&quot;  encoding='utf-8'?&gt; \u2026 &lt;Cicls&gt;   &lt;Cicl&gt;     &lt;Blocks&gt;       &lt;Block&gt;         &lt;Disciplines&gt;\u2026&lt;\/Disciplines&gt;       &lt;\/ Block&gt;     &lt;\/ Blocks&gt;   &lt;\/Cicl&gt;   \u2026   &lt;Cicl&gt;     &lt;Blocks&gt;       &lt;Block&gt;         &lt;Disciplines&gt;\u2026&lt;\/Disciplines&gt;       &lt;\/ Block&gt;     &lt;\/ Blocks&gt;   &lt;\/Cicl&gt;   \u2026 &lt;\/Cicls&gt; <\/code><\/pre>\n<p>  \u0422\u0430\u043a\u0436\u0435 \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u0441\u044f \u0432\u044b\u0437\u043e\u0432 \u0446\u0438\u043a\u043b\u0430 \u043f\u0440\u0438 XSL \u0442\u0440\u0430\u043d\u0441\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f\u0445 (\u043e\u0431\u0449\u0438\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u044f XSL \u0442\u0440\u0430\u043d\u0441\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0439 \u043e\u043f\u0438\u0441\u0430\u043d \u043d\u0438\u0436\u0435):  <\/p>\n<pre><code class=\"xml\"> &lt;xsl:for-each select = \u201d.\/Cicls\/Cicl\u201d&gt;&lt;xsl:for-each&gt;  <\/code><\/pre>\n<p>  \u0421\u0444\u043e\u0440\u043c\u0443\u043b\u0438\u0440\u0443\u0435\u043c \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u0440\u0430\u0432\u0438\u043b\u0430, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0441\u043b\u0435\u0434\u0443\u0435\u0442 \u0443\u0447\u0438\u0442\u044b\u0432\u0430\u0442\u044c \u043f\u0440\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0438 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0432\u044b\u0445\u043e\u0434\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445.  <\/p>\n<ol>\n<li>\u041f\u043e\u043b\u0435 Name \u0431\u0443\u0434\u0435\u0442 \u0432\u0437\u044f\u0442\u043e \u0438\u0437 Table1:<br \/>  &lt;<font color=\"#000080\">report&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;Name&nbsp;FROM&nbsp;Table1&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;A&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;<\/font>\/&gt;<\/li>\n<li>\u041f\u043e\u043b\u0435 Name \u0432\u044b\u0434\u0430\u0441\u0442 \u043e\u0448\u0438\u0431\u043a\u0443:<br \/>  &lt;<font color=\"#000080\">report&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;Name&nbsp;FROM&nbsp;Table1&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &lt;<\/font><font color=\"#000080\">attribute&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;A&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;<\/font>\/&gt;<\/li>\n<li>\u041f\u043e\u043b\u0435 Name \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u0441\u044f \u0438\u0437 Table2:<br \/>  &lt;<font color=\"#000080\">report&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;Name&nbsp;FROM&nbsp;Table1&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;Name&nbsp;FROM&nbsp;Table2&nbsp;WHERE&#8230;&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &lt;<\/font><font color=\"#000080\">element&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;A&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;<\/font>\/&gt;<\/li>\n<li>\u041f\u043e\u043b\u0435 Name \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u0441\u044f \u0438\u0437 Table1:<br \/>  &lt;<font color=\"#000080\">report&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;Name&nbsp;FROM&nbsp;Table1&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &lt;<\/font><font color=\"#000080\">group&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;&nbsp;<\/font><font color=\"#800000\">sql<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;SELECT&nbsp;Name&nbsp;FROM&nbsp;Table2&nbsp;WHERE&#8230;&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &lt;<\/font><font color=\"#000080\">attribute&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;A&quot;&nbsp;<\/font><font color=\"#800000\">field<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;Name&quot;<\/font>\/&gt;<\/li>\n<\/ol>\n<h4>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0448\u0430\u0431\u043b\u043e\u043d\u0430 Excel<\/h4>\n<p>  \u041f\u0435\u0440\u0435\u0434 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435\u043c XSL-\u0442\u0440\u0430\u043d\u0441\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0448\u0430\u0431\u043b\u043e\u043d \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 Excel, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0431\u0443\u0434\u0443\u0442 \u0432\u0441\u0442\u0430\u0432\u043b\u044f\u0442\u044c\u0441\u044f \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 xml. \u041f\u043e\u0440\u044f\u0434\u043e\u043a \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0448\u0430\u0431\u043b\u043e\u043d\u0430 Excel \u0441\u043e\u0441\u0442\u043e\u0438\u0442 \u0438\u0437 \u0442\u0440\u0451\u0445 \u0448\u0430\u0433\u043e\u0432.<br \/>  <b>\u0428\u0430\u0433 \u21161.<\/b> \u0412 Excel \u0441\u043e\u0437\u0434\u0430\u0451\u0442\u0441\u044f \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u0432\u0438\u0434 \u043e\u0442\u0447\u0451\u0442\u0430.<br \/>  <b>\u0428\u0430\u0433 \u21162.<\/b> \u0428\u0430\u0431\u043b\u043e\u043d \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b xml.  <\/p>\n<div class=\"spoiler\"><b class=\"spoiler_title\">\u0424\u0440\u0430\u0433\u043c\u0435\u043d\u0442 \u043e\u0431\u0449\u0435\u0433\u043e \u0432\u0438\u0434\u0430 xml \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0435\u043c\u043e\u0433\u043e \u043e\u0442\u0447\u0451\u0442\u0430.<\/b><\/p>\n<div class=\"spoiler_text\">\n<pre><code class=\"xml\">&lt;?xml version=&quot;1.0&quot;?&gt; &lt;?mso-application progid=&quot;Excel.Sheet&quot;?&gt; &lt;Workbook xmlns=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;  xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot;  xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;  xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;  xmlns:html=&quot;http:\/\/www.w3.org\/TR\/REC-html40&quot;&gt;  &lt;DocumentProperties xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;   &lt;Author&gt;Microsoft Corporation&lt;\/Author&gt;   &lt;LastAuthor&gt;AlexandeR&lt;\/LastAuthor&gt;   &lt;LastPrinted&gt;2012-10-31T10:28:49Z&lt;\/LastPrinted&gt;   &lt;Created&gt;1996-10-08T23:32:33Z&lt;\/Created&gt;   &lt;LastSaved&gt;2012-11-24T12:30:48Z&lt;\/LastSaved&gt;   &lt;Version&gt;11.9999&lt;\/Version&gt;  &lt;\/DocumentProperties&gt;  &lt;ExcelWorkbook xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;   &lt;WindowHeight&gt;7320&lt;\/WindowHeight&gt;   &lt;WindowWidth&gt;9720&lt;\/WindowWidth&gt;   &lt;WindowTopX&gt;120&lt;\/WindowTopX&gt;   &lt;WindowTopY&gt;120&lt;\/WindowTopY&gt;   &lt;RefModeR1C1\/&gt;   &lt;AcceptLabelsInFormulas\/&gt;   &lt;ProtectStructure&gt;False&lt;\/ProtectStructure&gt;   &lt;ProtectWindows&gt;False&lt;\/ProtectWindows&gt;   &lt;DisplayInkNotes&gt;False&lt;\/DisplayInkNotes&gt;  &lt;\/ExcelWorkbook&gt;  &lt;Styles&gt;   &lt;Style ss:ID=&quot;Default&quot; ss:Name=&quot;Normal&quot;&gt;    &lt;Alignment ss:Vertical=&quot;Bottom&quot;\/&gt;    &lt;Borders\/&gt;    &lt;Font\/&gt;    &lt;Interior\/&gt;    &lt;NumberFormat\/&gt;    &lt;Protection\/&gt;   &lt;\/Style&gt;   &lt;Style ss:ID=&quot;s374&quot;&gt;    &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;\/&gt;    &lt;Font ss:FontName=&quot;Arial Cyr&quot; x:CharSet=&quot;204&quot; x:Family=&quot;Swiss&quot; ss:Bold=&quot;1&quot;     ss:Italic=&quot;1&quot;\/&gt;    &lt;Protection\/&gt;   &lt;\/Style&gt;   . . .   &lt;Worksheet ss:Name=&quot;\u0422\u0438\u0442\u0443\u043b&quot;&gt;   &lt;Table&gt;    &lt;Column ss:AutoFitWidth=&quot;0&quot; ss:Width=&quot;14.25&quot; ss:Span=&quot;66&quot;\/&gt;    &lt;Row&gt;     &lt;Cell ss:MergeAcross=&quot;66&quot; ss:StyleID=&quot;s374&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;\u041c\u0418\u041d\u0418\u0421\u0422\u0415\u0420\u0421\u0422\u0412\u041e \u041e\u0411\u0420\u0410\u0417\u041e\u0412\u0410\u041d\u0418\u042f \u0418 \u041d\u0410\u0423\u041a\u0418 \u0420\u041e\u0421\u0421\u0418\u0419\u0421\u041a\u041e\u0419 \u0424\u0415\u0414\u0415\u0420\u0410\u0426\u0418\u0418&lt;\/Data&gt;&lt;\/Cell&gt;    &lt;\/Row&gt;    . . .    &lt;WorksheetOptions xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;    &lt;PageSetup&gt;     &lt;PageMargins x:Bottom=&quot;0.984251969&quot; x:Left=&quot;0.78740157499999996&quot;      x:Right=&quot;0.78740157499999996&quot; x:Top=&quot;0.984251969&quot;\/&gt;    &lt;\/PageSetup&gt;    &lt;Print&gt;     &lt;ValidPrinterInfo\/&gt;     &lt;PaperSizeIndex&gt;9&lt;\/PaperSizeIndex&gt;     &lt;HorizontalResolution&gt;600&lt;\/HorizontalResolution&gt;     &lt;VerticalResolution&gt;600&lt;\/VerticalResolution&gt;    &lt;\/Print&gt;    &lt;Selected\/&gt;    &lt;Panes&gt;     &lt;Pane&gt;      &lt;Number&gt;3&lt;\/Number&gt;      &lt;ActiveRow&gt;25&lt;\/ActiveRow&gt;      &lt;ActiveCol&gt;74&lt;\/ActiveCol&gt;     &lt;\/Pane&gt;    &lt;\/Panes&gt;    &lt;ProtectObjects&gt;False&lt;\/ProtectObjects&gt;    &lt;ProtectScenarios&gt;False&lt;\/ProtectScenarios&gt;    &lt;AllowSort\/&gt;    &lt;AllowFilter\/&gt;   &lt;\/WorksheetOptions&gt;  &lt;\/Worksheet&gt;  &lt;Worksheet ss:Name=&quot;\u041f\u043b\u0430\u043d&quot;&gt;    . . .   &lt;\/Worksheet&gt; &lt;\/Workbook&gt; <\/code><\/pre>\n<p>  <\/div>\n<\/div>\n<p>  \u0412 \u043f\u0440\u0438\u0432\u0435\u0434\u0451\u043d\u043d\u043e\u043c \u0444\u0440\u0430\u0433\u043c\u0435\u043d\u0442\u0435 \u0432\u0438\u0434\u043d\u043e, \u0447\u0442\u043e \u0432\u043d\u0430\u0447\u0430\u043b\u0435 \u0441\u043e\u0437\u0434\u0430\u0451\u0442\u0441\u044f \u0441\u043f\u0438\u0441\u043e\u043a \u0441\u0442\u0438\u043b\u0435\u0439, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u0442\u0435\u043c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0444\u043e\u0440\u043c\u0430\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u044f\u0447\u0435\u0435\u043a. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440:  <\/p>\n<pre><code class=\"xml\">  &lt;Style ss:ID=&quot;s374&quot;&gt;    &lt;Alignment ss:Horizontal=&quot;Center&quot; ss:Vertical=&quot;Bottom&quot;\/&gt;    &lt;Font ss:FontName=&quot;Arial Cyr&quot; x:CharSet=&quot;204&quot; x:Family=&quot;Swiss&quot; ss:Bold=&quot;1&quot;     ss:Italic=&quot;1&quot;\/&gt;    &lt;Protection\/&gt;   &lt;\/Style&gt; <\/code><\/pre>\n<p>  \u041d\u0430 \u044d\u0442\u043e\u0442 \u0441\u0442\u0438\u043b\u044c \u0441\u0441\u044b\u043b\u0430\u0435\u0442\u0441\u044f \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0430\u044f \u044f\u0447\u0435\u0439\u043a\u0430:  <\/p>\n<pre><code class=\"xml\">&lt;Cell ss:MergeAcross=&quot;66&quot; ss:StyleID=&quot;s374&quot;&gt;&lt;Data ss:Type=&quot;String&quot;&gt;\u041c\u0418\u041d\u0418\u0421\u0422\u0415\u0420\u0421\u0422\u0412\u041e \u041e\u0411\u0420\u0410\u0417\u041e\u0412\u0410\u041d\u0418\u042f \u0418 \u041d\u0410\u0423\u041a\u0418 \u0420\u041e\u0421\u0421\u0418\u0419\u0421\u041a\u041e\u0419 \u0424\u0415\u0414\u0415\u0420\u0410\u0426\u0418\u0418&lt;\/Data&gt;&lt;\/Cell&gt; <\/code><\/pre>\n<p>  \u042d\u043b\u0435\u043c\u0435\u043d\u0442 \u00abWorksheet\u00bb \u0441\u043e\u0437\u0434\u0430\u0451\u0442 \u043b\u0438\u0441\u0442\u044b \u0432 \u043a\u043d\u0438\u0433\u0435 Excel, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440:  <\/p>\n<pre><code class=\"xml\">&lt;Worksheet ss:Name=&quot;\u0422\u0438\u0442\u0443\u043b&quot;&gt;    . . .  &lt;\/Worksheet&gt; <\/code><\/pre>\n<p>  \u042d\u043b\u0435\u043c\u0435\u043d\u0442 \u00abTable\u00bb \u0441\u043e\u0437\u0434\u0430\u0451\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u0443. \u0422\u0430\u0431\u043b\u0438\u0446\u0430 \u0441\u043e\u0441\u0442\u043e\u0438\u0442 \u0438\u0437 \u0441\u0442\u0440\u043e\u043a \u00abRow\u00bb, \u0430 \u0441\u0442\u0440\u043e\u043a\u0438 \u0432 \u0441\u0432\u043e\u044e \u043e\u0447\u0435\u0440\u0435\u0434\u044c \u0438\u0437 \u044f\u0447\u0435\u0435\u043a \u00abCell\u00bb.<br \/>  <b>\u0428\u0430\u0433 3.<\/b> \u041f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c \u043b\u044e\u0431\u043e\u0433\u043e \u0442\u0435\u043a\u0441\u0442\u043e\u0432\u043e\u0433\u043e \u0440\u0435\u0434\u0430\u043a\u0442\u043e\u0440\u0430 \u0432\u043d\u043e\u0441\u044f\u0442\u0441\u044f \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u0432 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 xml \u043f\u0443\u0442\u0451\u043c \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u044f \u043b\u0438\u0448\u043d\u0438\u0445 \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u043e\u0432. \u0412 \u043d\u0430\u0448\u0435\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u0443\u0434\u0430\u043b\u044f\u044e\u0442\u0441\u044f \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u044b: ss:ExpandedColumnCount = \u00ab67\u00bb; ss:ExpandedRowCount = \u00ab45\u00bb; x:FullColumns = \u00ab1\u00bb; x:FullRows = \u00ab1\u00bb, \u0442\u0430\u043a \u043a\u0430\u043a \u0443\u0447\u0435\u0431\u043d\u044b\u0439 \u043f\u043b\u0430\u043d \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u043b\u044c\u043d\u043e\u0435 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d, \u0438 \u0435\u0441\u043b\u0438 \u0443 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u00abTable\u00bb \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c \u044d\u0442\u0438 \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u044b, \u0432\u043e\u0437\u043d\u0438\u043a\u043d\u0435\u0442 \u043e\u0448\u0438\u0431\u043a\u0430 \u043f\u0440\u0438 \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 Excel \u0438\u0437-\u0437\u0430 \u043d\u0435\u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u044f \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u0430 \u0441\u0442\u0440\u043e\u043a \u0438 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432. \u0422\u0430\u043a\u0436\u0435 \u0436\u0435\u043b\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0430\u0442\u0440\u0438\u0431\u0443\u0442 ss:Height \u0443 &lt;Rowss:AutoFitHeight=\u00ab0\u00bb ss:Height=\u00ab13.5\u00bb&gt;, \u0442\u0430\u043a \u043a\u0430\u043a \u0435\u0441\u043b\u0438 \u0441\u0442\u0440\u043e\u043a\u0430 \u0431\u0443\u0434\u0435\u0442 \u0441\u0438\u043b\u044c\u043d\u043e \u0434\u043b\u0438\u043d\u043d\u0430\u044f \u0438 \u0432 \u044f\u0447\u0435\u0439\u043a\u0435 \u0431\u0443\u0434\u0435\u0442 \u0443\u043a\u0430\u0437\u0430\u043d\u043e \u00ab\u043f\u0435\u0440\u0435\u043d\u043e\u0441\u0438\u0442\u044c \u043f\u043e \u0441\u043b\u043e\u0432\u0430\u043c\u00bb, \u0442\u043e \u043f\u0435\u0440\u0435\u043d\u043e\u0441\u0430 \u043f\u043e \u0441\u043b\u043e\u0432\u0430\u043c \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432 \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u043c Excel-\u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0435.<\/p>\n<h4>XSL-\u0442\u0440\u0430\u043d\u0441\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f<\/h4>\n<p>  \u0414\u043b\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u043e\u0433\u043e \u043c\u0435\u0442\u043e\u0434\u0430 \u0442\u0440\u0430\u043d\u0441\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 (\u0432 \u043a\u043b\u0430\u0441\u0441\u0435 %XML.XSLT.Transformer) xml-\u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442 xls \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u0442\u044c \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0439 \u0431\u043b\u043e\u043a xml \u0441\u043e \u0432\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u044b\u043c\u0438 \u043a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f\u043c\u0438 XSL. \u0412 \u043d\u0430\u0448\u0435\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u043e\u0441\u043d\u043e\u0432\u044b \u0434\u043b\u044f XSL \u0432\u0437\u044f\u0442 \u0448\u0430\u0431\u043b\u043e\u043d Excel, \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0439 \u0432 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u043c \u043f\u0443\u043d\u043a\u0442\u0435. \u042d\u0442\u043e\u0442 \u0448\u0430\u0431\u043b\u043e\u043d \u043d\u0443\u0436\u043d\u043e \u0434\u043e\u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u043a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 XSL:  <\/p>\n<ol>\n<li>\n<pre><code class=\"xml\">&lt;xsl:for-each select = &quot;&quot;&gt; &lt;\/xsl:for-each&gt; <\/code><\/pre>\n<\/li>\n<li>\n<pre><code class=\"xml\">&lt;xsl:value-of select = &quot;&quot;\/&gt; <\/code><\/pre>\n<\/li>\n<\/ol>\n<p>  \u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f &lt;xsl:for-each select = &quot;&quot;&gt; &lt;\/xsl:for-each&gt; \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0432\u044b\u0431\u043e\u0440\u0430 \u043a\u0430\u0436\u0434\u043e\u0433\u043e xml \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0437\u0430\u0434\u0430\u043d\u043d\u043e\u0433\u043e \u043d\u0430\u0431\u043e\u0440\u0430. \u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f &lt;xsl:value-of select = &quot;&quot;\/&gt; \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0432\u044b\u0432\u043e\u0434\u0438\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0432\u044b\u0431\u0440\u0430\u043d\u043d\u043e\u0433\u043e \u0443\u0437\u043b\u0430. \u041d\u0438\u0436\u0435 \u043f\u0440\u0438\u0432\u0435\u0434\u0451\u043d \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u043f\u0440\u0438\u043c\u0435\u0440 \u0432\u0441\u0442\u0430\u0432\u043a\u0438 XSL \u0432 Excel \u0448\u0430\u0431\u043b\u043e\u043d:  <\/p>\n<pre><code class=\"xml\">&lt;Table&gt; &lt;xsl:for-each select=&quot;Curriculum&quot;&gt;   &lt;xsl:for-each select=&quot;.\/Cicl&quot;&gt;     &lt;Row&gt;       &lt;Cell&gt;         &lt;Data ss:Type=&quot;String&quot;&gt;&lt;xsl:value-of select=&quot;.\/CiclName&quot;\/&gt;&lt;\/Data&gt;       &lt;\/Cell&gt;     &lt;\/Row&gt;     &lt;xsl:for-each select=&quot;.\/Block&quot;&gt;       &lt;Row&gt;         &lt;Cell&gt;           &lt;Data ss:Type=&quot;String&quot;&gt;&lt;xsl:value-of select=&quot;.\/BlocName&quot;\/&gt;&lt;\/Data&gt;         &lt;\/Cell&gt;       &lt;\/Row&gt;       &lt;xsl:for-each select=&quot;.\/Disciplines\/Discipline&quot;&gt;         &lt;Row&gt;           &lt;Cell&gt;             &lt;Data ss:Type=&quot;String&quot;&gt;&lt;xsl:value-of select=&quot;.\/DiscName&quot;\/&gt;&lt;\/Data&gt;           &lt;\/Cell&gt;         &lt;\/Row&gt;       &lt;\/xsl:for-each&gt;     &lt;\/xsl:for-each&gt;   &lt;\/xsl:for-each&gt; &lt;\/xsl:for-each&gt; &lt;\/Table&gt; <\/code><\/pre>\n<p>  \u0412 \u043f\u0440\u0438\u0432\u0435\u0434\u0451\u043d\u043d\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043f\u043e\u043a\u0430\u0437\u0430\u043d\u043e, \u0447\u0442\u043e \u0432 Excel \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u0432\u043e \u0432\u043b\u043e\u0436\u0435\u043d\u043d\u043e\u043c \u0446\u0438\u043a\u043b\u0435 \u0438\u0434\u0451\u0442 \u043e\u0431\u0440\u0430\u0449\u0435\u043d\u0438\u0435 \u043a\u043e \u0432\u0441\u0435\u043c \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c , \u0437\u0430\u0442\u0435\u043c \u0432 \u043a\u0430\u0436\u0434\u043e\u043c \u0446\u0438\u043a\u043b\u0435 \u043a\u043e \u0432\u0441\u0435\u043c \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c , \u0437\u0430\u0442\u0435\u043c \u0432 \u043a\u0430\u0436\u0434\u043e\u043c \u0431\u043b\u043e\u043a\u0435 \u043a \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c \/Disciplines\/Discipline, \u0438 \u043f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e \u0432\u044b\u0432\u043e\u0434\u0438\u0442\u0441\u044f \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0430\u044f \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u043e\u043c\u0443 \u043f\u043e\u043b\u044e &lt;xsl:value-ofselect=&quot;.\/DiscName&quot;\/&gt;, \u0442.\u0435. \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044f \u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d.<br \/>  \u041f\u043e\u0441\u043b\u0435 \u0442\u043e\u0433\u043e \u043a\u0430\u043a \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u043b\u0430\u0441\u044c \u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 XSL \u0432 \u043d\u0443\u0436\u043d\u044b\u0435 \u043c\u0435\u0441\u0442\u0430 \u0448\u0430\u0431\u043b\u043e\u043d\u0430 \u043c\u043e\u0436\u043d\u043e \u043f\u0440\u0438\u0441\u0442\u0443\u043f\u0430\u0442\u044c \u043a \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0443 \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u043e\u0442\u0447\u0451\u0442\u0430. \u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u043c\u043e\u0436\u043d\u043e \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0439 \u043c\u0435\u0442\u043e\u0434 \u0432 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043a\u043b\u0430\u0441\u0441\u0435, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0442\u0440\u0430\u043d\u0441\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 xml \u0444\u043e\u0440\u043c\u0430\u0442\u0430 \u0432 xls, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0439 \u0448\u0430\u0431\u043b\u043e\u043d Excel, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043c\u043e\u0436\u043d\u043e \u0440\u0430\u0437\u043c\u0435\u0441\u0442\u0438\u0442\u044c \u0432 \u0431\u043b\u043e\u043a\u0435 XData \u044d\u0442\u043e\u0433\u043e \u0436\u0435 \u043a\u043b\u0430\u0441\u0441\u0430 (\u0432 \u043f\u0440\u0438\u0432\u0435\u0434\u0451\u043d\u043d\u043e\u043c \u043d\u0438\u0436\u0435 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0431\u043b\u043e\u043a XData \u043d\u0430\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f \u00abxsl\u00bb). \u041f\u0440\u0438\u043c\u0435\u0440 \u044d\u0442\u043e\u0433\u043e \u043c\u0435\u0442\u043e\u0434\u0430 \u043f\u0440\u0438\u0432\u0435\u0434\u0451\u043d \u043d\u0438\u0436\u0435.<\/p>\n<p>  <font color=\"#000080\">ClassMethod&nbsp;<\/font><font color=\"#000000\">generateReportStadyPlan(<\/font><font color=\"#ff00ff\">outFileName&nbsp;<\/font><font color=\"#000080\">As&nbsp;%String<\/font><font color=\"#000000\">)&nbsp;<\/font><font color=\"#000080\">As&nbsp;%Status<br \/>  <\/font><font color=\"#000000\">{<br \/>  &nbsp;&nbsp;<\/font><font color=\"#0000ff\">set&nbsp;<\/font><font color=\"#800000\">xslStream&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#000080\">##class<\/font><font color=\"#000000\">(<\/font><font color=\"#008080\">%Dictionary.CompiledXData<\/font><font color=\"#000000\">).<\/font><font color=\"#0000ff\">%OpenId<\/font><font color=\"#000000\">(..<\/font><font color=\"#0000ff\">%ClassName<\/font><font color=\"#000000\">(1)_&nbsp;<\/font><font color=\"#008000\">&quot;||xsl&quot;<\/font><font color=\"#000000\">).<\/font><font color=\"#0000ff\">Data<br \/>  &nbsp;&nbsp;set&nbsp;<\/font><font color=\"#800000\">xmlStream&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#000080\">##class<\/font><font color=\"#000000\">(<\/font><font color=\"#008080\">%FileBinaryStream<\/font><font color=\"#000000\">).<\/font><font color=\"#0000ff\">%New<\/font><font color=\"#000000\">()<br \/>  &nbsp;&nbsp;<\/font><font color=\"#0000ff\">set&nbsp;<\/font><font color=\"#800000\">xmlStream<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">Filename&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&quot;\u041f\u0443\u0442\u044c&nbsp;\u043a&nbsp;\u0444\u0430\u0439\u043b\u0443&nbsp;xml&quot;<br \/>  &nbsp;&nbsp;<br \/>  &nbsp;&nbsp;<\/font><font color=\"#0000ff\">set&nbsp;<\/font><font color=\"#800000\">outStream&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#000080\">##class<\/font><font color=\"#000000\">(<\/font><font color=\"#008080\">%FileCharacterStream<\/font><font color=\"#000000\">).<\/font><font color=\"#0000ff\">%New<\/font><font color=\"#000000\">()<br \/>  &nbsp;&nbsp;<\/font><font color=\"#0000ff\">set&nbsp;<\/font><font color=\"#800000\">outStream<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">TranslateTable&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#008000\">&quot;UTF8&quot;<br \/>  &nbsp;&nbsp;<\/font><font color=\"#0000ff\">set&nbsp;<\/font><font color=\"#800000\">outStream<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">Filename&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#800000\">outFileName<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;<br \/>  &nbsp;&nbsp;<\/font><font color=\"#0000ff\">set&nbsp;<\/font><font color=\"#800000\">sc&nbsp;<\/font><font color=\"#000000\">=&nbsp;<\/font><font color=\"#000080\">##class<\/font><font color=\"#000000\">(<\/font><font color=\"#008080\">%XML.XSLT.Transformer<\/font><font color=\"#000000\">).<\/font><font color=\"#0000ff\">TransformStream<\/font><font color=\"#000000\">(<\/font><font color=\"#800000\">xmlStream<\/font><font color=\"#000000\">,&nbsp;<\/font><font color=\"#800000\">xslStream<\/font><font color=\"#000000\">,&nbsp;.<\/font><font color=\"#800000\">outStream<\/font><font color=\"#000000\">)<br \/>  &nbsp;&nbsp;<br \/>  &nbsp;&nbsp;<\/font><font color=\"#0000ff\">if&nbsp;$$$ISERR<\/font><font color=\"#000000\">(<\/font><font color=\"#800000\">sc<\/font><font color=\"#000000\">)&nbsp;<\/font><font color=\"#0000ff\">quit&nbsp;<\/font><font color=\"#800000\">sc<br \/>  &nbsp;&nbsp;<br \/>  &nbsp;&nbsp;<\/font><font color=\"#0000ff\">quit&nbsp;<\/font><font color=\"#800000\">outStream<\/font><font color=\"#000000\">.<\/font><font color=\"#0000ff\">%Save<\/font><font color=\"#000000\">()<br \/>  }<\/font><\/p>\n<p>  <font color=\"#000080\">XData&nbsp;<\/font><font color=\"#000000\">xsl<br \/>  {<br \/>  &lt;<\/font><font color=\"#000080\">xsl:stylesheet&nbsp;<\/font><font color=\"#800000\">version<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;1.0&quot;&nbsp;<\/font><font color=\"#800000\">xmlns:xsl<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;<a href=\"http:\/\/www.w3.org\/1999\/XSL\/Transform&quot;\">www.w3.org\/1999\/XSL\/Transform&quot;<\/a><br \/>  &nbsp;&nbsp;<\/font><font color=\"#800000\">xmlns<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;<br \/>  &nbsp;&nbsp;<\/font><font color=\"#800000\">xmlns:o<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;urn:schemas-microsoft-com:office:office&quot;&nbsp;<br \/>  &nbsp;&nbsp;<\/font><font color=\"#800000\">xmlns:x<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;urn:schemas-microsoft-com:office:excel&quot;<br \/>  &nbsp;&nbsp;<\/font><font color=\"#800000\">xmlns:ss<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">xsl:template&nbsp;<\/font><font color=\"#800000\">match<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;\/&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">xsl:processing-instruction&nbsp;<\/font><font color=\"#800000\">name<\/font><font color=\"#000000\">=<\/font><font color=\"#008000\">&quot;mso-application&quot;<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;<\/font><font color=\"#000080\">xsl:text<\/font><font color=\"#000000\">&gt;progid=&quot;Excel.Sheet&quot;&lt;\/<\/font><font color=\"#000080\">xsl:text<\/font><font color=\"#000000\">&gt;<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">xsl:processing-instruction<\/font><font color=\"#000000\">&gt;<\/p>\n<p>  &lt;!-\u2014\u041c\u0435\u0441\u0442\u043e&nbsp;\u0432\u0441\u0442\u0430\u0432\u043a\u0438&nbsp;\u0448\u0430\u0431\u043b\u043e\u043d\u0430&nbsp;Excel&#8212;&gt;<br \/>  &nbsp;&nbsp;&lt;\/<\/font><font color=\"#000080\">xsl:template<\/font><font color=\"#000000\">&gt;<br \/>  &lt;\/<\/font><font color=\"#000080\">xsl:stylesheet<\/font><font color=\"#000000\">&gt;<br \/>  }<\/font><\/p>\n<h4>\u0421\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u0435 Zen Reports \u0438 %XML.Writer<\/h4>\n<p>  <\/p>\n<table>\n<tr>\n<th width=\"100\">\u041c\u0435\u0445\u0430\u043d\u0438\u0437\u043c<\/th>\n<th>\u041f\u0440\u0435\u0438\u043c\u0443\u0449\u0435\u0441\u0442\u0432\u0430<\/th>\n<th>\u041d\u0435\u0434\u043e\u0441\u0442\u0430\u0442\u043a\u0438<\/th>\n<\/tr>\n<tr>\n<td>Zen Reports<\/td>\n<td>1. \u0418\u0437\u0431\u0430\u0432\u043b\u044f\u0435\u0442 \u043e\u0442 \u043b\u0438\u0448\u043d\u0435\u0439 \u0440\u0443\u0442\u0438\u043d\u043d\u043e\u0439 \u0440\u0430\u0431\u043e\u0442\u044b<br \/>  2. \u041e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u0442\u0441\u044f \u0431\u043e\u043b\u0435\u0435 \u043b\u0430\u043a\u043e\u043d\u0438\u0447\u043d\u044b\u043c, \u043d\u0435\u0442 \u0438\u0437\u043b\u0438\u0448\u043d\u0438\u0445 \u043d\u0430\u0433\u0440\u043e\u043c\u043e\u0436\u0434\u0435\u043d\u0438\u0439<br \/>  3. \u041f\u0440\u043e\u0441\u0442\u043e\u0442\u0430 \u0432\u043e\u0441\u043f\u0440\u0438\u044f\u0442\u0438\u044f  <\/td>\n<td>\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u0432\u044b\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml \u0445\u0443\u0436\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0438\u0440\u0443\u0435\u0442\u0441\u044f, \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u0442\u0441\u044f \u0441\u043e\u0431\u043b\u044e\u0434\u0430\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u0435 \u043f\u0440\u0430\u0432\u0438\u043b\u0430<\/td>\n<\/tr>\n<tr>\n<td>%XML.Writer<\/td>\n<td>\u041c\u043e\u0436\u043d\u043e \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0430\u0431\u0441\u043e\u043b\u044e\u0442\u043d\u043e \u043b\u044e\u0431\u0443\u044e \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443 xml<\/td>\n<td>\u0411\u043e\u043b\u044c\u0448\u0430\u044f \u0442\u0440\u0443\u0434\u043e\u0451\u043c\u043a\u043e\u0441\u0442\u044c \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b<\/td>\n<\/tr>\n<\/table>\n<p>  \u0418\u0441\u0445\u043e\u0434\u044f \u0438\u0437 \u0441\u043f\u0435\u0446\u0438\u0444\u0438\u043a\u0438 \u0430\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u044b <a href=\"http:\/\/www.osp.ru\/os\/2012\/07\/13017640\/\">\u041c\u0410\u0421 \u0423\u0423\u041f<\/a>, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0441\u043e\u0437\u0434\u0430\u044e\u0442\u0441\u044f java-\u043f\u0440\u043e\u0435\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u043a\u043b\u0430\u0441\u0441\u043e\u0432 Cach\u00e9, \u043a \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u043f\u0440\u0435\u0438\u043c\u0443\u0449\u0435\u0441\u0442\u0432\u0430\u043c %XML.Writer \u043c\u043e\u0436\u043d\u043e \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u043f\u0440\u043e\u0435\u0446\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 sp.Report.spExcelWriter, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0444\u043e\u0440\u043c\u0438\u0440\u0443\u0435\u0442 \u043e\u0442\u0447\u0451\u0442. \u041d\u0430\u043f\u0440\u043e\u0442\u0438\u0432, \u0432 Zen Reports \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u043f\u0440\u043e\u0435\u043a\u0446\u0438\u044e \u043a\u043b\u0430\u0441\u0441\u0430 \u043e\u0442\u0447\u0451\u0442\u0430, \u043d\u0430\u0441\u043b\u0435\u0434\u0443\u0435\u043c\u043e\u0433\u043e \u043e\u0442 %ZEN.Report.reportPage, \u043d\u0435\u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u0432 \u0441\u0438\u043b\u0443 \u0442\u043e\u0433\u043e, \u0447\u0442\u043e \u0435\u0433\u043e \u043c\u0435\u0442\u043e\u0434\u044b \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442 \u0441 \u043f\u043e\u0442\u043e\u043a\u0430\u043c\u0438.<br \/>  \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 XML.Writer \u0446\u0435\u043b\u0435\u0441\u043e\u043e\u0431\u0440\u0430\u0437\u043d\u043e \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 \u0436\u0451\u0441\u0442\u043a\u0438\u0445 \u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u0439 \u043a \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0435 \u0432\u044b\u0445\u043e\u0434\u043d\u043e\u0433\u043e xml \u0444\u0430\u0439\u043b\u0430, \u0430 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c\u0430 Zen Reports \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0443\u0435\u0442\u0441\u044f \u043f\u0440\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0441\u043b\u043e\u0436\u043d\u044b\u0445 \u043e\u0442\u0447\u0451\u0442\u043e\u0432, \u0433\u0434\u0435 \u0432 \u043f\u0435\u0440\u0432\u0443\u044e \u043e\u0447\u0435\u0440\u0435\u0434\u044c \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u043d\u044f\u0442\u043d\u043e\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u0438 \u0441\u043d\u0438\u0436\u0435\u043d\u0438\u0435 \u0442\u0440\u0443\u0434\u043e\u0451\u043c\u043a\u043e\u0441\u0442\u0438.    \t \t\t   \t<\/p>\n<div class=\"clear\"><\/div>\n<\/p><\/div>\n<p> \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438 <a href=\"http:\/\/habrahabr.ru\/company\/intersystems\/blog\/163981\/\"> http:\/\/habrahabr.ru\/company\/intersystems\/blog\/163981\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"content html_format\">   \t\u041a\u0430\u043a \u0438\u0437\u0432\u0435\u0441\u0442\u043d\u043e MS Excel \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0445 \u0432\u0435\u0440\u0441\u0438\u0439 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 \u0432 \u0444\u043e\u0440\u043c\u0430\u0442\u0435 xml. \u042d\u0442\u043e \u043e\u0431\u0441\u0442\u043e\u044f\u0442\u0435\u043b\u044c\u0441\u0442\u0432\u043e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u043e\u0442\u0447\u0435\u0442\u044b \u0432 Excel \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 xml-\u0444\u0430\u0439\u043b\u043e\u0432. \u0412 \u0421\u0423\u0411\u0414 Cach\u00e9 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0441\u043f\u043e\u0441\u043e\u0431\u043e\u0432 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f xml. \u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u0431\u0443\u0434\u0443\u0442 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043d\u044b \u0434\u0432\u0430, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u043d\u0430\u0438\u0431\u043e\u043b\u0435\u0435 \u0443\u0434\u043e\u0431\u043d\u044b\u0445, \u0441\u043f\u043e\u0441\u043e\u0431\u0430 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0439 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u043e\u0439 \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u043e\u0442\u0447\u0435\u0442\u043e\u0432 \u0432 MS Excel: \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e Zen Reports \u0438 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c \u043a\u043b\u0430\u0441\u0441\u0430 %XML.Writer.  <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-163981","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/163981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=163981"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/163981\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=163981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=163981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=163981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}