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

mrcaffeine

Members
  • Posts

    112
  • 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 mrcaffeine

  1. please have a look at this post: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=71292
  2. The Print When expression is global and gets applied to the JasperPrint object which is the source for all exporters. Nevertheless there is way to configure hiding bands for output formats by setting report properties. For example to hide the pageHeader only in excel you could set a global report property net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader Please refer the JasperReports Configuration Refernce for further details: http://jasperreports.sourceforge.net/config.reference.html on net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name}. Post Edited by mrcaffeine at 25/02/2010 08:58 AM
  3. please attach your parameter definition and the query.
  4. There is a special syntax for IN and NOT IN in SQL queries. See Lucian's post here: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=70649
  5. JasperBabylon provides localized bundles for JasperServer. Just have a look at the project's home at http://jasperforge.org/jasperbabylon/?group_id=95
  6. It would be helpful to see the JRXML. You usually wouldn't solve this with a multi column report but from the first look of it with a chart and a subreport.
  7. you might want to create a report group for supervisor and put the information in the group header. Groups can be configured to start on a new page.
  8. remove the page break in the summary band of the sub report. also I would recommend to remove the unused bands.
  9. the report query can only execute one sql query, you are sending 2 commands. You might need to use a stored procedure instead. refer the JasperReports documentation for limitations on stored procedures.
  10. you could do that with a tertiary operation as field expression. Create a text field having this as expression: ( field_4 < 80 ? "Has Issues": ( field_4 < 85 ? "Improvement required" : ( field_4 < 90 ? "Meets Expertations" : ( field_4 < 95 ? "Exceeds Expertaions" : "" ) ) ))
  11. you might want to have a look at the file /WEB-INF/decorators/decorator.jsp to understand the impact of the parameter decorate=no.
  12. Not as far as I know. As soon as you save the report a copy of the topic is stored as report resource. this prevents the report from being broken caused by future changes of the topic. The query is directly related to the contained topic - not a copy of the topic's SQL.
  13. have you looked at variables and sub report return parameters?
  14. Could you pls provide more details such as where the images are stored (a database?) and what exception you are getting?
  15. as the issue get closed end of last year i would assume it was released with JasperReports 3.7
  16. For each group a variable <group name>_COUNT is generated which contains the number of rows in the group.
  17. iReport allows to access reports remotely. Click on Window > JasperServer repository to open the panel. Create a new server entry and navigate there to your report. I would recommend this way. Another way would be using the import/export tools to export the report using the --uris parameter. refer the JasperServer administration guide for more details.
  18. You can't hide bands from the exporter using the printWhenExpression. You would need to configure the exporter settings. More help provides the JasperReports Configuration Reference, look for the property net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name}
  19. what exactly are you looking for? iReport is built on the netbeans platform.
  20. 1) yes. You could simply use the title band or a fake group header. You could also set the printWhenExpression for the pageHeader band to ($V{REPORT_COUNT} == 0) 2) I am not entirely sure if I understand what you want to achieve here.
  21. please refer the jasperreports stretch sample which is available in the demo folder. the desired property is a text field property: isStretchWithOverflow="true"
  22. just write a simple expression ("%".equals($P{Company})? "All Companies" : $P{Company}) assuming that your parameter is called Company. Be aware that report elements are case sensitive.
  23. You could set the printWhenExpression for the pageHeader or certain elements in it. If the variable PAGE_COUNT contains 0, you are on the first page, otherwise on other pages. Post Edited by mrcaffeine at 22/02/2010 10:15 PM Post Edited by mrcaffeine at 23/02/2010 08:43 AM
  24. The Parameter and the input control need to have the same name: in this case it seems to be 'client'. I am not entirely sure if you need the locale paremeter as the JRXML has a parameter REPORT_LOCALE which is filled by the environment, such as iReport or JasperServer. the syntax using the ! is only if you are injecting code into the report query. please share the querystring, parameter definition and details about the input control.
  25. Hi Simon the name of the single select query input control must be equal to the parameter name. I assume that the name of the input control is different to test. Be aware that uppercase / lowercase matters.
×
×
  • Create New...