shib_best

HI All, 150161 Session Cookie Does Not Contain the "Secure" Attribute How to Enable Secure attribute in AWS Jasper soft 6.3. ALready tried with Web.xml and context.xml changes. Anyones help is highly appriciated

HI All, Getting the below error, is there for few values. Did anyone got the same error, please post the solution if you have. visualize.js?_opt=true:92 Uncaught TypeError: Cannot read property 'removeAttribute' of undefined at fe.Chart.destroy (visualize.js?_opt=true:92) at visualize.js?_opt=true:106 at Function.oe (visualize.js?_opt=true:51) at Object.<anonymous> (visualize.js?_opt=true:106) at Object.<anonymous> (visualize.js?_opt=true:54) at h (visualize.js?_opt=true:54) at Object.add [as done] (visualize.js?_opt=true:54) at Array.<anonymous> (visualize.js?_opt=true:54) at Function.each (visualize.js?_opt=true:54) at Object.<anonymous> (visualize.js?_opt=true:54)

DID you able to solve the problem, I am also gettign the same error for certain cases.

hi All, Is it possible to get the logs related to visualize.js in jasperserver.log for jaspersoft 6.2 AWS? Regards, Shib

how to detect Queued reports in Visualize.js?Ans: 1. Visualize.js internally call the rest service to generate the report output. So the status of the rest service defines the reason of queued status of reports.reasona. report is generated but not able to render in ui( then the rest service would be ready)b. report is not generated as the reporting server taking time(then the rest service status would be queued)c. report is generated but not able to render in ui( then the rest service would be failed ) how to handle Queued reports in Visualize.js ? Ans: 1. Visualize.js internally call the rest service to generate the report output.So handling the rest service can solve the issue But then also alll these are alternative. Is it possible to get the logs related to visualize.js in jasperserver.log ? reagards, Shib

Hi All,When we make a visualize.js call to Jasper Server from UI ,we observe sometimes the response from Jasper Server logs is successful but the UI is not able to render the report and Status of the Service is queued. Again in the next call the report works fine. We tried to find the Solutions to it in Jasper soft Communities, Documentations and websites but we didn’t get any clue to it.We need to know the below answers:1. How to detect Queued reports in Visualize.js ( in Jasper server side)2. How to handle Queued reports in Visualize.js ( in Jasper server side & UI) Is it possible to get the logs related to visualize.js in jasperserver.log ?We are using Jaspersoft AWS Professional 6.2.0 regards, Shibabrata Biswas

How to restrict the filters of left hand panel in Jasper server 6.1 using java or jquery. As I don't want to show the datasource to user.

HI All, We have 2 Jasper Server Instance in 2 machines one new and other one is old, both accessing the same Jasper database schema. We have 3 scheduled jobs. Now when both the Jasper Servers Instances are up any 1 or 2 schedulers are trigering randomly,but if anyone of the Jasper Servers Instances is stopped then all the 3 schedulers are working fine. What is the solution for it,so that both the instance runs and all the schedulers work fine. regards, Shib

How to chunk huge csv report that is exported as csv into like 50 Mb. I have a report which export a csv size of 900 mb ,I need to slipt it in multiple csv files while exporting.

yes I am geting this below error Caused by: java.io.IOException: Repository file resource /REPORTS/User_Reports/IMAGE_COUNTS_Test1_files/IMAGE_COUNTS_pix.jrxml could not be loaded at com.jaspersoft.jasperserver.api.engine.jasperreports.util.repo.RepositoryConnection.getInputStream(RepositoryConnection.java:105) at java.net.URL.openStream(URL.java:1010) at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:344) ... 30 more2014-08-27 06:47:08,462 ERROR errorPage_jsp,http--0.0.0.0-8080-18:274 - JSException:2014-08-27 06:53:21,593 ERROR AsyncJasperPrintAccessor,pool-15-thread-67:299 - Error during report executionnet.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error opening input stream from URL : repo:IMAGE_COUNTS_pix.jrxml at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:149) at net.sf.jasperreports.repo.InputStreamPersistenceService.load(InputStreamPersistenceService.java:48) at net.sf.jasperreports.repo.DefaultRepositoryService.getResource(DefaultRepositoryService.java:187) at net.sf.jasperreports.repo.SerializedObjectPersistenceService.load(SerializedObjectPersistenceService.java:53) at net.sf.jasperreports.repo.SerializedReportPersistenceService.load(SerializedReportPersistenceService.java:46) at net.sf.jasperreports.repo.DefaultRepositoryService.getResource(DefaultRepositoryService.java:187) at net.sf.jasperreports.repo.RepositoryUtil.getResourceFromLocation(RepositoryUtil.java:246) at net.sf.jasperreports.repo.RepositoryUtil.getReport(RepositoryUtil.java:208) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:336) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:369) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:294) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillFrame.evaluate(JRFillFrame.java:149) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:456) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:344) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:280) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:932) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:880) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:836) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1702) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1057) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:991) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:902) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662)Caused by: net.sf.jasperreports.engine.JRException: Error opening input stream from URL : repo:IMAGE_COUNTS_pix.jrxml at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:348) at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:132) ... 29 moreCaused by: java.io.IOException: Repository file resource /REPORTS/User_Reports/IMAGE_COUNTS_Test1_files/IMAGE_COUNTS_pix.jrxml could not be loaded at com.jaspersoft.jasperserver.api.engine.jasperreports.util.repo.RepositoryConnection.getInputStream(RepositoryConnection.java:105) at java.net.URL.openStream(URL.java:1010) at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:344) ... 30 more2014-08-27 06:53:21,598 ERROR errorPage_jsp,http--0.0.0.0-8080-5:274 - JSException:

multiple connection working in ireport but when deployed in jasper server not getting records (gives the no data output) In main report I as using oracle data connection and in supreport I am passing postgre datasource connection as "use a connection": Set the Connection expression in subreport to: com.jaspersoft.ireport.designer.utils.Misc.getConnection("postgre") Now It is working in ireport viewer,but when deployed in jasper server the output shows as blank. can Anyone help.

multiple connection working in ireport but when deployed in jasper server not getting records (gives the no data output) In main report I as using oracle data connection and in supreport I am passing postgre datasource connection as "use a connection": Set the Connection expression in subreport to: com.jaspersoft.ireport.designer.utils.Misc.getConnection("postgre") Now It is working in ireport viewer,but when deployed in jasper server the output shows as blank. can Anyone help.

Hi All, I wanted to add a measure manually in crosstab it is giving error. It is not taking the integer type sum. Error :: "The class of the expression is not compatible with the class of the measure measure1. net.sf.jasperreports.engine.design.JRDesignExpression@146d858" Please help me out if anyone know the solution. regards, Shibabrata Biswas Sr. Software Engineer Code:

regards, Shibabrata Biswas Sr. Software Engineer skype id: shibabrata.biswas

Hi All, I tried to show the data label with condition. Also tried to change the colours of the label on the bars that I am not getting. But not able to see any option for these changes,please help with these options. regards, Shibabrata Biswas Sr. Software Engineer skype id:shibabrata.biswas

regards, Shibabrata Biswas Sr. Software Engineer shibabratabiswas@gmail.com +91-9640438657 Code:I had build lots of reports and I am facing problem is the column name changes then I need to rebuild the reports or if the no of columns increases.I need a solution for it such that if I build a report for any specific topic if the name or the no of columns increase the labels and fields must change with that.I think it is possible somehow, so friends who ever found the solution to it please help me out with these solution.

HI Mihai, To get the Dynamic row height in reports use following step. In reportElement Tag use the property stretchType as RelativeToBandHeight and isPrintWhenDetailOverflows as true Then the jrxml code would be something like these: <band height="12" splitType="Stretch"> <textField pattern="###0.00;(###0.00)" isBlankWhenNull="true"> <reportElement style="style3" stretchType="RelativeToBandHeight" mode="Opaque" x="375" y="0" width="50" height="12" isPrintWhenDetailOverflows="true"/> regards, Shibabrata Biswas Sr. Software Engineer shibabratabiswas@gmail.com +91-9640438657

Hi All, I have created a report,now I need to refresh it in every 10 seconds.But I am not getting any hint to implement it. Can anyone help me out with this.It is very urgent. regards, Shibabrata Biswas Sr. Software Engineer shibabratabiswas@gmail.com +91-9640438657

Hi Friends, Good Afternoon! I am sending the code and the error for the servlet that I got while executing. Please check it and suggest. I want to publish/export the reports through the web application in html/pdf format. Error – HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception net.sf.jasperreports.engine.JRRuntimeException: Unknown hyperlink target 0 net.sf.jasperreports.engine.JRHyperlinkHelper.getLinkTarget(JRHyperlinkHelper.java:273) net.sf.jasperreports.engine.base.JRBaseTextField.normalizeLinkTarget(JRBaseTextField.java:317) net.sf.jasperreports.engine.base.JRBaseTextField.readObject(JRBaseTextField.java:381) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974) java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1846) java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753) java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329) java.io.ObjectInputStream.readObject(ObjectInputStream.java:351) java.util.ArrayList.readObject(ArrayList.java:593) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974) java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1846) java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753) java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329) java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1945) java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1869) java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753) java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329) java.io.ObjectInputStream.readArray(ObjectInputStream.java:1667) java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1323) java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1945) java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1869) java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753) java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329) java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1945) java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1869) java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753) java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329) java.io.ObjectInputStream.readObject(ObjectInputStream.java:351) net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:92) net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:515) net.sf.jasperreports.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:385) JasperReportsBrowserDemoServlet.doGet(JasperReportsBrowserDemoServlet.java:40) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.26 logs. regards, Shibabrata Biswas Sr. Software Engineer +91-9640438657 Code:import java.io.File;import java.io.IOException;import java.io.PrintWriter;import java.io.StringWriter;import java.util.HashMap; import javax.servlet.ServletException;import javax.servlet.ServletOutputStream;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse; import net.sf.jasperreports.engine.JREmptyDataSource;import net.sf.jasperreports.engine.JRException;import net.sf.jasperreports.engine.JasperRunManager; public class JasperReportsBrowserDemoServlet extends HttpServlet{ /****/private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{ServletOutputStream servletOutputStream = response.getOutputStream();File reportFile = new File("C:\\shib\\Knoah_Empolyee.jasper");byte[] bytes = null; try{bytes = JasperRunManager.runReportToPdf(reportFile.getPath(),new HashMap(), new JREmptyDataSource()); response.setContentType("application/pdf");response.setContentLength(bytes.length); servletOutputStream.write(bytes, 0, bytes.length);servletOutputStream.flush();servletOutputStream.close();}catch (JRException e){// display stack trace in the browserStringWriter stringWriter = new StringWriter();PrintWriter printWriter = new PrintWriter(stringWriter);e.printStackTrace(printWriter);response.setContentType("text/plain");response.getOutputStream().print(stringWriter.toString());}}}