{"id":13541,"date":"2022-11-03T11:26:04","date_gmt":"2022-11-03T17:26:04","guid":{"rendered":"http:\/\/201.237.206.56\/Sitios\/ugit.siua.ac.cr\/?p=13541"},"modified":"2022-11-03T11:45:54","modified_gmt":"2022-11-03T17:45:54","slug":"sigesa-jasper-reporte-con-grupo","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=13541","title":{"rendered":"SIGESA: JASPER: Reporte con grupo"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>Vamos a crear un reporte que este agrupado <\/li><li>Para esto vamos a utilizar las siguientes tablas<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"519\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_087-1024x519.png\" alt=\"\" class=\"wp-image-13542\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_087-1024x519.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_087-300x152.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_087-768x390.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_087.png 1368w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>El select que obtiene los datos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n        T7.CODIGO AS ENCARGADO_NONITOREO_CODIGO,\n        T7.NOMBRE AS ENCARGADO_NONITOREO_NOMBRE,\n        T8.NOMBRE AS ETAPA,\n        TRIM(T1.CODIGO || '. ' || T1.DESCRIPCION) AS META_ESTRATEGICA,\n        \n        T2.NOMBRE AS AMBITO_ACCION_UNIVERSITARIA,\n        LISTAGG(T5.CODIGO ,CHR(13))WITHIN GROUP(ORDER  BY T5.ID_UNIDAD_EJECUTORA) AS RESPONSABLES_cod,\n        LISTAGG( T5.NOMBRE,CHR(13))WITHIN GROUP(ORDER  BY T5.ID_UNIDAD_EJECUTORA) AS RESPONSABLES\n        \n        \n        FROM PPI.META_PMP T1\n        INNER JOIN PPI.AMBITO_ACCION_UNIVERSITARIA T2 ON (T2.ID_AMBITO_ACCION_UNIVERSITARIA = T1.AMBITO_ACCION_UNIVERSITARIA)\n        INNER JOIN PPI.ACCION_ESTRATEGICA T3 ON (T3.META_PMP = T1.ID_META_PMP)        \n        INNER JOIN PPI.PLAN_ACCION_ESTRATEGICA T4 ON (T4.ID_PLAN_ACCION_ESTRATEGICA = T3.PLAN_ACCION_ESTRATEGICA) \n        INNER JOIN EPF.UNIDAD_EJECUTORA T5 ON (T5.ID_UNIDAD_EJECUTORA = T4.UNIDAD_EJECUTORA)\n        INNER JOIN PPI.ENCARGADO_MONITOREO T6 ON (T6.ID_ENCARGADO_MONITOREO = T1.ENCARGADO_MONITOREO)\n        INNER JOIN EPF.UNIDAD_EJECUTORA T7 ON (T7.ID_UNIDAD_EJECUTORA = T6.UNIDAD_EJECUTORA)\n        INNER JOIN PPI.ETAPA_PLAN T8 ON (T8.ID_ETAPA_PLAN = T4.ETAPA_PLAN)\n        \n        WHERE \n                (T1.ENCARGADO_MONITOREO = 2)\n            AND \n                (T4.ETAPA_PLAN = 1)\n        GROUP BY  T7.CODIGO, T7.NOMBRE, T8.NOMBRE, T1.CODIGO,T1.DESCRIPCION,T2.NOMBRE;\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos un nuevo JASPER REPORT<\/li><li>Ahora sobre el men\u00fa de \u00abOutline\u00bb le damos \u00abCreate Group\u00bb<\/li><li>Y le damos un nombre y seleccionamos el campo principal que no se repite<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"645\" height=\"609\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_090.png\" alt=\"\" class=\"wp-image-13546\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_090.png 645w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_090-300x283.png 300w\" sizes=\"(max-width: 645px) 100vw, 645px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Le indicamos que agregue footer y header<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"652\" height=\"619\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_091.png\" alt=\"\" class=\"wp-image-13549\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_091.png 652w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_091-300x285.png 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Ahora solo queda que dentro del \u00e1rea de METAS Group Header se agregan los campos por los que se van a agrupar los registros y acomodar los campos<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"949\" height=\"577\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_092.png\" alt=\"\" class=\"wp-image-13551\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_092.png 949w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_092-300x182.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_092-768x467.png 768w\" sizes=\"(max-width: 949px) 100vw, 949px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Quedando as\u00ed<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"527\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_093.png\" alt=\"\" class=\"wp-image-13552\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_093.png 830w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_093-300x190.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_093-768x488.png 768w\" sizes=\"(max-width: 830px) 100vw, 830px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Vamos a crear un reporte que este agrupado Para esto vamos a utilizar las siguientes tablas El select que obtiene los datos Creamos un nuevo JASPER REPORT Ahora sobre el men\u00fa de \u00abOutline\u00bb le damos \u00abCreate Group\u00bb Y le damos un nombre y seleccionamos el campo principal que no se repite Le indicamos que agregue [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[447,446,444],"class_list":["post-13541","post","type-post","status-publish","format-standard","hentry","category-sin-categoria","tag-grupos","tag-jasper","tag-sigesa"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/13541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13541"}],"version-history":[{"count":6,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/13541\/revisions"}],"predecessor-version":[{"id":13553,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/13541\/revisions\/13553"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}