ashishjasper

Hi All, I was trying for achieved the feature of Ajax in Jasper,but i am not able to acheive this. Actually i tried to implement ajax for input control,so that when i typed the character, it will suggest the values present in the database. Just like google. Any help will be thankful. Thanks Ashish

Thanks, For the solution.

Hi All, From last 2-3 days i m trying to acheive to pass where_clause as parameter in ireport , but i m not getting success.These are the following steps i followed---- Step 1: Create the parameter "where_clause". Step 2: keep this parameter at last of list of parameters(two more parameter i used "COMPANY_NAME" and "COMPANY_STATUS") i.e it's having sequence, COMPANY_NAME(Default value:SolutionPr) COMPANY_STATUS(Default value: Good) where_clause Step 3: wrote the below expression for where clause parameter: 'Where companies.copm_name LIKE ' + $P{COMPANY_NAME} +' AND companies.comp_status LIKE ' + $P{COMPANY_STATUS} Step 4:Wrote the report query like : "Select * from companies where $P!{where_clause}" It showing the below exception -------------------------------------------------------------------------------------------------------------------- Error filling print... Error executing SQL statement for : dynamic_where Setting up the file resolver... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : dynamic_where at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:169) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:684) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:877) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Where companies.copm_name LIKE SolutionPr AND companies.comp_status LIKE Good' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:163) ... 11 more Please any body can help me... to resolve this issue: Thanks in Advance Ashish

Hi All, I got the solution , these are the steps for that... Step 1: Create jrxml , with parameter "LoggedInUser" and Parameter Class should be "com.jaspersoft.jasperserver.api.metadata.user.domain.User" Step 2: Drag and drop this parameter over the report detail section or any section , then right click on that and choose "Edit Expression" Step 3: Then pase the below expression "(Object)$P{LoggedInUser}.getTenantId()" Step 4: Compile this jrxml . Step 5: And use it inside the Jasper Server , it will be current organization id .

Hi All, Can any body help me to create the jrxml report that , can take the Organization id from Jasperserver ,when it run in the enviroment of JasperServer -4.1 Thanks in Advance Ashish

Hi All, I am trying to create resuable query in jasperserver repository which can be used for more then one report, which uses similar query with different input control. Thanks in Advance Ashsih

Hi All, From past week ,I am trying to implement the autocomplete(Start typing and get suggestions based on current data in that column in DB.) feature for standard text fields input control in Jasperserver-professional version 4.1, Please provide me a way to implement this feature in Jasperserver-pro ASAP. Thanks in advance, Ashish. Post Edited by ashishjasper at 10/12/2011 05:41

Hi All, From past week ,I am trying to implement the autocomplete(Start typing and get suggestions based on current data in that column in DB.) feature for standard text fields input control in Jasperserver-professional version 4.1, Please provide me a way to implement this feature in Jasperserver-pro ASAP. Thanks in advance, Ashish.