santosh.audi19

Hi Everyone, When I extract the Report output to Power point the Text field borders are not visible( I mean Output is like as we didnt set Borders to text field , but i have put Borders to Textfield ), Is there any Property to be set for dislpaying the Borders. Regards, Santosh

Hi Every one , I have a doubt if we can connect our jasper report to the third Party DB source, for Example we have a Cloud data storage which can be used for free called PARSE(www.parse.com) suppose if my Jasper report wants to fetch/Use the data from the Parse , How it can be done? Parse provides Jar files for Windows/Android/IOS/JavaScript , here Jaspersoft supports Javascript,Java and Groovy. Please help me whether can we achieve it or not. Regards, Santosh

Hi Everyone , There was a Style in the report which has Path like "repo:cappm/Foldername/reportname....." When I was running in the studio , I have made the Path String to "" . After that it showed me error like this Error parsing template XMLnow I have removed "" now report is working.

Hi Every one, When I try to run the Report in the jasper studio. It has popped up with this error Error parsing template XML. Could you help me out in resolving this error net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: Error parsing template XML. at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:506) at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:481) at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:362) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: net.sf.jasperreports.engine.JRRuntimeException: Error parsing template XML. at net.sf.jasperreports.engine.xml.JRXmlTemplateLoader.loadTemplate(JRXmlTemplateLoader.java:219) at net.sf.jasperreports.engine.xml.JRXmlTemplateLoader.load(JRXmlTemplateLoader.java:256) at net.sf.jasperreports.engine.xml.JRXmlTemplateLoader.loadTemplate(JRXmlTemplateLoader.java:115) at net.sf.jasperreports.engine.fill.JRFillReportTemplate.loadTemplate(JRFillReportTemplate.java:110) at net.sf.jasperreports.engine.fill.JRFillReportTemplate.evaluate(JRFillReportTemplate.java:88) at net.sf.jasperreports.engine.fill.JRBaseFiller.collectTemplates(JRBaseFiller.java:689) at net.sf.jasperreports.engine.fill.JRBaseFiller.collectTemplateStyles(JRBaseFiller.java:712) at net.sf.jasperreports.engine.fill.JRBaseFiller.collectStyles(JRBaseFiller.java:660) at net.sf.jasperreports.engine.fill.JRBaseFiller.loadStyles(JRBaseFiller.java:629) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:521) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119) at java.lang.Thread.run(Unknown Source) Caused by: org.xml.sax.SAXParseException; Premature end of file. at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1916) at net.sf.jasperreports.engine.xml.JRXmlTemplateLoader.loadTemplate(JRXmlTemplateLoader.java:207) ... 11 more

Hi Everyone, When I set a department for a parameter which has almost 2 Lakhs records when i run the SQL query. When I run the report in server side it is showing me the Internal Server Error Is the error is telling that it has reached maximim records to diaplay or what Could you please help me out in resolving this Issue. Regards, Santosh.

Hi Everyone, when I'm using Dataset for displaying markers in the Map. Markers not coming in the output , but when i manually add the markers then its working. I have a Table which has 4 columns select name,id,latitude,longitude from maps; Here Maps is the table name. I have tried placing the map component in detail and summary band, but didnt work while using dataset could any help me out in displaying markers on map using with Data set.

Hi Every one , Suppose I have a Query ` Select name from inv_investments ` , Usually when we Drop the Name field into Detail and we run the report in Single Page we might get 20 Investments names Now i want to print One Name of investment in One Page. How can I achieve this. Thanks.

Few of them faced Issues while using Decode. Using Case definitely works, once try using CASE instead of decode. Hope this helps. Thanks.

Report is Working I have added simple Query for that Map report and published it , now its working Thanks.

Hi Everyone , I have Published a simple Tibco Map Jasper report to the Clarity 14.3 version When i try to run the report it is showing the report is empty. I have run the report in Studio side provided with Latitude and Longitude , it worked in studio Do I need to add or do any changes at server side Thanks All, Santosh

Hello Jasperiousity, At the End of your Query write this statement . ` Order by City(Table Column name)`. I have faced this same Problem . My report used to repeat though I was using grouping. Hope this works for you. Thanks, Santosh.

Okay Thanks Hozawa, could you provide me any example where Background band is used in jasper reports.

I have used all bands Except Background Band in jasper report. It has just Advanced Tab and Print when expression , height properties could any help me out in using the Background Band.

Here I am using below expression for a paramter name P1 which fetches data from cal, param_date parameters ( $P{cal}.set($P{param_date}.getYear()+1900, $P{param_date}.getMonth(), $P{param_date}.getDate()) || $P{cal}.add(Calendar.MONTH, -1) ) ? null : $P{cal}.getTime() when i run the report it is showing error at `||` could you please help me out .How do I concatenate parameters? Thanks All.

Hi All , How to apply backgroud colors for the normal report . Many are giving suggestions that how to give background color for HTML5 charts , but I want background color for a Simple chart https://dribbble.com/shots/1423171-Some-Analytics just go through the above link . there the image has Colors for HTML5 chart but I want them to use for normal Jasper report Thanks.

I have created a simple Tibco map report giving Latitude it was woking fine in Studio side when i have published it to Server it is showing Report is empty Could any one please help me out from this problem Thanks All.

We can achieve it through Table Component Concept in Jasper reports.As I Know Table Component behaviour will be same as Table which you are talking about. Each Table Component has seperate Dataset to be created. Hope this helped you Thanks.

I would like to know in detail about the Properties used in Jasper Like : - net.sf.jasperreports.export.xls.font.size.fix.enabled which is used to enable the Font size to remain same as we export to Excel. Thanks All.

When I Export the report to PDF Format the Text which I have set to Bold is not appearing as BOLD in PDF Document. What Property I need to set for this? Thanks All.

In my Japer report when Im using $F{value}.doubleValue() which results 10.0 Now the Requirement is to display 10.00. What should I use to get 10..0 rather than 10.0 | Thanks.

We have Evaluation time for a Text field with options like Now Report Auto Band Page Column Master In What way does this optins bring the differnece to us. Could you please help me in giving some Information regarding these Options. Thanks.

Suppose if the result is 93.5 it should round up to 94

I'm using following method to round of numbers but im still unable to round them completely "Total Quality :"+ new BigDecimal(($V{Total Quality}.doubleValue()/$V{Calc}.doubleValue() )*100).setScale(1, RoundingMode.UP) +"%" If my result is 87.81 % I should make it to 88.0% Could you please help me out in achieving it Thanks,

For Large text( Example: I am the long and Big Text )to be displayed we usually Select "Float:" option and "Stretch with overflow" for a Text Field , when we run the Report the Text will be displayed like this "I am the Long and Big Text" But I want the Text to be displayed in one Line without making the Text Box length bigger , Text should be Dynamically stretched horizontally , so What Properties I have to use to make the Text to be displayed like this I am the long and Big Text Could you please help me out Thanks All.

When I try to Publish the Report to the server It is showing "The Server has returned an error with code 1 and with the message Access is denied" what could be the reasons for this? Thanks.