munga

I found the issue, these properties are set in the jasperserver. net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader net.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooter net.sf.jasperreports.export.xls.exclude.origin.band.3=columnHeader net.sf.jasperreports.export.xls.exclude.origin.band.4=columnFooter Commenting them out solved the problem, not sure why these are set as default. munga.

Hi, I have a report with a simply static text in the page header, when exporting to pdf the page header shows up on all pages. I have the one page per sheet property set for excel exports; <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="true"/> but the page header is only showing up on the first page. Is there another property to set in order for it to show up on every page? I have also noticed that the page footer never shows up on the excel export. Thanks munga

mgeise, You are right about it could affect more than just passwords. It would be hard to ask for a feature request as it would be hard to define. On some systems the admins may allow users to create their own reports. munga.

Hi nikalopolis, I've already tried that combination and I was unable to run the report as the only parameter checkbox was un checked and greyed out. When I click the apply button all I got was an error that informed me that I must select a parameter. munga.

mgeise, It is a lot easier to do a mysqldump/mysql import than deploying a report and subreports from ireport then re-creating any additional inputcontrols, links to JRXML files, datasources etc. It also ensures I haven't made a mistake and requires no addtional testing. munga

Hi All, I have jasperserver running on my local computer (local) so I can experiment and create reports, once I've got a report working I do a mysqldump of jasperserver on local machine and import it to a machine (remote) that other people have access to. This works fine until people want to change their password on the remote machine and then I do an import from local machine which has a different password. What is the best way to preserve the passwords and possible new users that are added? Would exporting JIUser & JIUserRole first and then importing it back once the local import has happened? Thanks munga

Hi Vivekanand, I haven't used SQL server only MySQL but I assume the image is converted to the same java Object. logo is the SQL field. i.e select logo from company; Hope it helps. Munga Code:<imageExpression class="java.io.InputStream"><![CDATA[((java.sql.Blob)$F{logo}).getBinaryStream()]]></imageExpression>

Fails against version 4.5.0 mysql was 5.1 java version "1.6.0_23" OpenJDK Runtime Environment (IcedTea6 1.11pre) (6b23~pre11-0ubuntu1.11.10) OpenJDK 64-Bit Server VM (build 20.0-b11, mixed mode) Bug was reproduced on both Linux and Windows Vista Bussiness. I have added a more user friendly test report which can now be run from ireport.

Is jasperreports suppose to be backward compatible, I have a report that works fine with 4.0.1 library but fails with a Class cast exception when using 4.5 library. (java) java.lang.ClassCastException: java.lang.Double cannot be cast to java.lang.Boolean(java) at net.sf.jasperreports.engine.fill.JRFillElementContainer.buildConsolidatedStyle(JRFillElementContainer.java:768)(java) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluateConditionalStyle(JRFillElementContainer.java:730)(java) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluateConditionalStyles(JRFillElementContainer.java:18)(java) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:472)(java) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2021)(java) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:755)(java) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:265)(java) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)(java) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:836)(java) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:746)(java) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:640)(java) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)(java) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205)(java) at java.lang.Thread.run(Thread.java:722)(java)(java) java.lang.Double cannot be cast to java.lang.Boolean(java) java.lang.ClassCastException: java.lang.Double cannot be cast to java.lang.Boolean(java) at net.sf.jasperreports.engine.fill.JRFillElementContainer.buildConsolidatedStyle(JRFillElementContainer.java:768)(java) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluateConditionalStyle(JRFillElementContainer.java:730)(java) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluateConditionalStyles(JRFillElementContainer.java:718)(java) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:472)(java) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2021)(java) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:755)(java) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:265)9(java) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) (java) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:836) (java) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:746) (java) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:640) (java) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) (java) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205) (java) at java.lang.Thread.run(Thread.java:722) Regards Munga

Below is the permissions settings that I have my jasperserver project. I have a master jrxml file that is referenced by multiple report as a repository jrxml file. The problem is that I receive a premissions error when I only have execute only permissions on the 'Master Report.jrxml' file. I don't want to set it to read only as I don't want users to see it. Is this a bug or does it need to be read only because it is referencing a repository file? root |-->Data Source | |-->my data source <--ROLE_USER execute only, USER1 no access | |-->JRXML Files <--ROLE_USER execute only, USER1 no access | |-->Master Report.jrxml <--permissions inherited | | | |-->sub reports <--permissions inherited | |-->sub_report1.jrxml <--permissions inherited | |-->sub_report2.jrxml <--permissions inherited | |-->company |-->state |-->division |-->section 1 |--> Report from repository file (Master Report.jrxml) <--ROLE_USER no access, USER1 Read only The server has encountered an error. Please excuse the inconvenience. Error Message org.springframework.security.AccessDeniedException: Access is denied Error Trace org.springframework.security.AccessDeniedException: Access is denied at org.springframework.security.vote.AffirmativeBased.decide(AffirmativeBased.java:68) at org.springframework.security.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:262) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:63) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy5.getResource(Unknown Source) Post Edited by munga at 01/18/2012 21:31

I've had partial success, I've found that if you use a single select drop down list and make the input control maditory and read only it stops the user from changing the value but they still have to apply the input controls before the report will run which seems unnessary as it is the only option. Does anyone know how to force to apply with out user input, I thought making the input control invisible would have remove the need for the user to apply the controls but it doesn't. Thanks Munga

I have a report that is to be used multiple times with a different parameter division_id. So I don't have to recreate the report and all its sub-reports, can I specify a value to be used in the input control without the user having to enter the value? The reason I don't want the user to enter a value is each divisional manager should not be able to see the other divisions reports, and as they should only see one report entering a value in should not be necessary. If this can't be done with an input control can it be done another way? Thanks Munga Post Edited by munga at 01/17/2012 00:26

I've just updated my jasperreport jar file to the latest 4.1.2 release and my report was missing a lot of data or the font was changed and made it too big to fit in the container. I re-instated the older 4.0.1 jar re-compiled and every thing is fine again. I have double checked all the required files and version everything is fine there. http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/requirements.html Any ideas? Munga.

Thanks for the fix Lucian. It was very easy to add the fix, all I had to do was add the following line at the report level of the file. <property name="net.sf.jasperreports.style.evaluation.time.enabled" value="true"/> Thanks munga PS I've been trying to reply to this post for about a week now via firefox with no luck, if this works it will be from ie7

Hey itchytoes, are you sure you're looking at the right number? I am trying to get the top number to turn red if it is a negative. The conditional style works if the text field is after the subreport call but not before it. I was using 3.1.4 but I did try using 3.1.3 to see if it changed anything but it didn't for me. I also tried the current 3.5.0 with the same result. Thanks Munga

javator, I don't know how to generate a pdf report in memory and have Acrobat reader display it. You may have to look into the Acrobat Reader api for that. I do have a suggestion for your problem in saving the pdf file, via the JRViewer, taking a long time. I create a new thread to view the report so when saving a file in pdf or xls etc it does not tie up your GUI waiting for an I/O block to return. On another note if you use native calls in java you loose the run anywhere ability of java. hope this helps munga

Hi Javator, Do you simply want to generate and view your report without creating a file? If that is the case its easy to do with the jasperViewer JasperPrint jp = JasperFillManager.fillReport(jr, params, jrtmds); JasperViewer jv = new JasperViewer(jp, false); jv.setVisible(true); from the viewer you can still then save a pdf file or print your report. munga

Here is what I use inside my ant compile target. <taskdef name="jrc" classname="net.sf.jasperreports.ant.JRAntCompileTask"> <classpath refid="classpath"/> </taskdef> <jrc srcdir="${src}" destdir="${build}" includes="com/**/*.jrxml"> <classpath refid="classpath"/> </jrc> hope it helps munga

All of my reports are within a jar file, I load them via getSystemResourceAsStream like this. JasperPrint jp = JasperFillManager.fillReport( ClassLoader.getSystemResourceAsStream("com/foo/blah/reports/myreport.jasper"), params, jrrsds); hope it helps munga

I don't use the jasperserver but I'm sure this will still work, I use java.io.InputStream for the image Class and use; ClassLoader.getSystemResourceAsStream("com/blah/images/icon.gif") in the Image Expression to load the image. So all you have to do is include the image in your classpath, it can even be in a jar file. Hope this helps. munga

I still don't have a solution to this problem. I've included an example to better explain the problem. To run the example first change the classpath in run_test.sh to your lib files then run ./run_test.sh -100 or ./run_test.sh 100

OK here is a small example with a master and sub report. The subreport passes back a value to the master. The master using a conditional style sets the foreground red if the value is negative (at least it should). Notice the return value in the column header is not set red with a negative number, but the return value in the column footer is. To run the example first change the classpath in run_test.sh to your lib files then run ./run_test.sh -100 or ./run_test.sh 100 I hope the example explains it better than I can.

I appreciate your help and I'll put together a small example over the weekend.

rogerjose81 Wrote: Of course, I mean to access the scriptlet from the conditional style. In the scriptlet you will manage the sum as you want. There is no point is accessing the data before eval as the information has not been processed to determine the value, or after eval as It is not going to chagne the way it looks because the conditional sytle or printWhen expression has ready been evaluated. Again if I'm wrong can you give me an example of changing the font colour in a scriptlet.

From what I can tell from iReport a scriptlet can only access data objects i.e fields, variables and parameters; not the view object i.e TextField. If I'm wrong can you give me an example of changing the font colour in a scriptlet.