Jump to content
We've recently updated our Privacy Statement, available here ×

mlopez_1

Members
 View Profile  See their activity

  • Posts

    372

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by mlopez_1

  1. mlopez_1
    You must return the list to main report for using from subreport. Search in doc, there are guides that will helo you. Mariano
  2. mlopez_1
    With Jaspersoft Studio you can use java.util.List parameters with multiselect .... input controls and works very weel. Mariano
  3. mlopez_1
    You must look at: org.postgresql.util.PSQLException: ERROR: function public.dblink(unknown, unknown) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. This your problem. Mariano
  4. mlopez_1
    For disabling login permanently is a Tomcat issue. You must have to configure jasperserver context, inside tomcat, for avoid login removing permissions for its resources. Is posible that jasperserver use spring system authority, in this case you must to remove or configure this framework inside the context. Mariano
  5. mlopez_1
    Reply to myself. After deep searching about solutions i found a easy way to make it. First create normal Report Unit, select Dataset and Query Dialog, Query tab -> Languaje -> plsql. Now put the sentence for make stored procedure execute. In my case: {call DESCARGA_CANAL_CMF( $P{IC_GEN_FECHA_INICIO}, $P{IC_GEN_FECHA_FIN} )} It's not necessary that stored procedure return values. If no value is returned, which is my case, add No data band and select for the Report Unit When no data type -> No Data Section. Then insert a table component in No Data band and make configure for your needs. Have son limitations but is a solution. I hope this helps. Regards, Mariano
  6. mlopez_1
    Hi all, I like to execute a stored procedure to fill a table that is used in the same Report Unit, that is, before Report Unit execute its query , execute the stored procedure. I have a scriptle that execute the stored procedure right, but putting it in somewhere inside the report unit, always execute after its query. Thanks, Mariano
  7. mlopez_1
    Using community version you don't need any license
  8. mlopez_1
    Also, you can set Report's property Ignore pagination, only for that Report Unit. Regads, Mariano
  9. mlopez_1
    Parameter must be java.util.List and input control multiselect ... Then you can initialize parameter with Arrays.asList("0", "1") Regards
  10. mlopez_1
    Take a look at: https://www.jaspersoft.com/olp/installing-jasperreports-server-windows Regards
  11. mlopez_1
    Reply to myself, all variables are evaluated in every record of the query. An approach could be putting the queries directly in text fields in group band, then only are evaluated at group. This works for me. Regards, Mariano
  12. mlopez_1
    The exact error is: net.sf.jasperreports.engine.JRException: Byte data not found at: JasperReportsServerPro-1/templates/aon_empower_logo.png. a You don't reference well this resource. Mariano
  13. mlopez_1
    I have definded one variable which uses a scriptlet for make a sql query for a select count(*) value. This query is heavy and i like to execute only when this group need it, but Jasper Server execute it on every record. I tried all the combinations with Increment type, Reset type (for variable properties) and Evaluation Time (for Text Filed properties) and always run the query for every record. Is there any way to make run the query only when the group needs ? Using JasperServer 6.4.0 Regars, Mariano
  14. mlopez_1
    I think the best you can do is to make an export from inside jasperserver web application. This backup is arch independent and restore is very easy, just import from the same place. Regards, Mariano
  15. mlopez_1
    You only have to add jdbc driver using webapp and configure a Data Source to use with Report Units. This is equal than each type of database. Regards
  16. mlopez_1
    You can use: Conditional ? action if true : action if false Mariano
  17. mlopez_1
    I understood you badly. This happens to me with other class i use in preview. It's seems to be a bug. Sorry. Mariano
  18. mlopez_1
    what type is $F{Week 1} ?
  19. mlopez_1
    As Hozawa said Input Controls are associated with parameters , and be sure to be exactly equals ID in input control and parameter. Mariano
  20. mlopez_1
    Try to define your own variable and set initial value to 1, increment type to Page and Reset type to report. I'm not sure this works but could be. Mariano
  21. mlopez_1
    You have to add ifxjdbc.jar file using jasperserv webapp for the context can find it. Mariano
  22. mlopez_1
    jakehngo, post an answer better. Not Exp.Class but .getDob() method is the one who has to return Date value. Mariano
  23. mlopez_1
    Maybe trying with band's layouts to Horizontal or grid could work.
  24. mlopez_1
    Try to put Appearance -> Position Type -> Float for the image. If not, insert a frame and put both inside. Mariano
  25. mlopez_1
    Make sure $F{person}.getDob() returns java.util.Date object. Mariano
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore