Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Parametros en el Reporte

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jul 2009
    Posts
    22

    Default Parametros en el Reporte

    hola, soy nuevo en pentaho y me gustaria me ayuden a crear un reporte con parametros de usuario.

    Ya tengo el reporte creado con report designer, ya lo publique en mi solucion del BI Server y todo funciona bien, el reporte muestra demasiados datos por lo que quiero añadir un parametro o filtro para que cuando el usuario abra el reporte este le solicite por ejemplo ingresar el año que quiere consultar.

    Bueno, me base en esta pagina http://wiki.pentaho.com/display/Repo...shing+a+Report para crear el parametro, aparentemente se ve facil, solo de aumentar en el where del query el parametro '{ANIO}' y listo!!! pero no es asi, al momento de publicar no me muestra el parametro y si ejecuto el reporte no retorna datos ya que supongo que toma como valor {ANIO} ya que esta dentro de comillas simples.

    El archivo .xaction que genero al publicar el reporte, lo abri con desing studio y agregue el parametro basandome en un ejemplo, pero una vez que ya tengo modificado el .xaction como hago para publicarlo??? o para que los cambio que hice se vean reflejados en el reporte publicado en el BI Server???

    gracias por su ayuda.

  2. #2
    Join Date
    Jul 2009
    Posts
    22

    Default parametro

    ya lo resolvi.... un simple caracter... en el where del query el parametro va de esta forma '${ANIO}' asi ya aparece el parametro al momento de llamar al reporte, pero ahora no me retorna datos... y estoy seguro que si deberia...

    Por otro lado, si pueden ayudenme por favor a enteneder como funciona el desing studio, quiero poner un alista de valores como parametro del reporte y entiendo esto se hace con desing studio, ya lo hice, guardo el archivo y luego que??? se debe volver a publicar o algo por el estilo?? xq una vez q modifico el .xaction y guardo los cambios... este ya no aparece publicado en el BI SErver.

    Gracias.

  3. #3
    Join Date
    Jul 2009
    Posts
    22

    Default

    por si alguien esta usando la version 1.7 les comento que encontre el siguiente bug http://jira.pentaho.com/browse/PRD-696. Al usar parametros añades en el where '${parametro}' si te crea en el reporte el prompt para el parametro pero el query lee otro valor...

  4. #4
    Join Date
    Jul 2009
    Posts
    22

    Default Report Designer no levanta

    me he bajado la version 1.7.1 y la 3 del Report Designer para instalar en mi maquina (Win xp), segun las guias de instalacion solo debo descomprimir el archivo (prd-ce-src-3.0.0.37222.RC2.zip), ubicarlo en una ruta cuyo nombre no posea espacios en blanco y ejecutar el archivo startdesigner.bat; el problema es que no me levanta el Report Designer...

    me levanta un ventana del cmd y parece que carga las .jar pero al final aparece el mensaje: "Presiones cualquier tecla para continuar..." y hasta ahi llega...

    alguien podria ayudarme dandome las instrucciones para levantar o ejecutar el Report Designer versuib 1.7.1 o 3.

    gracias

  5. #5
    Join Date
    Jul 2007
    Posts
    1,013

    Default

    ¿Podrás pegar la salida de la pantalla de comando, para que veamos qué puede estar pasando?

    ¡Saludos!

  6. #6
    Join Date
    Jul 2009
    Posts
    22

    Default

    Hola, gracias por tu interes...

    Según la guia de instalacion... solo debo descomprimir el archivo y ejecutar el archivo startdesigner.bat, dicho archivo esta en la carpeta src, cuando lo ejecuto devuelve el siguiente resultado:
    ---------------
    C:\report-designer\src>java -XX:MaxPermSize=256m -Xms256m -Xmx512m -Dswt.swing.l
    af=com.sun.java.swing.plaf.windows.WindowsLookAndFeel -jar launcher/launcher-1.0
    .0.jar org.pentaho.reportdesigner.crm.report.ReportDialog
    Unable to access jarfile launcher/launcher-1.0.0.jar
    C:\report-designer\src>pause
    Presione una tecla para continuar . . .
    ----------------
    y hasta ahi llega... si copio el archivo startdesigner.bat un nivel mas arriba, es decir en la directorio donde descomprimes o para ser mas exacto en la misma ruta donde esta el archivo ReportDesigner.exe y lo ejecuto, me da lo siguiente:
    ----------------

    C:\report-designer>java -XX:MaxPermSize=256m -Xms256m -Xmx512m -Dswt.swing.laf=c
    om.sun.java.swing.plaf.windows.WindowsLookAndFeel -jar launcher/launcher-1.0.0.j
    ar org.pentaho.reportdesigner.crm.report.ReportDialog
    configurationFile: C:\report-designer\launcher\launcher.properties
    Invalid classpath entry, ignoring '../bin'
    Application Directory: C:\report-designer\launcher
    ClassPath[0] = file:/C:/report-designer/launcher/../resources/
    ClassPath[1] = file:/C:/report-designer/launcher/../lib/
    ClassPath[2] = file:/C:/report-designer/launcher/../lib/acegi-security-1.0.6.jar
    ClassPath[3] = file:/C:/report-designer/launcher/../lib/activation.jar
    ClassPath[4] = file:/C:/report-designer/launcher/../lib/annotations.jar
    ClassPath[5] = file:/C:/report-designer/launcher/../lib/antlr-2.7.6.jar
    ClassPath[6] = file:/C:/report-designer/launcher/../lib/asm-all-2.2.3.jar
    ClassPath[7] = file:/C:/report-designer/launcher/../lib/asm-attrs.jar
    ClassPath[8] = file:/C:/report-designer/launcher/../lib/bsf-2.4.0.jar
    ClassPath[9] = file:/C:/report-designer/launcher/../lib/bsh-1.3.0.jar
    ClassPath[10] = file:/C:/report-designer/launcher/../lib/castor-1.0.5.jar
    ClassPath[11] = file:/C:/report-designer/launcher/../lib/cglib.jar
    ClassPath[12] = file:/C:/report-designer/launcher/../lib/commons-beanutils-bean-
    collections.jar
    ClassPath[13] = file:/C:/report-designer/launcher/../lib/commons-codec-1.3.jar
    ClassPath[14] = file:/C:/report-designer/launcher/../lib/commons-collections-3.2
    .jar
    ClassPath[15] = file:/C:/report-designer/launcher/../lib/commons-dbcp-1.2.1.jar
    ClassPath[16] = file:/C:/report-designer/launcher/../lib/commons-fileupload-1.2.
    1.jar
    ClassPath[17] = file:/C:/report-designer/launcher/../lib/commons-httpclient-3.0.
    1.jar
    ClassPath[18] = file:/C:/report-designer/launcher/../lib/commons-io-1.4.jar
    ClassPath[19] = file:/C:/report-designer/launcher/../lib/commons-javaflow-200604
    11.jar
    ClassPath[20] = file:/C:/report-designer/launcher/../lib/commons-lang-2.2.jar
    ClassPath[21] = file:/C:/report-designer/launcher/../lib/commons-logging.jar
    ClassPath[22] = file:/C:/report-designer/launcher/../lib/commons-math-1.0.jar
    ClassPath[23] = file:/C:/report-designer/launcher/../lib/commons-pool-1.2.jar
    ClassPath[24] = file:/C:/report-designer/launcher/../lib/commons-vfs-1.0.jar
    ClassPath[25] = file:/C:/report-designer/launcher/../lib/dom4j-1.6.1.jar
    ClassPath[26] = file:/C:/report-designer/launcher/../lib/ehcache.jar
    ClassPath[27] = file:/C:/report-designer/launcher/../lib/eigenbase-properties.ja
    r
    ClassPath[28] = file:/C:/report-designer/launcher/../lib/eigenbase-resgen.jar
    ClassPath[29] = file:/C:/report-designer/launcher/../lib/eigenbase-xom.jar
    ClassPath[30] = file:/C:/report-designer/launcher/../lib/forms-1.0.7.jar
    ClassPath[31] = file:/C:/report-designer/launcher/../lib/itext-1.5.2.jar
    ClassPath[32] = file:/C:/report-designer/launcher/../lib/javacup.jar
    ClassPath[33] = file:/C:/report-designer/launcher/../lib/jaxen.jar
    ClassPath[34] = file:/C:/report-designer/launcher/../lib/jcommon-1.0.14.jar
    ClassPath[35] = file:/C:/report-designer/launcher/../lib/jcommon-logging-log4jlo
    g-1.0.2.jar
    ClassPath[36] = file:/C:/report-designer/launcher/../lib/jcommon-serializer-0.2.
    0.jar
    ClassPath[37] = file:/C:/report-designer/launcher/../lib/jface-3.2.2.jar
    ClassPath[38] = file:/C:/report-designer/launcher/../lib/jfreechart-1.0.4.jar
    ClassPath[39] = file:/C:/report-designer/launcher/../lib/jmi.jar
    ClassPath[40] = file:/C:/report-designer/launcher/../lib/jmiutils.jar
    ClassPath[41] = file:/C:/report-designer/launcher/../lib/jta.jar
    ClassPath[42] = file:/C:/report-designer/launcher/../lib/jug-lgpl-2.0.0.jar
    ClassPath[43] = file:/C:/report-designer/launcher/../lib/kettle-core.jar
    ClassPath[44] = file:/C:/report-designer/launcher/../lib/kettle-engine.jar
    ClassPath[45] = file:/C:/report-designer/launcher/../lib/libfonts-0.3.4.1.jar
    ClassPath[46] = file:/C:/report-designer/launcher/../lib/libformula-0.1.18.2.jar
    ClassPath[47] = file:/C:/report-designer/launcher/../lib/libformula-ui-0.1.18.3.
    jar
    ClassPath[48] = file:/C:/report-designer/launcher/../lib/libloader-0.3.7.jar
    ClassPath[49] = file:/C:/report-designer/launcher/../lib/librepository-0.1.6.jar
    ClassPath[50] = file:/C:/report-designer/launcher/../lib/libxml-0.9.11.jar
    ClassPath[51] = file:/C:/report-designer/launcher/../lib/log4j-1.2.14.jar
    ClassPath[52] = file:/C:/report-designer/launcher/../lib/looks.jar
    ClassPath[53] = file:/C:/report-designer/launcher/../lib/mdrapi.jar
    ClassPath[54] = file:/C:/report-designer/launcher/../lib/mdrjdbc142.jar
    ClassPath[55] = file:/C:/report-designer/launcher/../lib/mof.jar
    ClassPath[56] = file:/C:/report-designer/launcher/../lib/mondrian.jar
    ClassPath[57] = file:/C:/report-designer/launcher/../lib/mqleditor-swing-0.1.2.j
    ar
    ClassPath[58] = file:/C:/report-designer/launcher/../lib/nbmdr.jar
    ClassPath[59] = file:/C:/report-designer/launcher/../lib/openide-util.jar
    ClassPath[60] = file:/C:/report-designer/launcher/../lib/org.eclipse.core.comman
    ds_3.2.0.I20060605-1400.jar
    ClassPath[61] = file:/C:/report-designer/launcher/../lib/org.eclipse.core.runtim
    e_3.2.0.v20060603.jar
    ClassPath[62] = file:/C:/report-designer/launcher/../lib/org.eclipse.equinox.com
    mon_3.2.0.v20060603.jar
    ClassPath[63] = file:/C:/report-designer/launcher/../lib/org.eclipse.ui.forms_3.
    2.0.v20060602.jar
    ClassPath[64] = file:/C:/report-designer/launcher/../lib/pentaho-actionsequence-
    dom-1.7.0.22816.jar
    ClassPath[65] = file:/C:/report-designer/launcher/../lib/pentaho-connections-2.1
    .0.jar
    ClassPath[66] = file:/C:/report-designer/launcher/../lib/pentaho-core-1.7.1.jar
    ClassPath[67] = file:/C:/report-designer/launcher/../lib/pentaho-cwm-1.5.4.jar
    ClassPath[68] = file:/C:/report-designer/launcher/../lib/pentaho-data-1.7.1.jar
    ClassPath[69] = file:/C:/report-designer/launcher/../lib/pentaho-i18n-1.7.1.jar
    ClassPath[70] = file:/C:/report-designer/launcher/../lib/pentaho-messages-1.7.1.
    jar
    ClassPath[71] = file:/C:/report-designer/launcher/../lib/pentaho-metadata-2.2.0.
    jar
    ClassPath[72] = file:/C:/report-designer/launcher/../lib/pentaho-mql-editor-2.1.
    1.jar
    ClassPath[73] = file:/C:/report-designer/launcher/../lib/pentaho-plugin-1.7.1.ja
    r
    ClassPath[74] = file:/C:/report-designer/launcher/../lib/pentaho-publisher-1.7.1
    .jar
    ClassPath[75] = file:/C:/report-designer/launcher/../lib/pentaho-report-wizard-1
    .7.1.jar
    ClassPath[76] = file:/C:/report-designer/launcher/../lib/pentaho-report-wizard-c
    ore.jar
    ClassPath[77] = file:/C:/report-designer/launcher/../lib/pentaho-reporting-engin
    e-classic-0.8.9.11.jar
    ClassPath[78] = file:/C:/report-designer/launcher/../lib/pentaho-reporting-engin
    e-classic-ext-0.8.9.11.jar
    ClassPath[79] = file:/C:/report-designer/launcher/../lib/pentaho-repository-1.7.
    1.jar
    ClassPath[80] = file:/C:/report-designer/launcher/../lib/pentaho-security-1.7.1.
    jar
    ClassPath[81] = file:/C:/report-designer/launcher/../lib/pentaho-test-1.7.1.jar
    ClassPath[82] = file:/C:/report-designer/launcher/../lib/pentaho-ui-1.7.1.jar
    ClassPath[83] = file:/C:/report-designer/launcher/../lib/pentaho-util-1.7.1.jar
    ClassPath[84] = file:/C:/report-designer/launcher/../lib/pentaho-versionchecker.
    jar
    ClassPath[85] = file:/C:/report-designer/launcher/../lib/pentaho-vfs.jar
    ClassPath[86] = file:/C:/report-designer/launcher/../lib/pixie-0.8.10.jar
    ClassPath[87] = file:/C:/report-designer/launcher/../lib/poi-3.0.1-jdk122-final-
    20071014.jar
    ClassPath[88] = file:/C:/report-designer/launcher/../lib/PullParser-standard-2.1
    .10.jar
    ClassPath[89] = file:/C:/report-designer/launcher/../lib/retroweaver-rt-1.2.4.ja
    r
    ClassPath[90] = file:/C:/report-designer/launcher/../lib/rhino-1.6r7.jar
    ClassPath[91] = file:/C:/report-designer/launcher/../lib/saxon8-dom.jar
    ClassPath[92] = file:/C:/report-designer/launcher/../lib/saxon8-jdom.jar
    ClassPath[93] = file:/C:/report-designer/launcher/../lib/saxon8-sql.jar
    ClassPath[94] = file:/C:/report-designer/launcher/../lib/saxon8-xom.jar
    ClassPath[95] = file:/C:/report-designer/launcher/../lib/saxon8-xpath.jar
    ClassPath[96] = file:/C:/report-designer/launcher/../lib/saxon8.jar
    ClassPath[97] = file:/C:/report-designer/launcher/../lib/servlet-api.jar
    ClassPath[98] = file:/C:/report-designer/launcher/../lib/simple-jndi-0.11.1.jar
    ClassPath[99] = file:/C:/report-designer/launcher/../lib/sqleonardo-swt-wrapper.
    jar
    ClassPath[100] = file:/C:/report-designer/launcher/../lib/sqleonardo.jar
    ClassPath[101] = file:/C:/report-designer/launcher/../lib/svgSalamander.jar
    ClassPath[102] = file:/C:/report-designer/launcher/../lib/xercesImpl.jar
    ClassPath[103] = file:/C:/report-designer/launcher/../lib/xml-apis.jar
    ClassPath[104] = file:/C:/report-designer/launcher/../lib/swt-swing/
    ClassPath[105] = file:/C:/report-designer/launcher/../lib/swt-swing/SWTSwing.jar
    ClassPath[106] = file:/C:/report-designer/launcher/../lib/jdbc/
    ClassPath[107] = file:/C:/report-designer/launcher/../lib/jdbc/asjava.zip
    ClassPath[108] = file:/C:/report-designer/launcher/../lib/jdbc/db2jcc.jar
    ClassPath[109] = file:/C:/report-designer/launcher/../lib/jdbc/db2jcc_license_cu
    .jar
    ClassPath[110] = file:/C:/report-designer/launcher/../lib/jdbc/derbyclient.jar
    ClassPath[111] = file:/C:/report-designer/launcher/../lib/jdbc/h2.jar
    ClassPath[112] = file:/C:/report-designer/launcher/../lib/jdbc/hsqldb.jar
    ClassPath[113] = file:/C:/report-designer/launcher/../lib/jdbc/ifxjdbc.jar
    ClassPath[114] = file:/C:/report-designer/launcher/../lib/jdbc/iijdbc.jar
    ClassPath[115] = file:/C:/report-designer/launcher/../lib/jdbc/interclient.jar
    ClassPath[116] = file:/C:/report-designer/launcher/../lib/jdbc/jaybird-full-2.1.
    0.jar
    ClassPath[117] = file:/C:/report-designer/launcher/../lib/jdbc/jconn2.jar
    ClassPath[118] = file:/C:/report-designer/launcher/../lib/jdbc/jtds-1.2.jar
    ClassPath[119] = file:/C:/report-designer/launcher/../lib/jdbc/mysql-connector-j
    ava-5.0.5-bin.jar
    ClassPath[120] = file:/C:/report-designer/launcher/../lib/jdbc/ojdbc14.jar
    ClassPath[121] = file:/C:/report-designer/launcher/../lib/jdbc/orai18n.jar
    ClassPath[122] = file:/C:/report-designer/launcher/../lib/jdbc/postgresql-8.1dev
    -403.jdbc3.jar
    ClassPath[123] = file:/C:/report-designer/launcher/../lib/jdbc/rdbthin.jar
    ClassPath[124] = file:/C:/report-designer/launcher/../lib/jdbc/sapdbc.jar
    ClassPath[125] = file:/C:/report-designer/launcher/../lib/jdbc/SQLBaseJDBC.jar
    ClassPath[126] = file:/C:/report-designer/launcher/../lib/jdbc/sqlitejdbc-v032-n
    ested.jar
    ClassPath[127] = file:/C:/report-designer/launcher/../lib/jdbc/unijdbc.jar
    ClassPath[128] = file:/C:/report-designer/launcher/../lib/jdbc/xdbjdbc.jar
    java.lang.ClassNotFoundException: org.pentaho.reportdesigner.crm.report.ReportDi
    alog
    at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:164)
    at org.eclipse.swt.internal.swing.UIThreadUtils$3.run(UIThreadUtils.java
    :114)
    at org.eclipse.swt.internal.swing.UIThreadUtils$4.run(UIThreadUtils.java
    :132)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
    read.java:242)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
    ad.java:163)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
    C:\report-designer>pause
    Presione una tecla para continuar . . .

    ----------------

    y hasta ahi llega... no carga el report designer... si quieres intentarlo en tu propia maquina... yo baje el Pentaho Report Designer 3 en la siguiente direccion: http://sourceforge.net/projects/pentaho/files/ en el arbol de Report Designer, escoge 3.0.0-RC2 luego el archivo prd-ce-src-3.0.0.37222.RC2.zip

    Gracia por tu ayuda.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.