{"id":14820,"date":"2023-05-05T15:28:29","date_gmt":"2023-05-05T21:28:29","guid":{"rendered":"http:\/\/201.237.206.56\/Sitios\/ugit.siua.ac.cr\/?p=14820"},"modified":"2023-05-12T08:10:07","modified_gmt":"2023-05-12T14:10:07","slug":"ppi-372crear-reporte-de-avance-de-acciones-estrategicas","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=14820","title":{"rendered":"PPI-372:Crear reporte de avance de acciones estrat\u00e9gicas"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Tarea:<\/h2>\n\n\n\n<p>Yo como&nbsp;usuario del sistema de Planificaci\u00f3n institucional&nbsp;requiero crear el reporte que muestre el grado de avance de las acciones estrat\u00e9gicas por facultad, centro, sede, secci\u00f3n regional, vicerrector\u00edas, rector\u00eda para valorar evoluci\u00f3n de la planificaci\u00f3n mediano plazo y toma de decisiones para su futura rendici\u00f3n de cuentas<\/p>\n\n\n\n<p><strong>Criterios de aceptaci\u00f3n:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Los par\u00e1metros a utilizar son:\n<ul class=\"wp-block-list\">\n<li>Etapa de planificaci\u00f3n\n<ul class=\"wp-block-list\">\n<li>Obligatorio<\/li>\n\n\n\n<li>Debe que tener autocomplete y LOV<\/li>\n\n\n\n<li>Solo debe mostrar las que son de tipo etapa de evaluaci\u00f3n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Unidad ejecutora\n<ul class=\"wp-block-list\">\n<li>Solamente debe mostrar las que tienen acciones estrat\u00e9gicas<\/li>\n\n\n\n<li>Tiene que tener autocomplete y LOV<\/li>\n\n\n\n<li>Filtrar por unidad que tenga acciones.<\/li>\n\n\n\n<li>Mostrar el c\u00f3digo en el autocomplete<\/li>\n\n\n\n<li>Debe tener ACL<\/li>\n\n\n\n<li>Obligatorio<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>El reporte debe indicar los siguientes campos:\n<ul class=\"wp-block-list\">\n<li>T\u00edtulo: Grado de Avance de los Acciones Estrat\u00e9gicas<\/li>\n\n\n\n<li>Encabezado de pagina\n<ul class=\"wp-block-list\">\n<li>Etapa de planificaci\u00f3n<\/li>\n\n\n\n<li>Periodo Anual<\/li>\n\n\n\n<li>Unidad ejecutora (facultad, centro, sede, secci\u00f3n regional, vicerrector\u00edas, rector\u00eda)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Detalle:\n<ul class=\"wp-block-list\">\n<li>Meta Estrat\u00e9gica<\/li>\n\n\n\n<li>Acci\u00f3n Estrat\u00e9gica\n<ul class=\"wp-block-list\">\n<li>Grado de Avance (Sumatoria de la ejecuci\u00f3n del o de los aportes por instancia por a\u00f1o, vinculados a esa acci\u00f3n estrat\u00e9gica)<\/li>\n\n\n\n<li>Gr\u00e1fico de barra de carga<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Unidad Ejecutora<\/li>\n\n\n\n<li>Aporte Estrat\u00e9gico<\/li>\n\n\n\n<li>Grado de Avance Acumulado (suma de las ejecuciones por a\u00f1o)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Pie de p\u00e1gina\n<ul class=\"wp-block-list\">\n<li>Grado de vance general (Promedio del grado de avance de las acciones por facultad&#8230;)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>El reporte debe ser como la imagen que se muestra a continuaci\u00f3n:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"921\" height=\"557\" src=\"\/wp-content\/uploads\/2023\/05\/15.png\" alt=\"\" class=\"wp-image-14839\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/15.png 921w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/15-300x181.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/15-768x464.png 768w\" sizes=\"(max-width: 921px) 100vw, 921px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">BD:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Las tablas necesarias para la tarea entonces son:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"791\" src=\"\/wp-content\/uploads\/2023\/05\/ppi-372_BD-1024x791.png\" alt=\"\" class=\"wp-image-14841\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/ppi-372_BD-1024x791.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/ppi-372_BD-300x232.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/ppi-372_BD-768x593.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/ppi-372_BD-1536x1187.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/ppi-372_BD-2048x1583.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">SELECT<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Por lo tanto el SELCT necesario es:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    PEPMP.CODIGO || '.' || OEPMP.CODIGO || '.' || MPMP.CODIGO || '.' || ' ' || MPMP.DESCRIPCION AS META_PMP,\n    XE.CODIGO || '.' || ' ' || XE.DESCRIPCION AS ACCION_ESTRATEGICA,\n    UE.CODIGO AS CODIGO_UE,\n    UE.NOMBRE AS NOMBRE_UE,\n    AE.CODIGO || '.' ||  ' ' ||  AE.DESCRIPCION AS APORTE_ESTRATEGICO,\n    ROUND( AVG(MPE.EJECUCION),2) AS AVANCE_ACUMULADO\nFROM META_POA_EVALUACION MPE\nINNER JOIN META_POA MP ON MP.ID_META_POA = MPE.META_POA\nINNER JOIN META_POA_APORTE MPA ON MPA.META_POA = MP.ID_META_POA\nINNER JOIN APORTE_ESTRATEGICO AE ON AE.ID_APORTE_ESTRATEGICO = MPA.APORTE_ESTRATEGICO\nINNER JOIN PLAN_APORTE_ESTRATEGICO PAE ON PAE.ID_PLAN_APORTE_ESTRATEGICO = AE.PLAN_APORTE_ESTRATEGICO\nINNER JOIN UNIDAD_EJECUTORA UE ON UE.ID_UNIDAD_EJECUTORA = PAE.UNIDAD_EJECUTORA\nINNER JOIN ACCION_ESTRATEGICA XE ON XE.ID_ACCION_ESTRATEGICA = AE.ACCION_ESTRATEGICA\nINNER JOIN PLAN_ACCION_ESTRATEGICA PXE ON PXE.ID_PLAN_ACCION_ESTRATEGICA = XE.PLAN_ACCION_ESTRATEGICA\nINNER JOIN META_PMP MPMP ON MPMP.ID_META_PMP = XE.META_PMP\nINNER JOIN DETALLE_PMP DPMP ON DPMP.ID_DETALLE_PMP = MPMP.DETALLE_PMP\nINNER JOIN PRIORIDAD_ESTRATEGICA_PMP PEPMP ON PEPMP.ID_PRIORIDAD_ESTRATEGICA_PMP = DPMP.PRIORIDAD_ESTRATEGICA_PMP\nINNER JOIN OBJETIVO_ESTRATEGICO_PMP OEPMP ON OEPMP.ID_OBJETIVO_ESTRATEGICO_PMP = DPMP.OBJETIVO_ESTRATEGICO_PMP\nWHERE PXE.UNIDAD_EJECUTORA = :UNIDADEJECUTORA AND MPE.ETAPA_PLAN = :ETAPAPLAN\nGROUP BY PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, MPMP.DESCRIPCION, XE.CODIGO, XE.DESCRIPCION, UE.CODIGO, UE.NOMBRE, AE.CODIGO, AE.DESCRIPCION\nORDER BY PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, XE.CODIGO, UE.CODIGO, UE.NOMBRE, AE.CODIGO;\n\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Creaci\u00f3n de reporte<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creamos reporte<\/li>\n\n\n\n<li>New Jasper Report<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"769\" height=\"635\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_107.png\" alt=\"\" class=\"wp-image-14821\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_107.png 769w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_107-300x248.png 300w\" sizes=\"(max-width: 769px) 100vw, 769px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Seleccionamos el folder y le damos el nombre R-PPI-PPE-AVANCEACCIONESTRATEGICA.jrxml<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"737\" height=\"527\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_109.png\" alt=\"\" class=\"wp-image-14825\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_109.png 737w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_109-300x215.png 300w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le damos siguiente y nos solicita el Data Source<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"803\" height=\"676\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_110.png\" alt=\"\" class=\"wp-image-14827\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_110.png 803w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_110-300x253.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_110-768x647.png 768w\" sizes=\"(max-width: 803px) 100vw, 803px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Luego para este punto podriamos agregarle la consulta SQL si la tenemos en la siguiente secci\u00f3n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"661\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_111.png\" alt=\"\" class=\"wp-image-14828\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_111.png 780w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_111-300x254.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_111-768x651.png 768w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>NOTA IMPORTANTE: si contamos ya con la consulta la podemos pegar aqu\u00ed, sin embargo es importante indicar que la consulta se pega sin el punto y coma \u201c;\u201d, por que si no nos da error de consulta<\/li>\n\n\n\n<li>Pero otra opci\u00f3n es hacer clic en el bot\u00f3n de \u201cFinish\u201d y luego agregarle al consulta cuando la tengamos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"584\" height=\"292\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_112.png\" alt=\"\" class=\"wp-image-14829\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_112.png 584w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_112-300x150.png 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora que tenemos la consulta la vamos a agregar al reporte<\/li>\n\n\n\n<li>Para esto ubicamos el icono <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"584\" height=\"383\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_125.png\" alt=\"\" class=\"wp-image-14844\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_125.png 584w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_125-300x197.png 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y pergamos la consulta<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    PEPMP.CODIGO || '.' || OEPMP.CODIGO || '.' || MPMP.CODIGO || '.' || ' ' || MPMP.DESCRIPCION AS META_PMP,\n    XE.CODIGO || '.' || ' ' || XE.DESCRIPCION AS ACCION_ESTRATEGICA,\n    UE.CODIGO AS CODIGO_UE,\n    UE.NOMBRE AS NOMBRE_UE,\n    AE.CODIGO || '.' ||  ' ' ||  AE.DESCRIPCION AS APORTE_ESTRATEGICO,\n    ROUND( AVG(MPE.EJECUCION),2) AS AVANCE_ACUMULADO\nFROM META_POA_EVALUACION MPE\nINNER JOIN META_POA MP ON MP.ID_META_POA = MPE.META_POA\nINNER JOIN META_POA_APORTE MPA ON MPA.META_POA = MP.ID_META_POA\nINNER JOIN APORTE_ESTRATEGICO AE ON AE.ID_APORTE_ESTRATEGICO = MPA.APORTE_ESTRATEGICO\nINNER JOIN PLAN_APORTE_ESTRATEGICO PAE ON PAE.ID_PLAN_APORTE_ESTRATEGICO = AE.PLAN_APORTE_ESTRATEGICO\nINNER JOIN UNIDAD_EJECUTORA UE ON UE.ID_UNIDAD_EJECUTORA = PAE.UNIDAD_EJECUTORA\nINNER JOIN ACCION_ESTRATEGICA XE ON XE.ID_ACCION_ESTRATEGICA = AE.ACCION_ESTRATEGICA\nINNER JOIN PLAN_ACCION_ESTRATEGICA PXE ON PXE.ID_PLAN_ACCION_ESTRATEGICA = XE.PLAN_ACCION_ESTRATEGICA\nINNER JOIN META_PMP MPMP ON MPMP.ID_META_PMP = XE.META_PMP\nINNER JOIN DETALLE_PMP DPMP ON DPMP.ID_DETALLE_PMP = MPMP.DETALLE_PMP\nINNER JOIN PRIORIDAD_ESTRATEGICA_PMP PEPMP ON PEPMP.ID_PRIORIDAD_ESTRATEGICA_PMP = DPMP.PRIORIDAD_ESTRATEGICA_PMP\nINNER JOIN OBJETIVO_ESTRATEGICO_PMP OEPMP ON OEPMP.ID_OBJETIVO_ESTRATEGICO_PMP = DPMP.OBJETIVO_ESTRATEGICO_PMP\nWHERE PXE.UNIDAD_EJECUTORA = $P{unidadEjecutora} AND MPE.ETAPA_PLAN = $P{etapaPlan}\nGROUP BY PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, MPMP.DESCRIPCION, XE.CODIGO, XE.DESCRIPCION, UE.CODIGO, UE.NOMBRE, AE.CODIGO, AE.DESCRIPCION\nORDER BY PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, XE.CODIGO, UE.CODIGO, UE.NOMBRE, AE.CODIGO\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Asi debe reconocer los campos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"802\" height=\"545\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_126.png\" alt=\"\" class=\"wp-image-14845\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_126.png 802w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_126-300x204.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_126-768x522.png 768w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Configuraci\u00f3n del reporte<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora vamos a configurar el reporte<\/li>\n\n\n\n<li>Seleccionamos el nombre del reporte<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_114-1024x529.png\" alt=\"\" class=\"wp-image-14831\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_114-1024x529.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_114-300x155.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_114-768x397.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_114-1536x794.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_114.png 1918w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y se nos muestra las propiedades<\/li>\n\n\n\n<li>Agregamos la descripci\u00f3n<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Reporte de Avance de Acciones Estrat\u00e9gicas<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"488\" height=\"211\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_115.png\" alt=\"\" class=\"wp-image-14832\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_115.png 488w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_115-300x130.png 300w\" sizes=\"(max-width: 488px) 100vw, 488px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Establecemos la propiedad \u00abWhen No Data type\u00bb -&gt; \u00abNo data Section\u00bb<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"564\" height=\"432\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_177.png\" alt=\"\" class=\"wp-image-14901\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_177.png 564w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_177-300x230.png 300w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bajamos hasta encontrar Page Format le damos editar<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"503\" height=\"572\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_116.png\" alt=\"\" class=\"wp-image-14834\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_116.png 503w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_116-264x300.png 264w\" sizes=\"(max-width: 503px) 100vw, 503px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nos abre una ventana donde definimos las siguientes propiedades\n<ul class=\"wp-block-list\">\n<li>Format: LETTER<\/li>\n\n\n\n<li>Margenes 20px<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"602\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_117.png\" alt=\"\" class=\"wp-image-14835\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_117.png 597w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_117-298x300.png 298w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_117-150x150.png 150w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Encabezado<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Para el encabezado ubicamos la secci\u00f3n de \u00abTitle\u00bb<\/li>\n\n\n\n<li>Y le agregamos un \u00abStatic Text\u00bb<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"365\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_118-1024x365.png\" alt=\"\" class=\"wp-image-14836\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_118-1024x365.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_118-300x107.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_118-768x274.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_118-1536x548.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_118.png 1805w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Para PPI debemos establecer las siguientes propiedades\n<ul class=\"wp-block-list\">\n<li>Altura : 15px<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"478\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_178-1024x478.png\" alt=\"\" class=\"wp-image-14903\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_178-1024x478.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_178-300x140.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_178-768x359.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_178.png 1513w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y en Static Text<\/li>\n\n\n\n<li>Centrado Vertical y horizontal<\/li>\n\n\n\n<li>Font: DejaVuSans<\/li>\n\n\n\n<li>size: 12<\/li>\n\n\n\n<li>Negrita<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"564\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_179-1024x564.png\" alt=\"\" class=\"wp-image-14904\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_179-1024x564.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_179-300x165.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_179-768x423.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_179.png 1376w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hacemos lo mismo con los demas textos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"114\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_180.png\" alt=\"\" class=\"wp-image-14905\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_180.png 570w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_180-300x60.png 300w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">titulo estandar PPI<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Como parte del estandar de PPI ahora todos los reportes tendr\u00e1n las etapa y el periodo dentro del t\u00edtulo<\/li>\n\n\n\n<li>Para esto dentro de PPO se cre\u00f3 el sub reporte R-PPI-PPO-SUB-PERIODOANUALNOMBRE-VARIABLE.jasper<\/li>\n\n\n\n<li>Que retorna:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"529\" height=\"104\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_181.png\" alt=\"\" class=\"wp-image-14907\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_181.png 529w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_181-300x59.png 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Esto lo podemos copiar del reporte <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>R-PPI-PPO-EVALUACIONOPERATIVA.jrxml<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lo copiamos son 3 <\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>R-PPI-PPO-SUB-ETAPAPLANNOMBRE-VARIABLE.jasper\nR-PPI-PPO-SUB-PERIODOANUALNOMBRE-VARIABLE.jasper\nY Text Field que los une<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"629\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_185-1024x629.png\" alt=\"\" class=\"wp-image-14911\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_185-1024x629.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_185-300x184.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_185-768x472.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_185.png 1248w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y los pegamos uno encima del otro con las variables arriba\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"878\" height=\"210\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_186.png\" alt=\"\" class=\"wp-image-14913\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_186.png 878w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_186-300x72.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_186-768x184.png 768w\" sizes=\"(max-width: 878px) 100vw, 878px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y esto para que funciones debemos hacer lo siguiente<\/li>\n\n\n\n<li>Declarar una variable \u00abetapaPlan_nombre\u00bb que va almacenar el nombre de la etapa devuelta por el subreporte<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"489\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_183-1024x489.png\" alt=\"\" class=\"wp-image-14909\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_183-1024x489.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_183-300x143.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_183-768x367.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_183-1536x734.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_183.png 1851w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y otra variable \u00abperiodoAnual_nombre\u00bb que almacena el periodo<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"280\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_184-1024x280.png\" alt=\"\" class=\"wp-image-14910\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_184-1024x280.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_184-300x82.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_184-768x210.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_184-1536x420.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_184.png 1826w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">sub etapaPlan<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>$P{SUBREPORT_DIR} + \"R-PPI-PPO-SUB-ETAPAPLANNOMBRE-VARIABLE.jasper\"<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>En el subreporte de etapa (se explica mas abajo) le indicamos que que vamos enviar la etapa que se env\u00eda como parametro <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"401\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_187-1024x401.png\" alt=\"\" class=\"wp-image-14914\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_187-1024x401.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_187-300x117.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_187-768x301.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_187-1536x601.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_187.png 1852w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Luego esta esta sencillo por que la etapa se pasa como parametro <\/li>\n\n\n\n<li>Pero ahora debemos indicarle que le vamos a pasar al subreporte el parametro etapaPlan<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"299\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_188-1024x299.png\" alt=\"\" class=\"wp-image-14915\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_188-1024x299.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_188-300x88.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_188-768x224.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_188-1536x448.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_188.png 1857w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le damos agregar uno<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"634\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_189-1024x634.png\" alt=\"\" class=\"wp-image-14916\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_189-1024x634.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_189-300x186.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_189-768x475.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_189.png 1356w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Valor de retorno<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora debemos indicar que que el valor que retorna debe se alamacenado en la variable etapaPLan<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"222\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_190-1024x222.png\" alt=\"\" class=\"wp-image-14918\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_190-1024x222.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_190-300x65.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_190-768x166.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_190-1536x333.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_190.png 1851w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le damos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"615\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_191-1024x615.png\" alt=\"\" class=\"wp-image-14919\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_191-1024x615.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_191-300x180.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_191-768x461.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_191.png 1296w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Sub Report: Periodo Anual<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora para este resporte tenemos un problema y es que el periodoAnual no es pasado como parametro<\/li>\n\n\n\n<li>por tanto tenemos que ver de donbde sqacamos el valor<\/li>\n\n\n\n<li>Una posibilidad es hacer un subreporte variable que le pasamos la etapaPlan y esta nos retorne el periodo<\/li>\n\n\n\n<li>U otra opci\u00f3n es modificar el SQL para que traiga el periodo y se lo pasemos de un Field y no un parametros<\/li>\n\n\n\n<li>Esta es la que vamos aplicar<\/li>\n\n\n\n<li>Modificamos el SQL<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    EP.PERIODO_ANUAL,\n    PEPMP.CODIGO || '.' || OEPMP.CODIGO || '.' || MPMP.CODIGO || '.' || ' ' || MPMP.DESCRIPCION AS META_PMP,\n    XE.CODIGO || '.' || ' ' || XE.DESCRIPCION AS ACCION_ESTRATEGICA,\n    UE.CODIGO AS CODIGO_UE,\n    UE.NOMBRE AS NOMBRE_UE,\n    AE.CODIGO || '.' ||  ' ' ||  AE.DESCRIPCION AS APORTE_ESTRATEGICO,\n    ROUND( AVG(MPE.EJECUCION),2) AS AVANCE_ACUMULADO\nFROM META_POA_EVALUACION MPE\nINNER JOIN META_POA MP ON MP.ID_META_POA = MPE.META_POA\nINNER JOIN META_POA_APORTE MPA ON MPA.META_POA = MP.ID_META_POA\nINNER JOIN APORTE_ESTRATEGICO AE ON AE.ID_APORTE_ESTRATEGICO = MPA.APORTE_ESTRATEGICO\nINNER JOIN PLAN_APORTE_ESTRATEGICO PAE ON PAE.ID_PLAN_APORTE_ESTRATEGICO = AE.PLAN_APORTE_ESTRATEGICO\nINNER JOIN UNIDAD_EJECUTORA UE ON UE.ID_UNIDAD_EJECUTORA = PAE.UNIDAD_EJECUTORA\nINNER JOIN ACCION_ESTRATEGICA XE ON XE.ID_ACCION_ESTRATEGICA = AE.ACCION_ESTRATEGICA\nINNER JOIN PLAN_ACCION_ESTRATEGICA PXE ON PXE.ID_PLAN_ACCION_ESTRATEGICA = XE.PLAN_ACCION_ESTRATEGICA\nINNER JOIN META_PMP MPMP ON MPMP.ID_META_PMP = XE.META_PMP\nINNER JOIN DETALLE_PMP DPMP ON DPMP.ID_DETALLE_PMP = MPMP.DETALLE_PMP\nINNER JOIN PRIORIDAD_ESTRATEGICA_PMP PEPMP ON PEPMP.ID_PRIORIDAD_ESTRATEGICA_PMP = DPMP.PRIORIDAD_ESTRATEGICA_PMP\nINNER JOIN OBJETIVO_ESTRATEGICO_PMP OEPMP ON OEPMP.ID_OBJETIVO_ESTRATEGICO_PMP = DPMP.OBJETIVO_ESTRATEGICO_PMP\nINNER JOIN ETAPA_PLAN EP ON (MPE.ETAPA_PLAN = EP.ID_ETAPA_PLAN)\nWHERE PXE.UNIDAD_EJECUTORA = :UNIDADEJECUTORA AND MPE.ETAPA_PLAN = :ETAPAPLAN \nGROUP BY EP.PERIODO_ANUAL, PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, MPMP.DESCRIPCION, XE.CODIGO, XE.DESCRIPCION, UE.CODIGO, UE.NOMBRE, AE.CODIGO, AE.DESCRIPCION\nORDER BY EP.PERIODO_ANUAL, PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, XE.CODIGO, UE.CODIGO, UE.NOMBRE, AE.CODIGO;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y el de reporte<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    EP.PERIODO_ANUAL,\n    PEPMP.CODIGO || '.' || OEPMP.CODIGO || '.' || MPMP.CODIGO || '.' || ' ' || MPMP.DESCRIPCION AS META_PMP,\n    XE.CODIGO || '.' || ' ' || XE.DESCRIPCION AS ACCION_ESTRATEGICA,\n    UE.CODIGO AS CODIGO_UE,\n    UE.NOMBRE AS NOMBRE_UE,\n    AE.CODIGO || '.' ||  ' ' ||  AE.DESCRIPCION AS APORTE_ESTRATEGICO,\n    ROUND( AVG(MPE.EJECUCION),2) AS AVANCE_ACUMULADO\nFROM META_POA_EVALUACION MPE\nINNER JOIN META_POA MP ON MP.ID_META_POA = MPE.META_POA\nINNER JOIN META_POA_APORTE MPA ON MPA.META_POA = MP.ID_META_POA\nINNER JOIN APORTE_ESTRATEGICO AE ON AE.ID_APORTE_ESTRATEGICO = MPA.APORTE_ESTRATEGICO\nINNER JOIN PLAN_APORTE_ESTRATEGICO PAE ON PAE.ID_PLAN_APORTE_ESTRATEGICO = AE.PLAN_APORTE_ESTRATEGICO\nINNER JOIN UNIDAD_EJECUTORA UE ON UE.ID_UNIDAD_EJECUTORA = PAE.UNIDAD_EJECUTORA\nINNER JOIN ACCION_ESTRATEGICA XE ON XE.ID_ACCION_ESTRATEGICA = AE.ACCION_ESTRATEGICA\nINNER JOIN PLAN_ACCION_ESTRATEGICA PXE ON PXE.ID_PLAN_ACCION_ESTRATEGICA = XE.PLAN_ACCION_ESTRATEGICA\nINNER JOIN META_PMP MPMP ON MPMP.ID_META_PMP = XE.META_PMP\nINNER JOIN DETALLE_PMP DPMP ON DPMP.ID_DETALLE_PMP = MPMP.DETALLE_PMP\nINNER JOIN PRIORIDAD_ESTRATEGICA_PMP PEPMP ON PEPMP.ID_PRIORIDAD_ESTRATEGICA_PMP = DPMP.PRIORIDAD_ESTRATEGICA_PMP\nINNER JOIN OBJETIVO_ESTRATEGICO_PMP OEPMP ON OEPMP.ID_OBJETIVO_ESTRATEGICO_PMP = DPMP.OBJETIVO_ESTRATEGICO_PMP\nINNER JOIN ETAPA_PLAN EP ON (MPE.ETAPA_PLAN = EP.ID_ETAPA_PLAN)\nWHERE PXE.UNIDAD_EJECUTORA = $P{unidadEjecutora} AND MPE.ETAPA_PLAN = $P{etapaPlan} \nGROUP BY EP.PERIODO_ANUAL, PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, MPMP.DESCRIPCION, XE.CODIGO, XE.DESCRIPCION, UE.CODIGO, UE.NOMBRE, AE.CODIGO, AE.DESCRIPCION\nORDER BY EP.PERIODO_ANUAL, PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, XE.CODIGO, UE.CODIGO, UE.NOMBRE, AE.CODIGO<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora le indicamos a sub  reoprte que utilice como parametro el filed <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"247\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_192-1024x247.png\" alt=\"\" class=\"wp-image-14921\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_192-1024x247.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_192-300x72.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_192-768x185.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_192-1536x370.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_192.png 1918w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"502\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_193-1024x502.png\" alt=\"\" class=\"wp-image-14922\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_193-1024x502.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_193-300x147.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_193-768x377.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_193-1536x753.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_193.png 1819w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y ya nos queda as\u00ed<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"170\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_194.png\" alt=\"\" class=\"wp-image-14923\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_194.png 478w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_194-300x107.png 300w\" sizes=\"(max-width: 478px) 100vw, 478px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Fecha y paginaci\u00f3n: Page Header<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Esta secci\u00f3n tambien la podemos copiar y pegar en Pag Header<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"385\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_195-1024x385.png\" alt=\"\" class=\"wp-image-14927\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_195-1024x385.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_195-300x113.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_195-768x289.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_195.png 1245w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Encabezado: Unidad Ejecutora<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Este tambien lo podemos copiar<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"853\" height=\"170\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_196.png\" alt=\"\" class=\"wp-image-14929\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_196.png 853w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_196-300x60.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_196-768x153.png 768w\" sizes=\"(max-width: 853px) 100vw, 853px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ademas copiamos la variable \u00abunidadEjecutora_codigo_nombre\u00bb<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_197-1024x231.png\" alt=\"\" class=\"wp-image-14930\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_197-1024x231.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_197-300x68.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_197-768x173.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_197-1536x346.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_197.png 1889w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Modificamos el Filed x param <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"498\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_198-1024x498.png\" alt=\"\" class=\"wp-image-14931\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_198-1024x498.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_198-300x146.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_198-768x373.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_198-1536x747.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_198.png 1886w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y los valores de retorno<\/li>\n\n\n\n<li>}<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"533\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_199-1024x533.png\" alt=\"\" class=\"wp-image-14932\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_199-1024x533.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_199-300x156.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_199-768x400.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_199.png 1470w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Page Header:no repeat<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Si lo dejamos as\u00ed este t\u00edtulo se va a repetir en todas las paginas<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"964\" height=\"342\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_200.png\" alt=\"\" class=\"wp-image-14933\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_200.png 964w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_200-300x106.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_200-768x272.png 768w\" sizes=\"(max-width: 964px) 100vw, 964px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Para evitar esto <\/li>\n\n\n\n<li>Marcamos el \u00abPage HEader\u00bb y en la propiedades en \u00abPrint When Expresion\u00bb digitamos ara que solo se imprima en la primera p\u00e1gina<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>$V{PAGE_NUMBER}.equals(1)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"316\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_201-1024x316.png\" alt=\"\" class=\"wp-image-14934\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_201-1024x316.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_201-300x93.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_201-768x237.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_201-1536x474.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_201.png 1892w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Excel: Eliminar fondo blanco cuando se exporta<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cuando exportamos a excel siempre lo hace con el fondo blanco <\/li>\n\n\n\n<li>Para eliminar esto ingresamos a:<\/li>\n\n\n\n<li>Menu-&gt;Preferences-&gt;Jasper Studio-&gt;Exporters-&gt;Excel Exporter<\/li>\n\n\n\n<li>Y desmarcamos la opci\u00f3n de \u00abWhite Page Backgroud\u00bb<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"779\" height=\"880\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_202.png\" alt=\"\" class=\"wp-image-14935\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_202.png 779w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_202-266x300.png 266w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_202-768x868.png 768w\" sizes=\"(max-width: 779px) 100vw, 779px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Creaci\u00f3n de Grupo Metas_PMP y Accion estrategica<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Como vemos en el reporte necesitamos agrupar por metas pero tambien por acciones <\/li>\n\n\n\n<li>Por tanto en la parte de \u00abOutline\u00bb hacemos clic derecho \u00abCreate Group\u00bb<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"312\" height=\"150\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_119.png\" alt=\"\" class=\"wp-image-14840\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_119.png 312w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_119-300x144.png 300w\" sizes=\"(max-width: 312px) 100vw, 312px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Aqu\u00ed  nos solicita que le pongamos un nombre y seleccionamos por cual campo deseamos agrupar, para este caso META_PMP y ACCION_ESTRATEGICA<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"278\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_143.png\" alt=\"\" class=\"wp-image-14857\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_143.png 480w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_143-300x174.png 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le indicamos las secciones que deseamos agregar y finalizamos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"635\" height=\"610\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_136.png\" alt=\"\" class=\"wp-image-14850\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_136.png 635w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_136-300x288.png 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora esto nos crea una secci\u00f3n de header que se va a comportar como un encabezado que se va a generar cada vez que cambien en el listado de datos, por esta raz\u00f3n es que viene agrupado por estos campos la consulta<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y ademas en el detalle es donde colocamos los datos que le pertenecen en este caso a una meta y que llevan su propio ciclo de impresi\u00f3n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"466\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_144-1024x466.png\" alt=\"\" class=\"wp-image-14858\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_144-1024x466.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_144-300x137.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_144-768x350.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_144.png 1069w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creaci\u00f3n de Grado de Avance<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ya hemos acomodado los campos con los quie contamos teniendo un resultado as\u00ed:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"551\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_139.png\" alt=\"\" class=\"wp-image-14853\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_139.png 816w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_139-300x203.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_139-768x519.png 768w\" sizes=\"(max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Donde tenemos:\n<ul class=\"wp-block-list\">\n<li>Una meta\n<ul class=\"wp-block-list\">\n<li>una accion\n<ul class=\"wp-block-list\">\n<li>Y los aportes con un avance<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Por tanto ahora vamos a la secci\u00f3n de variables y arrastramos a \u00abAvance_acumulado\u00bb y lo arrastramos a en el \u00abGroup Footer\u00bb <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"568\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_147-1024x568.png\" alt=\"\" class=\"wp-image-14862\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_147-1024x568.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_147-300x166.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_147-768x426.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_147.png 1404w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nos sale un ventana donde vamos a seleccionar:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"643\" height=\"478\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_148.png\" alt=\"\" class=\"wp-image-14863\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_148.png 643w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_148-300x223.png 300w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Esta nos crea una variable que utilizara el el avance_acumulado para sacar un promedio<\/li>\n\n\n\n<li>Este promedio puede dar con muchos decimales, para evitar esto lo vamos a redondear con<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>$V{AVANCE_ACUMULADO1}.setScale(2, RoundingMode.HALF_UP)+\"%\"<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"433\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_149-1024x433.png\" alt=\"\" class=\"wp-image-14864\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_149-1024x433.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_149-300x127.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_149-768x324.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_149.png 1290w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Aqu\u00ed es importante en el campo que se crear en \u00abEvaluation_time\u00bb pornerle band para que se evalue cuando se esta en la banda<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"408\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_150-1024x408.png\" alt=\"\" class=\"wp-image-14865\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_150-1024x408.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_150-300x120.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_150-768x306.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_150-1536x612.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_150.png 1925w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Con esto ya tenemos el \u00abGrado de Avance\u00bb<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"251\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_151.png\" alt=\"\" class=\"wp-image-14866\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_151.png 558w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_151-300x135.png 300w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Grado de vanace general<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora vamos hacer lo mismo para generar el acumulado general<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"670\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_152-1024x670.png\" alt=\"\" class=\"wp-image-14868\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_152-1024x670.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_152-300x196.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_152-768x503.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_152.png 1045w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Para esto lo vamos hacer en la secci\u00f3n de SUMMARY<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"450\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_153-1024x450.png\" alt=\"\" class=\"wp-image-14869\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_153-1024x450.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_153-300x132.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_153-768x337.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_153.png 1311w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Arrastramos y creamos promedio<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"568\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_147-1-1024x568.png\" alt=\"\" class=\"wp-image-14870\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_147-1-1024x568.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_147-1-300x166.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_147-1-768x426.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_147-1.png 1404w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"643\" height=\"478\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_148-1.png\" alt=\"\" class=\"wp-image-14871\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_148-1.png 643w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_148-1-300x223.png 300w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Aqupi es importante que la \u00abEvaluation Time\u00bb se a \u00abReport\u00bb ya que este debe sumar todos los aportes <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"891\" height=\"574\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_154.png\" alt=\"\" class=\"wp-image-14872\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_154.png 891w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_154-300x193.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_154-768x495.png 768w\" sizes=\"(max-width: 891px) 100vw, 891px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y por supuesto redondear<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>$V{AVANCE_ACUMULADO2}.setScale(2, RoundingMode.HALF_UP)+\"%\"<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora le agregamos bordes<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"291\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_155-1024x291.png\" alt=\"\" class=\"wp-image-14874\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_155-1024x291.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_155-300x85.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_155-768x219.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_155.png 1500w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Listo nos queda as\u00ed<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_156-1024x363.png\" alt=\"\" class=\"wp-image-14875\" width=\"750\" height=\"265\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_156-1024x363.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_156-300x106.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_156-768x272.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_156.png 1039w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Sub reporte variable<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora para obtrener los datos de lo parametros debemos hacer un subreporte variable <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">EtapaPlan<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lo primero que vamos hacer es agregar un componente de Subreporte<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"256\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_157-1024x256.png\" alt=\"\" class=\"wp-image-14877\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_157-1024x256.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_157-300x75.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_157-768x192.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_157.png 1214w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y en su configuraci\u00f3n vamos a indicarle<\/li>\n\n\n\n<li>expression: establece cual es el reporte que vamos a invocar<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>$P{SUBREPORT_DIR} + \"R-PPI-PPO-SUB-ETAPAPLANNOMBRE-VARIABLE.jasper\"<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Connection Expression <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>$P{REPORT_CONNECTION}<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"442\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_174-1024x442.png\" alt=\"\" class=\"wp-image-14897\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_174-1024x442.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_174-300x129.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_174-768x332.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_174-1536x663.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_174.png 1895w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Como vemos requerimos un \u00abParametro\u00bb  de nombre<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SUBREPORT_DIR<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Por tanto debemos crearla<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"406\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_159-1024x406.png\" alt=\"\" class=\"wp-image-14879\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_159-1024x406.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_159-300x119.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_159-768x304.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_159-1536x609.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_159.png 1797w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora para recibir el nombre de la etapa que que nos retornara el subreporte vamos a crear una variable que almacene el nombre de la etapa<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"316\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_164-1024x316.png\" alt=\"\" class=\"wp-image-14885\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_164-1024x316.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_164-300x93.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_164-768x237.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_164-1536x474.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_164.png 1804w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora arrastramos esta variable y la colocamos encima del subreporte<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1006\" height=\"715\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_165.png\" alt=\"\" class=\"wp-image-14888\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_165.png 1006w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_165-300x213.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_165-768x546.png 768w\" sizes=\"(max-width: 1006px) 100vw, 1006px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y la vamos a configurar con la propiedad<\/li>\n\n\n\n<li>Evaluation Time: Band<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"454\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_175-1024x454.png\" alt=\"\" class=\"wp-image-14898\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_175-1024x454.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_175-300x133.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_175-768x340.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_175-1536x681.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_175.png 1897w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Parametros hacia reporte<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y ahora le vamos a indicar que parametros le vamos a pasar <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"380\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_166-1024x380.png\" alt=\"\" class=\"wp-image-14889\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_166-1024x380.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_166-300x111.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_166-768x285.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_166-1536x570.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_166.png 1877w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nos abre una ventana donde le decimos que vamos a agregar un parametro<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"620\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_167.png\" alt=\"\" class=\"wp-image-14890\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_167.png 627w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_167-300x297.png 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le damos un nombre<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"475\" height=\"346\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_168.png\" alt=\"\" class=\"wp-image-14891\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_168.png 475w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_168-300x219.png 300w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y en expresion la damos al boton <\/li>\n\n\n\n<li>nos abre un ventana donde podemos seleccionar el parametro que nos pasan<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"603\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_169-1024x603.png\" alt=\"\" class=\"wp-image-14892\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_169-1024x603.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_169-300x177.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_169-768x453.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_169.png 1220w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Quedando As\u00ed:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"620\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_170.png\" alt=\"\" class=\"wp-image-14893\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_170.png 627w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_170-300x297.png 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Con esto configuramos el envi\u00f3 de parametros hacia el subreporte<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">parametros de retorno de subreporte<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ahora vamos a configurar lo0 que nos va a devolver el subreporte<\/li>\n\n\n\n<li>Lo primero es ubicarse en el sub reporte y darle \u00abEdit Return Values\u00bb<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"269\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_171-1024x269.png\" alt=\"\" class=\"wp-image-14894\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_171-1024x269.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_171-300x79.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_171-768x202.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_171-1536x403.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_171.png 1843w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nos abre una ventana donde podemos configurar los valores de retorno<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"744\" height=\"514\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_172.png\" alt=\"\" class=\"wp-image-14895\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_172.png 744w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_172-300x207.png 300w\" sizes=\"(max-width: 744px) 100vw, 744px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y lo que vamos hacer es indicarle que que lo quye devuelva la variable \u00abetapaPlan_nombre\u00bb del sub reporte lo guarde en la variable \u00abetapaPlan_nombre\u00bb del reporte<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"747\" height=\"534\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_176.png\" alt=\"\" class=\"wp-image-14899\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_176.png 747w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_176-300x214.png 300w\" sizes=\"(max-width: 747px) 100vw, 747px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Subreporte<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Este subreporte debe estar configurado as\u00ed<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"481\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_160-1024x481.png\" alt=\"\" class=\"wp-image-14880\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_160-1024x481.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_160-300x141.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_160-768x361.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_160-1536x721.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_160.png 1851w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y lo que debe tener es un parametro de tipo long que ser\u00e1 el id del elemento a consulta<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"290\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_161-1024x290.png\" alt=\"\" class=\"wp-image-14881\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_161-1024x290.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_161-300x85.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_161-768x218.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_161-1536x435.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_161.png 1768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y a nivel de SQL lo que va tener es la consulta del elemento por ID<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT NOMBRE FROM ETAPA_PLAN WHERE ID_ETAPA_PLAN = $P{etapaPlan}<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"461\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_162-1024x461.png\" alt=\"\" class=\"wp-image-14882\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_162-1024x461.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_162-300x135.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_162-768x346.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_162-1536x691.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_162.png 1542w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Es decir que vamos a recibir un parametro llamado \u00abetapaPlan\u00bb y el nos retornar\u00e1 un valor a trav\u00e9s de una variable que la declramos de la siguiente forma<\/li>\n\n\n\n<li>Name: etapaPlan_nombre<\/li>\n\n\n\n<li>Class: java.lang.String<\/li>\n\n\n\n<li>Calculation: No Calculation Function<\/li>\n\n\n\n<li>Expresion: $F{NOMBRE}<\/li>\n\n\n\n<li>Initial Vaslue Expresion: \u00ab\u00bb<\/li>\n\n\n\n<li>Reset Type: Report<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"269\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_163-1024x269.png\" alt=\"\" class=\"wp-image-14883\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_163-1024x269.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_163-300x79.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_163-768x202.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_163-1536x404.png 1536w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_163.png 1799w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">C\u00f3digo reporte final<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;\n&lt;!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 5.5.2  --&gt;\n&lt;jasperReport xmlns=\"http:\/\/jasperreports.sourceforge.net\/jasperreports\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xsi:schemaLocation=\"http:\/\/jasperreports.sourceforge.net\/jasperreports http:\/\/jasperreports.sourceforge.net\/xsd\/jasperreport.xsd\" name=\"R-PPI-PPE-AVANCEACCIONESTRATEGICA\" pageWidth=\"792\" pageHeight=\"612\" orientation=\"Landscape\" whenNoDataType=\"NoDataSection\" columnWidth=\"752\" leftMargin=\"20\" rightMargin=\"20\" topMargin=\"20\" bottomMargin=\"20\" uuid=\"d2f576f9-e4ac-445d-8a1d-ddcf62b47751\"&gt;\n\t&lt;property name=\"com.jaspersoft.studio.data.sql.tables\" value=\"\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.data.defaultdataadapter\" value=\"ORACLE-UNA\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.report.description\" value=\"Reporte de Avance de Acciones Estrat\u00e9gicas\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.unit.\" value=\"pixel\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.unit.pageHeight\" value=\"pixel\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.unit.pageWidth\" value=\"pixel\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.unit.topMargin\" value=\"pixel\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.unit.bottomMargin\" value=\"pixel\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.unit.leftMargin\" value=\"pixel\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.unit.rightMargin\" value=\"pixel\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.unit.columnWidth\" value=\"pixel\"\/&gt;\n\t&lt;property name=\"com.jaspersoft.studio.unit.columnSpacing\" value=\"pixel\"\/&gt;\n\t&lt;parameter name=\"SUBREPORT_DIR\" class=\"java.lang.String\"&gt;\n\t\t&lt;defaultValueExpression&gt;&lt;!&#91;CDATA&#91;\"\"]]&gt;&lt;\/defaultValueExpression&gt;\n\t&lt;\/parameter&gt;\n\t&lt;parameter name=\"unidadEjecutora\" class=\"java.lang.Long\"\/&gt;\n\t&lt;parameter name=\"etapaPlan\" class=\"java.lang.Long\"\/&gt;\n\t&lt;queryString language=\"SQL\"&gt;\n\t\t&lt;!&#91;CDATA&#91;SELECT\n    EP.PERIODO_ANUAL,\n    PEPMP.CODIGO || '.' || OEPMP.CODIGO || '.' || MPMP.CODIGO || '.' || ' ' || MPMP.DESCRIPCION AS META_PMP,\n    XE.CODIGO || '.' || ' ' || XE.DESCRIPCION AS ACCION_ESTRATEGICA,\n    UE.CODIGO AS CODIGO_UE,\n    UE.NOMBRE AS NOMBRE_UE,\n    AE.CODIGO || '.' ||  ' ' ||  AE.DESCRIPCION AS APORTE_ESTRATEGICO,\n    ROUND( AVG(MPE.EJECUCION),2) AS AVANCE_ACUMULADO\nFROM META_POA_EVALUACION MPE\nINNER JOIN META_POA MP ON MP.ID_META_POA = MPE.META_POA\nINNER JOIN META_POA_APORTE MPA ON MPA.META_POA = MP.ID_META_POA\nINNER JOIN APORTE_ESTRATEGICO AE ON AE.ID_APORTE_ESTRATEGICO = MPA.APORTE_ESTRATEGICO\nINNER JOIN PLAN_APORTE_ESTRATEGICO PAE ON PAE.ID_PLAN_APORTE_ESTRATEGICO = AE.PLAN_APORTE_ESTRATEGICO\nINNER JOIN UNIDAD_EJECUTORA UE ON UE.ID_UNIDAD_EJECUTORA = PAE.UNIDAD_EJECUTORA\nINNER JOIN ACCION_ESTRATEGICA XE ON XE.ID_ACCION_ESTRATEGICA = AE.ACCION_ESTRATEGICA\nINNER JOIN PLAN_ACCION_ESTRATEGICA PXE ON PXE.ID_PLAN_ACCION_ESTRATEGICA = XE.PLAN_ACCION_ESTRATEGICA\nINNER JOIN META_PMP MPMP ON MPMP.ID_META_PMP = XE.META_PMP\nINNER JOIN DETALLE_PMP DPMP ON DPMP.ID_DETALLE_PMP = MPMP.DETALLE_PMP\nINNER JOIN PRIORIDAD_ESTRATEGICA_PMP PEPMP ON PEPMP.ID_PRIORIDAD_ESTRATEGICA_PMP = DPMP.PRIORIDAD_ESTRATEGICA_PMP\nINNER JOIN OBJETIVO_ESTRATEGICO_PMP OEPMP ON OEPMP.ID_OBJETIVO_ESTRATEGICO_PMP = DPMP.OBJETIVO_ESTRATEGICO_PMP\nINNER JOIN ETAPA_PLAN EP ON (MPE.ETAPA_PLAN = EP.ID_ETAPA_PLAN)\nWHERE PXE.UNIDAD_EJECUTORA = $P{unidadEjecutora} AND MPE.ETAPA_PLAN = $P{etapaPlan} \nGROUP BY EP.PERIODO_ANUAL, PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, MPMP.DESCRIPCION, XE.CODIGO, XE.DESCRIPCION, UE.CODIGO, UE.NOMBRE, AE.CODIGO, AE.DESCRIPCION\nORDER BY EP.PERIODO_ANUAL, PEPMP.CODIGO, OEPMP.CODIGO, MPMP.CODIGO, XE.CODIGO, UE.CODIGO, UE.NOMBRE, AE.CODIGO]]&gt;\n\t&lt;\/queryString&gt;\n\t&lt;field name=\"PERIODO_ANUAL\" class=\"java.math.BigDecimal\"&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.name\" value=\"PERIODO_ANUAL\"\/&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.label\" value=\"PERIODO_ANUAL\"\/&gt;\n\t&lt;\/field&gt;\n\t&lt;field name=\"META_PMP\" class=\"java.lang.String\"&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.name\" value=\"META_PMP\"\/&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.label\" value=\"META_PMP\"\/&gt;\n\t&lt;\/field&gt;\n\t&lt;field name=\"ACCION_ESTRATEGICA\" class=\"java.lang.String\"&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.name\" value=\"ACCION_ESTRATEGICA\"\/&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.label\" value=\"ACCION_ESTRATEGICA\"\/&gt;\n\t&lt;\/field&gt;\n\t&lt;field name=\"CODIGO_UE\" class=\"java.lang.String\"&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.name\" value=\"CODIGO_UE\"\/&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.label\" value=\"CODIGO_UE\"\/&gt;\n\t&lt;\/field&gt;\n\t&lt;field name=\"NOMBRE_UE\" class=\"java.lang.String\"&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.name\" value=\"NOMBRE_UE\"\/&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.label\" value=\"NOMBRE_UE\"\/&gt;\n\t&lt;\/field&gt;\n\t&lt;field name=\"APORTE_ESTRATEGICO\" class=\"java.lang.String\"&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.name\" value=\"APORTE_ESTRATEGICO\"\/&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.label\" value=\"APORTE_ESTRATEGICO\"\/&gt;\n\t&lt;\/field&gt;\n\t&lt;field name=\"AVANCE_ACUMULADO\" class=\"java.math.BigDecimal\"&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.name\" value=\"AVANCE_ACUMULADO\"\/&gt;\n\t\t&lt;property name=\"com.jaspersoft.studio.field.label\" value=\"AVANCE_ACUMULADO\"\/&gt;\n\t&lt;\/field&gt;\n\t&lt;variable name=\"gradoAvanceAccionEstrategica\" class=\"java.math.BigDecimal\" resetType=\"Group\" resetGroup=\"METAS_y_ACCIONES\" calculation=\"Average\"&gt;\n\t\t&lt;variableExpression&gt;&lt;!&#91;CDATA&#91;$F{AVANCE_ACUMULADO}]]&gt;&lt;\/variableExpression&gt;\n\t&lt;\/variable&gt;\n\t&lt;variable name=\"AVANCE_ACUMULADO1\" class=\"java.math.BigDecimal\" resetType=\"Group\" resetGroup=\"METAS_y_ACCIONES\" calculation=\"Average\"&gt;\n\t\t&lt;variableExpression&gt;&lt;!&#91;CDATA&#91;$F{AVANCE_ACUMULADO}]]&gt;&lt;\/variableExpression&gt;\n\t&lt;\/variable&gt;\n\t&lt;variable name=\"AVANCE_ACUMULADO2\" class=\"java.math.BigDecimal\" calculation=\"Average\"&gt;\n\t\t&lt;variableExpression&gt;&lt;!&#91;CDATA&#91;$F{AVANCE_ACUMULADO}]]&gt;&lt;\/variableExpression&gt;\n\t&lt;\/variable&gt;\n\t&lt;variable name=\"etapaPlan_nombre\" class=\"java.lang.String\" calculation=\"System\"\/&gt;\n\t&lt;variable name=\"periodoAnual_nombre\" class=\"java.lang.String\" calculation=\"System\"\/&gt;\n\t&lt;variable name=\"unidadEjecutora_codigo_nombre\" class=\"java.lang.String\" calculation=\"System\"\/&gt;\n\t&lt;group name=\"METAS_y_ACCIONES\"&gt;\n\t\t&lt;groupExpression&gt;&lt;!&#91;CDATA&#91;$F{META_PMP}+$F{ACCION_ESTRATEGICA}]]&gt;&lt;\/groupExpression&gt;\n\t\t&lt;groupHeader&gt;\n\t\t\t&lt;band height=\"120\"&gt;\n\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;staticText&gt;\n\t\t\t\t\t&lt;reportElement mode=\"Transparent\" x=\"0\" y=\"0\" width=\"752\" height=\"20\" backcolor=\"#F0F0F0\" uuid=\"7a399b57-22e2-43a8-89ed-1da91053b1ff\"&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.width\" value=\"px\"\/&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t\t&lt;box topPadding=\"0\" leftPadding=\"0\" bottomPadding=\"0\" rightPadding=\"0\"&gt;\n\t\t\t\t\t\t&lt;pen lineWidth=\"0.25\" lineColor=\"#C4C4C4\"\/&gt;\n\t\t\t\t\t\t&lt;topPen lineWidth=\"1.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t\t&lt;leftPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t\t&lt;bottomPen lineWidth=\"1.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t\t&lt;rightPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t&lt;\/box&gt;\n\t\t\t\t\t&lt;textElement textAlignment=\"Left\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\" isBold=\"true\"\/&gt;\n\t\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Meta Estrat\u00e9gica:]]&gt;&lt;\/text&gt;\n\t\t\t\t&lt;\/staticText&gt;\n\t\t\t\t&lt;textField isStretchWithOverflow=\"true\"&gt;\n\t\t\t\t\t&lt;reportElement x=\"0\" y=\"20\" width=\"752\" height=\"30\" uuid=\"419cbffd-ff8e-4e6d-903a-718b4b928ca5\"&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t\t&lt;box topPadding=\"5\" leftPadding=\"0\" bottomPadding=\"5\" rightPadding=\"0\"\/&gt;\n\t\t\t\t\t&lt;textElement verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\"\/&gt;\n\t\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;$F{META_PMP}]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t\t&lt;\/textField&gt;\n\t\t\t\t&lt;textField isStretchWithOverflow=\"true\"&gt;\n\t\t\t\t\t&lt;reportElement x=\"0\" y=\"70\" width=\"752\" height=\"30\" uuid=\"369724b0-4c7f-4959-86e3-985fad5b4c5c\"&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t\t&lt;box topPadding=\"5\" leftPadding=\"0\" bottomPadding=\"5\" rightPadding=\"0\"\/&gt;\n\t\t\t\t\t&lt;textElement verticalAlignment=\"Top\"&gt;\n\t\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\"\/&gt;\n\t\t\t\t\t\t&lt;paragraph lineSpacing=\"Single\"\/&gt;\n\t\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;$F{ACCION_ESTRATEGICA}]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t\t&lt;\/textField&gt;\n\t\t\t\t&lt;staticText&gt;\n\t\t\t\t\t&lt;reportElement x=\"0\" y=\"50\" width=\"752\" height=\"20\" uuid=\"a7142e28-c2ab-4464-88fd-4abc8920432c\"&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.width\" value=\"px\"\/&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t\t&lt;box topPadding=\"5\" leftPadding=\"0\" bottomPadding=\"5\" rightPadding=\"0\"&gt;\n\t\t\t\t\t\t&lt;pen lineWidth=\"0.1\" lineColor=\"#777B7D\"\/&gt;\n\t\t\t\t\t\t&lt;topPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#BEC5C7\"\/&gt;\n\t\t\t\t\t\t&lt;leftPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t\t&lt;bottomPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#777B7D\"\/&gt;\n\t\t\t\t\t\t&lt;rightPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t&lt;\/box&gt;\n\t\t\t\t\t&lt;textElement textAlignment=\"Left\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\" isBold=\"true\"\/&gt;\n\t\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Acci\u00f3n Estrat\u00e9gica:]]&gt;&lt;\/text&gt;\n\t\t\t\t&lt;\/staticText&gt;\n\t\t\t\t&lt;staticText&gt;\n\t\t\t\t\t&lt;reportElement x=\"0\" y=\"100\" width=\"280\" height=\"20\" uuid=\"8502f95a-ca0b-47a1-935e-a398b1ce7043\"&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t\t&lt;box topPadding=\"0\" leftPadding=\"0\" bottomPadding=\"0\" rightPadding=\"0\"\/&gt;\n\t\t\t\t\t&lt;textElement verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\" isBold=\"true\"\/&gt;\n\t\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Unidad Ejecutora:]]&gt;&lt;\/text&gt;\n\t\t\t\t&lt;\/staticText&gt;\n\t\t\t\t&lt;staticText&gt;\n\t\t\t\t\t&lt;reportElement x=\"280\" y=\"100\" width=\"300\" height=\"20\" uuid=\"2d2ad03c-965b-4cb0-bdff-760488778e9b\"&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t\t&lt;box topPadding=\"0\" leftPadding=\"0\" bottomPadding=\"0\" rightPadding=\"0\"\/&gt;\n\t\t\t\t\t&lt;textElement verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\" isBold=\"true\"\/&gt;\n\t\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Aportes Estrat\u00e9gicos:]]&gt;&lt;\/text&gt;\n\t\t\t\t&lt;\/staticText&gt;\n\t\t\t\t&lt;staticText&gt;\n\t\t\t\t\t&lt;reportElement x=\"580\" y=\"100\" width=\"172\" height=\"20\" uuid=\"f95e3e57-d318-4aac-835a-a50269485c03\"&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t\t&lt;box topPadding=\"0\" bottomPadding=\"0\"\/&gt;\n\t\t\t\t\t&lt;textElement verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\" isBold=\"true\"\/&gt;\n\t\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Grado de Avance Acumulado:]]&gt;&lt;\/text&gt;\n\t\t\t\t&lt;\/staticText&gt;\n\t\t\t&lt;\/band&gt;\n\t\t&lt;\/groupHeader&gt;\n\t\t&lt;groupFooter&gt;\n\t\t\t&lt;band height=\"15\"&gt;\n\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;textField isStretchWithOverflow=\"true\" evaluationTime=\"Band\"&gt;\n\t\t\t\t\t&lt;reportElement x=\"580\" y=\"0\" width=\"172\" height=\"15\" uuid=\"965476e7-c4e3-49ba-a7f2-fc6bb05e8e66\"&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t\t&lt;box padding=\"0\"&gt;\n\t\t\t\t\t\t&lt;pen lineStyle=\"Solid\"\/&gt;\n\t\t\t\t\t\t&lt;topPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#E1E3E6\"\/&gt;\n\t\t\t\t\t\t&lt;leftPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#E1E3E6\"\/&gt;\n\t\t\t\t\t\t&lt;bottomPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#E1E3E6\"\/&gt;\n\t\t\t\t\t\t&lt;rightPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#E1E3E6\"\/&gt;\n\t\t\t\t\t&lt;\/box&gt;\n\t\t\t\t\t&lt;textElement textAlignment=\"Center\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\"\/&gt;\n\t\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;$V{AVANCE_ACUMULADO1}.setScale(2, RoundingMode.HALF_UP)+\"%\"]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t\t&lt;\/textField&gt;\n\t\t\t\t&lt;staticText&gt;\n\t\t\t\t\t&lt;reportElement x=\"0\" y=\"0\" width=\"580\" height=\"15\" isPrintWhenDetailOverflows=\"true\" uuid=\"6c09a4ec-17d3-494d-9bf9-3c8408a2eba3\"&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.width\" value=\"px\"\/&gt;\n\t\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t\t&lt;textElement textAlignment=\"Right\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\" isBold=\"true\"\/&gt;\n\t\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Grado de Avance:]]&gt;&lt;\/text&gt;\n\t\t\t\t&lt;\/staticText&gt;\n\t\t\t&lt;\/band&gt;\n\t\t&lt;\/groupFooter&gt;\n\t&lt;\/group&gt;\n\t&lt;background&gt;\n\t\t&lt;band splitType=\"Stretch\"\/&gt;\n\t&lt;\/background&gt;\n\t&lt;title&gt;\n\t\t&lt;band height=\"60\" splitType=\"Stretch\"&gt;\n\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t&lt;staticText&gt;\n\t\t\t\t&lt;reportElement x=\"0\" y=\"0\" width=\"752\" height=\"15\" uuid=\"3c33a882-b415-4aa1-9b8a-1817f08ba095\"&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.width\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Center\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"12\" isBold=\"true\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Universidad Nacional]]&gt;&lt;\/text&gt;\n\t\t\t&lt;\/staticText&gt;\n\t\t\t&lt;staticText&gt;\n\t\t\t\t&lt;reportElement x=\"0\" y=\"15\" width=\"752\" height=\"15\" uuid=\"c612af41-d8a3-4001-9de3-9e071da27f98\"&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.width\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Center\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"12\" isBold=\"true\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;\u00c1rea de Planificaci\u00f3n]]&gt;&lt;\/text&gt;\n\t\t\t&lt;\/staticText&gt;\n\t\t\t&lt;staticText&gt;\n\t\t\t\t&lt;reportElement x=\"0\" y=\"30\" width=\"752\" height=\"15\" uuid=\"bf8be4f5-1ced-47ec-8d8c-8bca975ef901\"&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.width\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Center\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"12\" isBold=\"true\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Grado de Avance de las Acciones Estrat\u00e9gicas]]&gt;&lt;\/text&gt;\n\t\t\t&lt;\/staticText&gt;\n\t\t\t&lt;subreport overflowType=\"NoStretch\"&gt;\n\t\t\t\t&lt;reportElement positionType=\"Float\" x=\"0\" y=\"45\" width=\"752\" height=\"15\" uuid=\"10b13818-5171-40a5-a0a6-8ad8858c2b69\"&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t&lt;subreportParameter name=\"etapaPlan\"&gt;\n\t\t\t\t\t&lt;subreportParameterExpression&gt;&lt;!&#91;CDATA&#91;$P{etapaPlan}.longValue()]]&gt;&lt;\/subreportParameterExpression&gt;\n\t\t\t\t&lt;\/subreportParameter&gt;\n\t\t\t\t&lt;connectionExpression&gt;&lt;!&#91;CDATA&#91;$P{REPORT_CONNECTION}]]&gt;&lt;\/connectionExpression&gt;\n\t\t\t\t&lt;returnValue subreportVariable=\"etapaPlan_nombre\" toVariable=\"etapaPlan_nombre\"\/&gt;\n\t\t\t\t&lt;subreportExpression&gt;&lt;!&#91;CDATA&#91;$P{SUBREPORT_DIR} + \"R-PPI-PPO-SUB-ETAPAPLANNOMBRE-VARIABLE.jasper\"]]&gt;&lt;\/subreportExpression&gt;\n\t\t\t&lt;\/subreport&gt;\n\t\t\t&lt;textField evaluationTime=\"Band\" pattern=\"\"&gt;\n\t\t\t\t&lt;reportElement x=\"0\" y=\"45\" width=\"752\" height=\"15\" uuid=\"b99fd990-0c99-4883-84c3-3e0110f1f741\"\/&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Center\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"10\" isBold=\"true\" isPdfEmbedded=\"false\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;\"Etapa: \" +$V{etapaPlan_nombre} + \" \" + $V{periodoAnual_nombre}]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t\t&lt;subreport&gt;\n\t\t\t\t&lt;reportElement x=\"0\" y=\"45\" width=\"752\" height=\"15\" uuid=\"7aaf1203-ca63-488d-adfa-30b0282f9f8d\"\/&gt;\n\t\t\t\t&lt;subreportParameter name=\"periodoAnual\"&gt;\n\t\t\t\t\t&lt;subreportParameterExpression&gt;&lt;!&#91;CDATA&#91;$F{PERIODO_ANUAL}.longValue()]]&gt;&lt;\/subreportParameterExpression&gt;\n\t\t\t\t&lt;\/subreportParameter&gt;\n\t\t\t\t&lt;connectionExpression&gt;&lt;!&#91;CDATA&#91;$P{REPORT_CONNECTION}]]&gt;&lt;\/connectionExpression&gt;\n\t\t\t\t&lt;returnValue subreportVariable=\"periodoAnual_nombre\" toVariable=\"periodoAnual_nombre\"\/&gt;\n\t\t\t\t&lt;subreportExpression&gt;&lt;!&#91;CDATA&#91;$P{SUBREPORT_DIR} + \"R-PPI-PPO-SUB-PERIODOANUALNOMBRE-VARIABLE.jasper\"]]&gt;&lt;\/subreportExpression&gt;\n\t\t\t&lt;\/subreport&gt;\n\t\t&lt;\/band&gt;\n\t&lt;\/title&gt;\n\t&lt;pageHeader&gt;\n\t\t&lt;band height=\"30\"&gt;\n\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t&lt;printWhenExpression&gt;&lt;!&#91;CDATA&#91;$V{PAGE_NUMBER}.equals(1)]]&gt;&lt;\/printWhenExpression&gt;\n\t\t\t&lt;staticText&gt;\n\t\t\t\t&lt;reportElement x=\"0\" y=\"15\" width=\"90\" height=\"15\" uuid=\"c904d035-9fd2-486b-b1cc-8b96734b08a5\"&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t&lt;textElement verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\" isBold=\"true\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Unidad Ejecutora:]]&gt;&lt;\/text&gt;\n\t\t\t&lt;\/staticText&gt;\n\t\t\t&lt;textField pattern=\"dd\/MM\/yyyy\"&gt;\n\t\t\t\t&lt;reportElement x=\"0\" y=\"0\" width=\"90\" height=\"15\" uuid=\"6642d4f9-2708-4a64-a826-074b4e93d139\"\/&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Left\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"7\" isBold=\"false\" isItalic=\"false\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;new java.util.Date()]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t\t&lt;textField&gt;\n\t\t\t\t&lt;reportElement x=\"90\" y=\"0\" width=\"626\" height=\"15\" uuid=\"22fe0526-a008-43cf-a0b7-b467094f7a4a\"\/&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Right\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"7\" isBold=\"false\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;\"P\u00e1gina \"+$V{PAGE_NUMBER}+\" de\"]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t\t&lt;textField evaluationTime=\"Report\"&gt;\n\t\t\t\t&lt;reportElement x=\"716\" y=\"0\" width=\"36\" height=\"15\" uuid=\"a89560aa-1613-4487-9db6-888cef96f1ed\"\/&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Left\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"7\" isBold=\"false\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;\" \"+$V{PAGE_NUMBER}]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t\t&lt;subreport&gt;\n\t\t\t\t&lt;reportElement x=\"90\" y=\"15\" width=\"662\" height=\"15\" uuid=\"bf861b5f-a255-4326-8c93-061bbcaffd23\"\/&gt;\n\t\t\t\t&lt;subreportParameter name=\"unidadEjecutora\"&gt;\n\t\t\t\t\t&lt;subreportParameterExpression&gt;&lt;!&#91;CDATA&#91;$P{unidadEjecutora}.longValue()]]&gt;&lt;\/subreportParameterExpression&gt;\n\t\t\t\t&lt;\/subreportParameter&gt;\n\t\t\t\t&lt;connectionExpression&gt;&lt;!&#91;CDATA&#91;$P{REPORT_CONNECTION}]]&gt;&lt;\/connectionExpression&gt;\n\t\t\t\t&lt;returnValue subreportVariable=\"unidadEjecutora_codigo_nombre\" toVariable=\"unidadEjecutora_codigo_nombre\"\/&gt;\n\t\t\t\t&lt;subreportExpression&gt;&lt;!&#91;CDATA&#91;$P{SUBREPORT_DIR} + \"R-PPI-PPO-SUB-UNIDADEJECUTORA-VARIABLE.jasper\"]]&gt;&lt;\/subreportExpression&gt;\n\t\t\t&lt;\/subreport&gt;\n\t\t\t&lt;textField evaluationTime=\"Band\" pattern=\"\"&gt;\n\t\t\t\t&lt;reportElement x=\"90\" y=\"15\" width=\"662\" height=\"15\" uuid=\"38d29481-2668-43ef-91d5-d28dacb0699a\"\/&gt;\n\t\t\t\t&lt;textElement verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"7\" isBold=\"false\" isPdfEmbedded=\"false\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;$V{unidadEjecutora_codigo_nombre}]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t&lt;\/band&gt;\n\t&lt;\/pageHeader&gt;\n\t&lt;detail&gt;\n\t\t&lt;band height=\"20\" splitType=\"Stretch\"&gt;\n\t\t\t&lt;textField isStretchWithOverflow=\"true\"&gt;\n\t\t\t\t&lt;reportElement stretchType=\"RelativeToBandHeight\" x=\"0\" y=\"0\" width=\"90\" height=\"20\" uuid=\"185c6078-e0f3-4a1e-8d5b-1cba511cdabe\"&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t&lt;box topPadding=\"2\" bottomPadding=\"2\"\/&gt;\n\t\t\t\t&lt;textElement verticalAlignment=\"Top\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;$F{CODIGO_UE}]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t\t&lt;textField isStretchWithOverflow=\"true\"&gt;\n\t\t\t\t&lt;reportElement stretchType=\"RelativeToBandHeight\" x=\"90\" y=\"0\" width=\"190\" height=\"20\" uuid=\"58218cf0-1cb7-4b07-b199-b0b5aa264bc7\"\/&gt;\n\t\t\t\t&lt;box topPadding=\"2\" bottomPadding=\"2\"\/&gt;\n\t\t\t\t&lt;textElement&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;$F{NOMBRE_UE}]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t\t&lt;textField isStretchWithOverflow=\"true\"&gt;\n\t\t\t\t&lt;reportElement stretchType=\"RelativeToBandHeight\" x=\"280\" y=\"0\" width=\"300\" height=\"20\" printWhenGroupChanges=\"METAS_y_ACCIONES\" uuid=\"8dc52787-bff2-4d49-9051-7e08db69d5da\"\/&gt;\n\t\t\t\t&lt;box topPadding=\"2\" bottomPadding=\"2\"\/&gt;\n\t\t\t\t&lt;textElement&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;$F{APORTE_ESTRATEGICO}]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t\t&lt;textField isStretchWithOverflow=\"true\"&gt;\n\t\t\t\t&lt;reportElement stretchType=\"RelativeToBandHeight\" x=\"580\" y=\"0\" width=\"172\" height=\"20\" uuid=\"d21758f6-de13-455c-9e13-c0b7b24f4099\"\/&gt;\n\t\t\t\t&lt;box topPadding=\"2\" bottomPadding=\"2\"\/&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Center\" verticalAlignment=\"Top\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;$F{AVANCE_ACUMULADO}+\"%\"]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t&lt;\/band&gt;\n\t&lt;\/detail&gt;\n\t&lt;summary&gt;\n\t\t&lt;band height=\"15\"&gt;\n\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t&lt;textField isStretchWithOverflow=\"true\" evaluationTime=\"Report\"&gt;\n\t\t\t\t&lt;reportElement stretchType=\"RelativeToBandHeight\" x=\"580\" y=\"0\" width=\"172\" height=\"15\" uuid=\"b8aa19eb-9eda-424b-8b00-87a7e4624a3e\"&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t&lt;box&gt;\n\t\t\t\t\t&lt;topPen lineWidth=\"1.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t&lt;leftPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t&lt;bottomPen lineWidth=\"1.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t&lt;rightPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t&lt;\/box&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Center\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;textFieldExpression&gt;&lt;!&#91;CDATA&#91;$V{AVANCE_ACUMULADO2}.setScale(2, RoundingMode.HALF_UP)+\"%\"]]&gt;&lt;\/textFieldExpression&gt;\n\t\t\t&lt;\/textField&gt;\n\t\t\t&lt;staticText&gt;\n\t\t\t\t&lt;reportElement stretchType=\"RelativeToBandHeight\" x=\"0\" y=\"0\" width=\"580\" height=\"15\" uuid=\"798c9aeb-72fc-4b41-8d6c-69c825a9fd80\"&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.width\" value=\"px\"\/&gt;\n\t\t\t\t\t&lt;property name=\"com.jaspersoft.studio.unit.height\" value=\"px\"\/&gt;\n\t\t\t\t&lt;\/reportElement&gt;\n\t\t\t\t&lt;box&gt;\n\t\t\t\t\t&lt;topPen lineWidth=\"1.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t&lt;leftPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t&lt;bottomPen lineWidth=\"1.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t\t&lt;rightPen lineWidth=\"0.0\" lineStyle=\"Solid\" lineColor=\"#000000\"\/&gt;\n\t\t\t\t&lt;\/box&gt;\n\t\t\t\t&lt;textElement textAlignment=\"Right\" verticalAlignment=\"Middle\"&gt;\n\t\t\t\t\t&lt;font fontName=\"DejaVu Sans\" size=\"8\" isBold=\"true\"\/&gt;\n\t\t\t\t&lt;\/textElement&gt;\n\t\t\t\t&lt;text&gt;&lt;!&#91;CDATA&#91;Grado de Avance General:]]&gt;&lt;\/text&gt;\n\t\t\t&lt;\/staticText&gt;\n\t\t&lt;\/band&gt;\n\t&lt;\/summary&gt;\n&lt;\/jasperReport&gt;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Publicar el reporte en servidor desarrollo<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Abrimos la terminal <\/li>\n\n\n\n<li>Y vamos al directorio<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/home\/tavo\/JaspersoftWorkspace\/MyReports\/<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ingresamos al servidor remoto<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>ssh cgi@10.0.100.30<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nos ubicamos a la direcci\u00f3n del reporte<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/reportes\/<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lo identificamos<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"534\" height=\"155\" src=\"\/wp-content\/uploads\/2022\/11\/Seleccion_091-2.png\" alt=\"\" class=\"wp-image-13968\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_091-2.png 534w, https:\/\/sada.services\/wp-content\/uploads\/2022\/11\/Seleccion_091-2-300x87.png 300w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lo enviamos al servidor<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/Codigo\nscp REPORTE.jasper tomcat8@10.0.2.231:\/reportes\n\n\/\/ Ejemplo:\nscp R-PPI-PPE-AVANCEACCIONESTRATEGICA.jasper tomcat8@10.0.2.231:\/reportes\n\nscp R-PPI-PPE-METPORENCMON.jasper tomcat8@10.0.2.231:\/reportes<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>pass: user4tomcat<\/li>\n\n\n\n<li>RESULTADO<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>tomcat8@10.0.2.231's password: \nR-PPI-PPE-AVANCEACCIONESTRATEGICA.jasper      100%   43KB 150.2KB\/s   00:00 <\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Desplegar Reporte en SIGESA<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Luego debemos registrar el nuevo reporte dentro del sistema<\/li>\n\n\n\n<li>ingresamos a:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Lista de Reportes<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"380\" height=\"463\" src=\"\/wp-content\/uploads\/2022\/10\/Seleccion_388.png\" alt=\"\" class=\"wp-image-13095\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2022\/10\/Seleccion_388.png 380w, https:\/\/sada.services\/wp-content\/uploads\/2022\/10\/Seleccion_388-246x300.png 246w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le damos nuevo<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"433\" height=\"330\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_206.png\" alt=\"\" class=\"wp-image-14938\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_206.png 433w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_206-300x229.png 300w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Completamos:<\/li>\n\n\n\n<li>Nombre: R-PPI-PPE-AVANCEACCIONESTRATEGICA<\/li>\n\n\n\n<li>Descripci\u00f3n: PPI-PPE: Reporte de Avance de Acciones Estrategicas<\/li>\n\n\n\n<li>Tiene subreportes: Si<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"729\" height=\"603\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_207.png\" alt=\"\" class=\"wp-image-14939\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_207.png 729w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_207-300x248.png 300w\" sizes=\"(max-width: 729px) 100vw, 729px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Luego debemos reportar el recurso<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Lista de Recursos<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"296\" height=\"253\" src=\"\/wp-content\/uploads\/2022\/10\/Seleccion_393.png\" alt=\"\" class=\"wp-image-13098\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nuevo, pero aqupi debemos registrarlo de la siguiente forma<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>\/pages\/reporteJobLauncher.xhtml?reporte=R-PPI-PPE-AVANCEACCIONESTRATEGICA<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"794\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_208.png\" alt=\"\" class=\"wp-image-14940\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_208.png 735w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_208-278x300.png 278w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Y le debemos asiganar un rol, para PPI UNA_PPE_ADMIN<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"793\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_209.png\" alt=\"\" class=\"wp-image-14941\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_209.png 739w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_209-280x300.png 280w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora debemos registrar el recurso en lista de menu<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Lista de Men\u00fa<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Agregamos el men\u00fa<\/li>\n\n\n\n<li>PPE &#8211; Reportes<\/li>\n\n\n\n<li>\/pages\/reporteJobLauncher.xhtml?reporte=R-PPI-PPE-AVANCEACCIONESTRATEGICA<\/li>\n\n\n\n<li>Reporte Avance Acciones Estrat\u00e9gicas<\/li>\n\n\n\n<li><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"767\" height=\"682\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_210.png\" alt=\"\" class=\"wp-image-14942\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_210.png 767w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_210-300x267.png 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Parametros<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Regresamos a la lista de reportes <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Lista de reportes<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vamos a parametros<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"984\" height=\"317\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_211.png\" alt=\"\" class=\"wp-image-14943\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_211.png 984w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_211-300x97.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_211-768x247.png 768w\" sizes=\"(max-width: 984px) 100vw, 984px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Agregamos el parametro <\/li>\n\n\n\n<li>etapaPlan<\/li>\n\n\n\n<li>Etapa Plan<\/li>\n\n\n\n<li>Objeto<\/li>\n\n\n\n<li>Requerido<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"561\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_212.png\" alt=\"\" class=\"wp-image-14944\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_212.png 594w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_212-300x283.png 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Luego lo configuramos<\/li>\n\n\n\n<li>cr.ac.una.cgi.sigesa.ppi.ppo.domain.EtapaPlan<\/li>\n\n\n\n<li>nombre<\/li>\n\n\n\n<li>completeEtapaPlanByTipoEtapaEvaluacionReporte<\/li>\n\n\n\n<li>planAporteEstrategico_etapaPlan_label<\/li>\n\n\n\n<li>EtapaPlanLOVBean<\/li>\n\n\n\n<li>etapaPlanByTipoEtapaEvaluacionReporteLOV<\/li>\n\n\n\n<li>EtapaPlanBean<\/li>\n\n\n\n<li>EtapaPlanService<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"599\" height=\"709\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_213.png\" alt=\"\" class=\"wp-image-14946\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_213.png 599w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_213-253x300.png 253w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Agregamos el parametro \u00abunidadEjecutora\u00bb<\/li>\n\n\n\n<li>unidadEjecutora<\/li>\n\n\n\n<li>Unidad Ejecutora<\/li>\n\n\n\n<li>Requerido<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"699\" height=\"695\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_214.png\" alt=\"\" class=\"wp-image-14948\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_214.png 699w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_214-300x298.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_214-150x150.png 150w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Editamos el parametros\n<ul class=\"wp-block-list\">\n<li>cr.ac.una.cgi.sigesa.epf.cpr.domain.UnidadEjecutora<\/li>\n\n\n\n<li>codigo<\/li>\n\n\n\n<li>completePPIUnidadEjecutoraInPAEAclReporte<\/li>\n\n\n\n<li>planAporteEstrategico_unidadEjecutora_label<\/li>\n\n\n\n<li>UnidadEjecutoraLOVBean<\/li>\n\n\n\n<li>unidadesEjecutorasInPAEAclReporteLOV<\/li>\n\n\n\n<li>UnidadEjecutoraBean<\/li>\n\n\n\n<li>UnidadEjecutoraService<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"711\" src=\"\/wp-content\/uploads\/2023\/05\/Seleccion_215.png\" alt=\"\" class=\"wp-image-14949\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_215.png 605w, https:\/\/sada.services\/wp-content\/uploads\/2023\/05\/Seleccion_215-255x300.png 255w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ademas debemos crear estos metodos<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">UnidadEjecutoraService.java<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>\/**\n     * Devuelve una pagina de unidades ejecutoras que tengan un Plan de Acci\u00f3n Estrat\u00e9gica\n     * @author Gustavo Matamoros Gonz\u00e1lez \n     * @param filterSpecifications\n     * @param query\n     * @param acl\n     * @param pageable\n     * @return {link Page&lt;UnidadEjecutora&gt;}\n     * @issue PPI-372\n     * @sinse 10\/05\/2023\n     *\/\n    public Page&lt;UnidadEjecutora&gt; completePPIUnidadEjecutoraInPAEAclReporte(ArrayList&lt;FilterSpecification&gt; filterSpecifications, String query, String acl, Pageable pageable);\n\n    \/**\n     * Devuelve una pagina de unidades ejecutoras que tengan un Plan de Acci\u00f3n Estrat\u00e9gica\n     * @author Gustavo Matamoros Gonz\u00e1lez  \n     * @param query\n     * @param filterSpecifications\n     * @param pageable\n     * @return {link Page&lt;UnidadEjecutora&gt;}\n     * @issue PPI-372\n     * @sinse 10\/05\/2023\n     *\/\n    public Page&lt;UnidadEjecutora&gt; completePPIUnidadEjecutoraInPAEAcl(String query, ArrayList&lt;FilterSpecification&gt; filterSpecifications, Pageable pageable);\n\n\n    \/**\n     * Devuelve una pagina de unidades ejecutoras que tengan un Plan de Acci\u00f3n Estrat\u00e9gica\n     * @author Gustavo Matamoros Gonz\u00e1lez  \n     * @param filterSpecifications\n     * @param pageable\n     * @param filterParams\n     * @return {link Page&lt;UnidadEjecutora&gt;}\n     * @issue PPI-372\n     * @sinse 10\/05\/2023\n     *\/\n    public Page&lt;UnidadEjecutora&gt; unidadesEjecutorasInPAEAclLOV(ArrayList&lt;FilterSpecification&gt; filterSpecifications, Pageable pageable, Map&lt;String, Object&gt; filterParams);\n\n    \/**\n     * Devuelve una pagina de unidades ejecutoras que tengan un Plan de Acci\u00f3n Estrat\u00e9gica orientado a reportes\n     * @author Gustavo Matamoros Gonz\u00e1lez  \n     * @param filterSpecifications\n     * @param pageable\n     * @param filterParams\n     * @return {link Page&lt;UnidadEjecutora&gt;}\n     * @issue PPI-372\n     * @sinse 10\/05\/2023\n     *\/\n    public Page&lt;UnidadEjecutora&gt;  unidadesEjecutorasInPAEAclReporteLOV(ArrayList&lt;FilterSpecification&gt; filterSpecifications, Pageable pageable, Map&lt;String, Object&gt; filterParams);\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">UnidadEjecutoraServiceImpl.java<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>@Override\n    public Page&lt;UnidadEjecutora&gt; completePPIUnidadEjecutoraInPAEAclReporte(ArrayList&lt;FilterSpecification&gt; filterSpecifications, String query, String acl, Pageable pageable) {\n        return completePPIUnidadEjecutoraInPAEAcl(query, filterSpecifications, pageable);\n    }\n  \n\n    @Override\n    public Page&lt;UnidadEjecutora&gt; completePPIUnidadEjecutoraInPAEAcl(String query, ArrayList&lt;FilterSpecification&gt; filterSpecifications, Pageable pageable) {\n        \n        String aclJson = getAclJSON(\"ppi_ppo_evaluacion_operativa_complete_unidad_ejecutora_acl\");\n\n        this.setFilterSpecifications(filterSpecifications);\n        this.setAclSecure(aclJson);\n\n        Specification specBusquedaCodigo = UnidadEjecutoraSpecs.BuscarUnidadEjecutoraPorCodigo(query);\n        Specification specBusquedaPAE = UnidadEjecutoraSpecs.unidadesEjecutorasInPAE();\n\n        Specification&lt;UnidadEjecutora&gt; specFinal = Specification.where(specBusquedaCodigo).and(specBusquedaPAE).and(this);\n\n        Page&lt;UnidadEjecutora&gt; pagina = repository.findAll(specFinal,pageable);\n        this.setAclSecure(null);\n        return pagina;\n\n    }\n\n    @Override\n    public Page&lt;UnidadEjecutora&gt; unidadesEjecutorasInPAEAclLOV(ArrayList&lt;FilterSpecification&gt; filterSpecifications, Pageable pageable, Map&lt;String, Object&gt; filterParams) {\n        \n        \n        String acl = (String) filterParams.get(\"aclJson\");\n        String aclJson = getAclJSON(acl);\n        \n        Specification specBusquedaPAE = UnidadEjecutoraSpecs.unidadesEjecutorasInPAE();\n        \n        \n        this.setFilterSpecifications(filterSpecifications);\n        this.setAclSecure(aclJson);\n        Specification&lt;UnidadEjecutora&gt; specFinal = Specification.where(specBusquedaPAE).and(this);\n        Page&lt;UnidadEjecutora&gt; pagina = repository.findAll(specFinal,pageable);\n        this.setAclSecure(null);\n        return pagina;\n    }\n\n    @Override\n    public Page&lt;UnidadEjecutora&gt;  unidadesEjecutorasInPAEAclReporteLOV(ArrayList&lt;FilterSpecification&gt; filterSpecifications, Pageable pageable, Map&lt;String, Object&gt; filterParams) {\n        if (filterParams == null) {\n            filterParams = new HashMap();\n        }\n        if (!filterParams.containsKey(\"aclJson\")) {\n            filterParams.put(\"aclJson\", \"ppi_ppo_evaluacion_operativa_complete_unidad_ejecutora_acl\");\n        }\n        return unidadesEjecutorasInPAEAclLOV(filterSpecifications, pageable, filterParams);\n    }<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Tarea: Yo como&nbsp;usuario del sistema de Planificaci\u00f3n institucional&nbsp;requiero crear el reporte que muestre el grado de avance de las acciones estrat\u00e9gicas por facultad, centro, sede, secci\u00f3n regional, vicerrector\u00edas, rector\u00eda para valorar evoluci\u00f3n de la planificaci\u00f3n mediano plazo y toma de decisiones para su futura rendici\u00f3n de cuentas Criterios de aceptaci\u00f3n: BD: SELECT Creaci\u00f3n de reporte [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[443],"tags":[512,513,446,448,444],"class_list":["post-14820","post","type-post","status-publish","format-standard","hentry","category-sigesa","tag-acciones-estrategicas","tag-avance","tag-jasper","tag-reporte","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\/14820","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=14820"}],"version-history":[{"count":31,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/14820\/revisions"}],"predecessor-version":[{"id":14954,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/14820\/revisions\/14954"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}