prasad_psl

Hi I want use the ajax drop down list in the jasper server report. if the user enter the one alphabet say 'A' then the drop down list will show all the values started from 'A'. Please any body knows help me. Thanks and Regards, Prasad

Hi, Yes your right... :) . Thanks Prasad

Hi, I am working on jasper server reports. i want to show pdf output when user click the report in jasperserver. By default its taking html output.When user giving input parameters the output will shows in html report which has missing layout as defind in Ireport,but PDF output is good. So i want that if user enters the input values then pdf report will generate not html report. please help me . Thanks Prasad

Hi I attached the snapshots of pie chart which is prepared in the ireport. please suggest which type of pie-chart you want to use. sample and sample2 are two snapshots attached with this reply Thanks Prasad

Hi, SQL Input Control is need the connection with database to fill the prompt. So global input control will not have active connection with the database. So one should use the SQL prompt with the existing report,User should create that locally when the wizzard ask to create input control. I think it will work. Thanks Prasad

Hi I dont know the code which was written by you. From my understanding you want to passs parameter from master report to subreport. But i can tell you in ireport how one can pass the parameter from master report to subreport. step1: create one master report with all the parameters which will require in subreport.(if Parameter name in both the reports same it will be good ) step2:drag the subreport icon from the toolbox it will ask for the connection .Give same connection as the master report has. step3:map the parameters with sub report.(If you didnt create parameters for main report then in the wizzard it will not appear.so plz follow steps) step4: when u run the master report it will prompt the parameter and that parameter value is passed to the subreport. Thanks Prasad

Hi, Thanks for the help.. Because of your reply i find the way how these procedures will be call.I am still exploring the things but you show the direction where to search. Thanks and Regards, Prasad

Hi, Yes it is jasper server. I find the solution.If the SQL prompt is with the report that is it is not a global variable.Its working fine. Because the SQl query will use the same connection as the report does .Prompt should be created locally withe report on which this prompt is being used.. Thanks Prasad

Hi, I am also want to call the stored procedure .. but i dont know where i should create the callable statment for ireport. You mentioned above how to write the callable statment .But where i can write this statement. It will be good if you please explain in the step by step ,that how one can use the stored procedure in ireport.. Thanks Prasad

Hi, I need to create a dynamic prompt which will have the values come from SQL query.User will select any of the value in the prompt.Based on that value Report will execute. I can handle the execution of the report.But i need help on how can i fill the prompt by SQL query. please suggest the way. Thanks and Regards, Prasad

i think you using the chart in detail band. And we know when the detail band is repeated for every instance when it takes value from database .there is one option make our own band like "xyz" it generates two bands "xyzheader " and "xyzfooter".keep the chart in "xyzfooter".it will show good result. Making our own band go to view ->report groups -> click new -> write your band name and click ok... prasad

Check box is there when you use the fields as drag to report to display. So there is a check box "blank when null" you check there it can easily avoid the blank column prasad

Yes that property of "print when expression" i used so far,the only problem i have that was to avoid the space between lines. For example if there are total 8 rows i want to print in detail band in which i kept condition that in middle two rows i.e 4and 5 row should skip.Then no blank space for these two rows should shown. i.e After skiping two lines remaining 6 lines should be shown continues skiping the blank space. Thanks and regards, prasad

Hi The row is being hide but leaving blank space but i want to save space too. i.e when there is no value then hide the row and there should no space between the rows. next value containing row should come in the place of the hide row.. if anyone find that solution please let me know. Thanks and Regards, Prasad

Hi I am working on jasper reports past 15 days. I want some help , when i am using detail band to display the rows it working fine ,but when there is a null value in the fields or i want to ignore the line it will work by writing the logic in "print when expression" ,then it leaves blank space between rows,but i want that space also saved and no blank space is seen. So there is any property to handle such a problem. please anyone know this please replay it to me. my email id is vasamsetti_prasad@persistent.co.in Thanks and regards, Prasad.

i am working on the jasper line chart i need to show the graph in break format i.e when there is no value then it breaks and start again.would you please send your .jrxml file to me so that i can use it. My email id is vasamsetti_prasad@persistent.co.in thank you Prasad

Hi When i am using line chart to show the valuesfrom xml through xpath, there is a problem when i have null value in the varible . it throws a null value exception. the exception is like that Error filling print... null anyone find the way to handle such a problem please suggest me. java.lang.NullPointerException at net.sf.jasperreports.engine.data.JRXmlDataSource.convertStringValue(JRXmlDataSource.java:340) at net.sf.jasperreports.engine.data.JRXmlDataSource.getFieldValue(JRXmlDataSource.java:317) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:813) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:777) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1412) at net.sf.jasperreports.engine.fill.JRHorizontalFiller.fillReport(JRHorizontalFiller.java:119) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:256) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:1049) at java.lang.Thread.run(Unknown Source) Print was not filled. Try using an EmptyDataSource...

Hi When i am using line chart to show the valuesfrom xml through xpath, there is a problem when i have null value in the varible . it throws a null value exception. the exception is like that Error filling print... null anyone find the way to handle such a problem please suggest me. java.lang.NullPointerException at net.sf.jasperreports.engine.data.JRXmlDataSource.convertStringValue(JRXmlDataSource.java:340) at net.sf.jasperreports.engine.data.JRXmlDataSource.getFieldValue(JRXmlDataSource.java:317) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:813) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:777) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1412) at net.sf.jasperreports.engine.fill.JRHorizontalFiller.fillReport(JRHorizontalFiller.java:119) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:256) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:1049) at java.lang.Thread.run(Unknown Source) Print was not filled. Try using an EmptyDataSource...

Hi When i am using line chart to show the valuesfrom xml through xpath, there is a problem when i have null value in the varible . it throws a null value exception. the exception is like that Error filling print... null anyone find the way to handle such a problem please suggest me. java.lang.NullPointerException at net.sf.jasperreports.engine.data.JRXmlDataSource.convertStringValue(JRXmlDataSource.java:340) at net.sf.jasperreports.engine.data.JRXmlDataSource.getFieldValue(JRXmlDataSource.java:317) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:813) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:777) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1412) at net.sf.jasperreports.engine.fill.JRHorizontalFiller.fillReport(JRHorizontalFiller.java:119) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:256) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:1049) at java.lang.Thread.run(Unknown Source) Print was not filled. Try using an EmptyDataSource...

I am currently working on the jasper. I have a problem while dealing with the dynamic rows and columns . As we know the detail band will always repeated when it gets data from the datasource in my case datasource is XML. so because of the repeation the output PDF file got multiple pages. When i decrease the detail band the whole rows come into the single page.But the rest of the data in detail band is going to be affected when i decreased the detail band. if any one got the solution please replay me. my email id is vasamsetti_prasad@persistent.co.in