[Problem with passing a date parameter to drill down report]

I was able to reproduce this on my local environment. I suggest to log a bug in the tracker.

[JasperReports Server Drill Down and Show Hide of subreport example]

Regarding Drill Down: If you look at the sample data that comes with JasperReports Server there are samples e.g. the monthly sales by quarter report (pro) or the Employees report (both CE and Pro).

[JasperReports Server Drill Down and Show Hide of subreport example]

please provide more details on the first item.

[Looking for a Cross tab example - Newbie learning ... or trying to :)]

Have a look at the JasperReports samples that are shipped with iReport, there is also a crosstab sample that is documented here.

[Start date and end date parameters passing??]

can you post the relevant parts of the JRXML (parameter definition and query)?

[JasperSoft LDAP Authentication]

Can you please share your LDAP configuration? There is a pre-configured LDAP setup already that needs to be enabled, it is documented in the Authentication Cookbook (commercial documentation), also there are a few wiki articles in teh community, e.g. here: http://community.jaspersoft.com/wiki/how-install-test-and-integrate-openldap-jasperserver

[Mysql and War File Distribution Installation]

 Can you attach the buildomatic log file (in buildomatic/logs folder)? Have there been any issues during installation?

Also, does the tomcat error log show anything (tomcat/jasperserver/WEB-INF/logs/jasperserver.log) and tomcat/logs/ ?

[iReport textfield value]

 This can be easily achieved.

I assume you have a field $F{newOrders} and a variable $V{totalOrders} (as sum over $F{newOrders})

create a text field where you add as expression ($F{newOrders}*100)/$V{totalOrders}. Configure this text field to

• evaluation time : auto (jasperreports determines when to calculate the field)
• pattern : #,##0.00 

result: the correct value is displayed during report run time. 

 

[cann't start jasperserver page]

Please check the tomcat log files, located in <js-install>/apache-tomcat/logs and <js-install>/apache-tomcat/webapps/jasperserver/WEB-INF/logs

 

if the application failed to start up most likely there will be an indication why it fails.

[An Ant BuildException has occured: The following error occurred while executing this line: java.io.F]

 the js-path should be set in the default_master.properties file in <js-install>/uildomatic and point to the directory where the jasperreports server sources are. this is used in the maven settings in conf_source/templates/maven_settings.xml. 

see also chapter 3.4.1 Configuring the default_master.properties File in the documentation (docs/JasperReports-Server-CP-Source-Build-Guide.pdf) 

 

[How to hide menus based on roles in jasperserver 4.5]

did you replace ROLE_TBD with ROLE_ADMINISTRATOR?

[Jasper Server community 4.0 - Report was not saved to the repository]

"jsexception.report.resource.already.exists.no.overwrite"

 

If it is a scheduled report check in the job configuration that the the overwrite or timestamp option is checked. If none of them is you'll get this error.

[How to hide menus based on roles in jasperserver 4.5]

Madan, have a look at WEB-INF/actionModel-navigation.xml

You could replace

 

<context name="main_view_mutton" test="!banUserRole">

 

with

 

 

 

<context name="main_view_mutton" test="checkAuthenticationRoles" testArgs="ROLE_TBD">

 

 

 

 

where ROLE_TBD is the role of users allowed to access the menu.

 

 

 

 

 

 

[Conditional Formatting]

you can achieve this with conditional styles. Add a new style, and within the style add a new condition.

 

the condition must contain an expression which returns true or false. lets say, you want to have a condition to highlight the line if the field PXlast is greater than 200.

 

you would add the condition

 

$F{PXlast} > 200

 

this expression gets evaluated whenever the detail band is rendered.

 

please note: when you have a report language other than groovy the expression might change.

[Print if...]

it is a static string you set instead of a variable.

[JasperServer resource bundles]

A report resource bundle you can deploy it as report unit resource.

[Don't print the page footer in Excel]

I am not entirely sure when this properties got introduced, they might not be available in JasperReports 1.0.2. You can set this property also within the JRXML file itself as report property.

 

Btw, to exclude the page footer you would need to change the band to pageFooter by adding

net.sf.jasperreports.export.exclude.origin.band.1=pageFooter

[Don't print the page footer in Excel]

please have a look at this post: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=71292

[Removing headers for excel]

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

[Problem with passing parameters]

please attach your parameter definition and the query.

[Problem with Automatically Retrieve Fields]

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

[Download spanish translation for JasperServer]

JasperBabylon provides localized bundles for JasperServer. Just have a look at the project's home at http://jasperforge.org/jasperbabylon/?group_id=95

[Is it possible to put chart in one column]

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.

[Additional Page is displayed]

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.

[Additional Page is displayed]

remove the page break in the summary band of the sub report. also I would recommend to remove the unused bands.