Jump to content
Changes to the Jaspersoft community edition download ×

ghudson_1

Members
  • Posts

    284
  • Joined

  • Last visited

  • Days Won

    3

Community Answers

  1. ghudson_1's post in Where is API generated reports stored was marked as the answer   
    When using reportExecutions the report stays in memory on the server, similar to the filled JRPrint object that gets filled before being flushed out during an export in JRS UI use-cases, for example from the UI ReportViewer to PDF. The JRPrints stay in memory entirely unless they are so huge page-wise that virtualization kicks in (and you can search wiki/community for details on virtualization if needed).
     
    It stays for the duration of the user-session which made the reportExecutions call. (see web.xml for session timeout)
     
     
     
  2. ghudson_1's post in embed fonts was marked as the answer   
    Via Font Extensions you can add entire font Family for use.  Font Extensions are discussed in the Studio Guide.   This will make the entire set available for use in the report.   iText API is called when the PDF is actually created.  Do you see something in iText regarding your issue with how the font is actually being embedded?   Can you provide more info?
  3. ghudson_1's post in Input Control Possible with mongo query was marked as the answer   
    Yes, mongo queries in reports can be parameterized (and set via input controls, etc) , for example:
    http://community.jaspersoft.com/wiki/how-query-mongo-isodate-data-parameter
    You second question seems to be missing a word or two, so it isn't clear what you are asking, but REST webservices can be used to read and set input control values for a report execution.
  4. ghudson_1's post in How I can get list of parameters form report with Jasper Server rest api? was marked as the answer   
    The v2/reports service includes methods for reading and setting input controls.   Is that what you need?  Syntax from the webservices doc:
    http://<host>:<port>/jasperserver[-pro]/rest_v2/reports/path/to/report/inputControls/
  5. ghudson_1's post in Exclude table component columnFooter and tableFooter on export was marked as the answer   
    Table column footer cells actually end up rendering as a page footer band in a subreport generated for the table. Therefore if you want to exclude the column footer cells you'll need to define a property for pageFooter.
     
    <property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.1" value="pageFooter"/>
     
    A defect or feature request for improvement in the product for this issue has already been filed against JR Library 6.2.x
  6. ghudson_1's post in No query executer factory registered for the 'plsql' language was marked as the answer   
    Hi, searching the community for "net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language", then filtering by 'wiki' shows a few helpful results, like:
    http://community.jaspersoft.com/wiki/config-stored-procedures-jasperreports-server-55
    So essentially you need to add a jar and a value to your .properties
  7. ghudson_1's post in FONTS???? was marked as the answer   
    Hi,
    You need to use the JR Library feature referred to as font extensions.    This is described here and iReport and Studio both have some helper wizards to create the jar for you:
    http://jasperreports.sourceforge.net/sample.reference/fonts/index.html#fontextensions
    It's detailed in the JasperReports Ultimate Guide, and our salesengineer provides some illustrated background on the topic here in his blog here:
    http://mdahlman.wordpress.com/tag/font-extensions/ 
    In Studio choose Window -> Preferences -> Jaspersoft Studio -> Fonts, click Add to add your ttf, eventually choose "Export" to create the font extension jar (it's just a bundle of the files as described above).    Add the jar to your runtime classpath (like the WEB-INFlib dir of your appserver)
  8. ghudson_1's post in Implode/join collection parameter was marked as the answer   
    $X syntax for params is described here:
    http://community.jaspersoft.com/documentation/jasperreports-server-administration-guide-beta/query-based-input-controls
    But that's more appropriate for creating an IN clause in a SQL query.  You need to cast your collection into string that retains the delimited values?  parameters can be based upon values of other parameters.  Sounds like you need to investigate a java method like this org.springframework.util.StringUtils.collectionToDelimitedString($P{mycollection},",")    <-- that could be the expression of the parameter which you pass to the storedproc
     
     
     
     
  9. ghudson_1's post in java.sql.SQLTransientConnectionException: java.net.ConnectException: Connection refused: connect ,how to avoid this was marked as the answer   
    Treat this error message as if it was occurring within any java-based program or application.  Googling the error message returns a few nice article which explain that the port your socket is connecting to seems not to be listening.  Here are some descriptions and explanations:
    http://javarevisited.blogspot.com/2013/02/java-net-ConnectException-Connection-refused.html
  10. ghudson_1's post in HTMl5 Charts: useHTML Tooltip leads to PDF Export Error (AWS Edition) was marked as the answer   
    This defect is resolved in 5.5
×
×
  • Create New...