sebastianr

Hi, I have the below snippet in my report xml. <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false"> <reportElement x="870" y="67" width="189" height="20" forecolor="#00AAAA" key="textField" /> <textElement textAlignment="Right" /> <textFieldExpression class="java.lang.String"> <![CDATA["Page " + String.valueOf($V{PAGE_NUMBER})]]> </textFieldExpression> </textField> I am getting this exception. 1. Syntax error on token "{", delete this token value = (java.lang.String)("Page " + String.valueOf($V{));//$JR_EXPR_ID=21$ ^ since i am using velocity, i modified the above snippet like below then it is working fine. <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false"> <reportElement x="870" y="67" width="189" height="20" forecolor="#00AAAA" key="textField" /> <textElement textAlignment="Right" /> #set( $pageno = '$V{PAGE_NUMBER}' ) <textFieldExpression class="java.lang.String"> <![CDATA["Page " + String.valueOf($pageno)]]> </textFieldExpression> </textField> is this anything related jasper or velocity that i am using? What i have done is, i have prepared a .jrxml and i renamed it as .vm for velocity use. is this causing problem?

Hi Lucian, I am getting below exception when i tried this. (Jasper design is not allowing to add reportElement in summary section) <parameter name="returnMap" isForPrompting="false"/> <summary> <staticText> <reportElement> <printWhenExpression>$P{returnMap}.put("var", $V{REPORT_COUNT}) == null ? Boolean.FALSE : Boolean.FALSE</printWhenExpression> </reportElement> </staticText> </summary> Exception: Caused by: java.lang.NoSuchMethodException: No such accessible method: addElement() on object: net.sf.jasperreports.engine.design.JasperDesign at org.apache.commons.digester.Digester.createSAXException(Digester.java:3181) at org.apache.commons.digester.Digester.createSAXException(Digester.java:3207) at org.apache.commons.digester.Digester.endElement(Digester.java:1225) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.endNamespaceScope(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)

Thanks Lucian. I have one more query for you which is related to perfomance. In my application, i'm using Apache's Velocity with Jasper to generate the template dynamically. And i'm passing the generated pdf data as byte stream to browser directly to write. In this case, what will be the performance when the concurrent users increase or report data volume is high or both. I'm really worrying about the performance since the template generation, compilation, report generation and writing report to browser window are online process(Once user is made the report request). Can you suggest me anything can be done to gain the good performance? Some times i am getting "OutOfMemoryException" when the report volume is so high (it cannot write the data in memory). To avoid such situation, i would like to have a pre-defined report bandwidth and will not allow the user to generate the report if the volume exceeds the bandwidth defined. Is this acceptable? My users are ok with that. Kindly share your expertise with me and suggest me the optimal way of approaching this problem. Thanks. :evil:

Hi, I am in need to getting total no of rows generated in jrxml from java program where my jasper execution is. But i dont want to execute a report query from java instead the query is there in the jrxml. I need to get a count of records from the query executed in jrxml template. Is there any way of achieving this?

Folks, I am new to jaspoer reports and i have a doubt whether the Jasper reports suports this feature. I would like to generate a report with dynamic queries to be generated while runtime. For eg. select field1,field2,...fieldn from tablename where col1=val1, col2=val2...coln=valn where, field1, field2..fieldn col1, col2.. coln val1, val2,..valn are to be fetched at runtime instead of having static query in the template. I dont think it is possible. I required another way to do it. i want to generate a query like above based on my input data and pass the generated query to jasper report template, compile and generate reports. is this possible to pass a query to template. would be great if any one can help me out. Thanks.

Hi, I have such a requirement like, I need to read through a file which contains various no. of columns and i need take a column and validate it. Based on my validation the data should go into different tables. Is there any tool available to do such a validation?

Hi buddies, I cannot explore the usage of ouput filter conditions specified in tMap component. Why is that for actually and how to user that? In java, If i have REQ_ID schema then i give condition like below. row1.REQ_ID == 23344 and i have one output rejection specification. does above mean that, the REQ_ID = 23344 alone will be written into actual output and others will be in rejection output? I really confused about the tMap output filters since no detailed explanation i found the documentations. kindly give me explanations if anybody knows.

Hi, I faced a proble while coverting CSV/XML/DIF from XML in JasperETLv2.1.1. But there were no issues with v2.0.0. I am not getting any exception. But the generated output file is empty. I kept the default property for tXMLFileInput component. LoopXpathQuery = "/bills/bill/line" and so on. Is any one facing problem like this? Post edited by: sebastianr, at: 2007/10/15 04:30

Hi, I am able to generate XML file from data which is retrieved from MySQL DB. But in properties of tXMLFileOutput component, if i donot add root tag mannually, the XML has been generated without root tag and it fails the wellformedness test. It should add the root tag by default eventhough the user doesnot provide any root tag mannually. Above problem is encountered in JasperETL v 2.1.1. But this is not happening in v2.0.0. Am i correct or not? Post edited by: sebastianr@hcl.in, at: 2007/10/15 03:49

Hi, I created a java routine, but i donno how to add the routines with the existing components available in jasperETL v.2.1.1. can any one help me on this? Post edited by: sebastianr@hcl.in, at: 2007/10/15 03:50