Latest Hot Topics

How can I do it -- put the crosstab into the detail band ??? I did it !!!

Wed, 16 May 2012 18:14:10 +0000

Hello everyone!!

I have to put the crosstab into the detail band.

How can I do?

Please help me, thank you!!
Thank you for your advanced help!!

Sue Yueh Chung (yuehchung.su@gmail.com)

Post Edited by yuehchung at 04/25/2012 10:08

Pass value from SubReport to Main Report and again back to another Sub Report using Shared Variable

Wed, 16 May 2012 18:14:10 +0000

I am designing my report using iReport4.5. I am new to Jasper Reports...

1. My main report displays the detailed transaction

2. First Sub Report say "SUMMARY_RPT" displays the summary by category

3. Second Sub Report say "PARAMETER_RPT" displays the input parameter's used

Here is the requirement.

In my second sub report PARAMETER_RPT I have a field that will give me a title value lets say the Field Name is "MY_TITLE" and the value is "THIS IS MY TITLE" as the output of my query.

How do I pass this MY_TITLE from the second sub report to the main report and would like to display the value in my first sub report SUMMARY_RPT

Or is there a way that I can pass the MY_TITLE directly from my Second Sub report to my First Sub Report using Shared Variable...

if so could you please give me a step by step instruction with what and how to do.. Please help...

Thanks

Meeza

Hyperlink Type "ReportExecution" with date is in error

Wed, 16 May 2012 18:14:10 +0000

Please, i need help!

I have an ireport that does drill down from one to another report, and all work well.

I am using Hyperlink Type "ReportExecution" and two link parameters:
_report = "/reports/samples/report3"
param1 = $F{CODVEND}

But when i add parameters of type date, like:
Date1 = $P{Date1}
Date2 = $P{Date2}

The following error is displayed by the Jasperserver:

The server has encountered an error. Please excuse the inconvenience.

Error Message

java.lang.NullPointerException

Error Trace

java.lang.NullPointerException at com.jaspersoft.jasperserver.war.action.ResourceTypeMappingAction.doPreExecute(ResourceTypeMappingAction.java:53) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:186) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Flow.start(Flow.java:535) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:364) at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:234) at org.springframework.webflow.engine.SubflowState.doEnter(SubflowState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:560) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:163) at sun.reflect.GeneratedMethodAccessor305.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy19.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:81) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619)

I don´t know what i have to do to solve it!

I use the CE.

Thanks for any help

Calculate sum on every page footer from rows on that page - row_count problem.

Wed, 16 May 2012 18:14:10 +0000

Hello.

This is my first post here. My native language is not English, so sorry for any language errors.

I have to generate a report, which has a sum of values in rows on each page.

I've added variable with reset type set to ResetTypeEnum.PAGE.

I've added textfield into columnFooter band with text field expression like:

It should display calculated sum of fields displayed on page and how many rows is on page.

It works correctly only if I configure textFields is my detail band not to stretchWithOverflow.

When I set my rows to stetch dynamically to display whole texts, it displays correctly but on some pages sum and PAGE_COUNT variable take into account one more row than actually is added on the page.

For example: On page I see 7 rows, but sum is calculated of those 7 and 1 from next page. PAGE_COUNT gives 8. What is worse, on next page row, which already has been added to sum on previous page is also being added :(

Has anyone met with this problem before?

Please note, that I have to be able stretch rows to display given String data. I'm not allowed to trim it.

Print watermark if state = draft

Wed, 16 May 2012 18:14:10 +0000

Hello,

I have created purchase order report where once the PO is confirmed the report can be printed to send to supplier. We also want the report to be printer if the PO is in draft state but to put a watermark on the report to display "DRAFT PO"

I am using the background band but not sure how to get this in the expression.

The Background band as an Image, the table for PO has a STATE column with the followingg value (Draft, proforma and confirmed)

Can any explain how I do this, I am using Ireport 4.5.1

Many thanks

Savyn

Show report name in title

Wed, 16 May 2012 18:14:10 +0000

I want to show the report name in the Title.

How or where can I find it, with or without scriptlet?

How to display image in report through HTML Format

Wed, 16 May 2012 18:14:10 +0000

Hi all,

I have an issue with displaying logo in HTML Format. I have generated a report using ireport 3.0.0. I have generate the report in 3 formats-->PDF, EXCEL and HTML. I have placed the logo in the ireport and gave the image expression path.

The image was showing in PDF and EXCEL Format but In HTML the image was not displaying.How to display the image in HTML Format.

If anyone knows the solution .Please reply back.

Regards,

Deepthy

Creating dynamic xls report

Wed, 16 May 2012 18:14:10 +0000

Hi all,
I need create dynamic xls report from a web application using iReport (3.7.3 that I can upgrade).
The rows and the columns to print will be extract from a database table based on the user that
login to the web application.

For example:
User 1
Column A = Bike
Column B = Car
Column C = Total A+B
...

Row 1 = Sunday
Row 2 = Monday
...

User 2
Column A = Beverage
Column B = Food
Column C = SelfService
Column D = Total A+B+C
...

Row 1 = January
Row 2 = February
...

Is it possible create a report with dynamic rows/columns using JRXlsExporter ?
I beleave that I have to create a report with all possible rows/columns and hide the
rows/columns at runtime setting any properties. Is it right ?

I need also a different colors and fonts for a specific column (for example the Total column)
Is this possible ?

Thanks

Rita

Fonts drive me crazy!

Wed, 16 May 2012 18:14:10 +0000

Hi!

I have the following problem: If I design my reports with iReport 4.5.1, and if I test them, and if I save the test as PDF, everything works fine.

If I use the report directly from my Java application over JasperReports, the view is ok, but if I save it as PDF, all formatting (bold and so on) is lost.

I found some hints, that this problem comes from the fonts, because they are not available in the classpath. I found also a hint, that the use of TTF files over the classpath is deprecated. It should be better to install the fonts in iReport, and than create one or more JAR files over the iReport font exporter.

Okay. I installed the fonts, and there where no errors. I can see (and modify) the fonts in the options dialog. I created single JAR files of every font. This also worked fine.

BUT: If I try to select this fonts for a text field under iReport, the font isn't in the list!!!

If I add one of my JARs (from iReport Font exporter) to the iReport classpath, I can choose it under 'Font name'. And if I add the JAR to the classpath of my Java application, also my PDF file is okay.

IS THIS THE SYSTEM WHICH SHOULD I USE???

An other problem is, that some fonts kill iReport (Helvetica, MS Reference Sans Serif...). This means, after adding them to the iReport classpath, I can't open any reports. Everything is empty, only a grey background.

Are there any hints/tips you can give me???

Thanks,
Christian.

Can't create a template based on my xml data

Wed, 16 May 2012 18:14:10 +0000

Hi,

I'm really new to iReport and I'm struggling to get to grips with creating a report that is able to read an XML file from a webserver.

This file is restricted behind a standard HTTP Auth, but in setting up my datasource I was prompted for user credentials and iReport did seem to traverse the fields of it correctly.

I'm following the documentation here: http://jasperforge.org/website/ireportwebsite/IR%20Website/ir_xml_datasources.html?header=project&target=ireport

Only I'm using a Remote XML file datasource rather than the regular XML file datasource.

I've made up the report simply to list out each of the fields in my XML file but when I try and Preview the report it comes back telling me The document has no pages.

How can I debug this and find out how this is working?

Many thanks.