umair
-
Posts
37 -
Joined
-
Last visited
umair's Achievements
-
Thanx Sherman, That helped :D
-
I now want to transfer my Jasper server files to the server. I have copied the same schema and the jasperserver files in the webapps folder. Unfortunately, my password on the server is different from that of my test bed. Jasper server therefore gives me errors on start that it is unable to connect to the DB. I believe this password is embedded in the files of jasperserver for jasperadmin. How do i change that?
-
I appreciate your help :) Works like a charm
-
I changed the configurations as you told. I now have the following configurations: jasperserver-servlet.xml Code:<property name="homePageByRole"> <list> <value>ROLE_ADMINISTRATOR|redirect:/flow.html?_flowId=repoAdminFlow</value> <value>ROLE_USER|redirect:/flow.html?_flowId=listReportsFlow</value> </list> </property> <property name="defaultHomePage"> <value>redirect:/home.html</value> </property> index.html Code:[code]<title></title> <meta http-equiv="refresh" content="0;url=home.html"> <script language="javascript" type="text/javascript"> window.location="flow.html?_flowId=repositoryFlow"; </script> </head> <body> If your browser doesn't automatically go there, you may want to go to <a href="home.html">the destination</a> manually. </body> But i am still getting the redirection to repository. Am i doing something wrong?
-
Hey Matt, No wonder i could not find anything on $X in the official documentation. I used $X and it works fine. I appreciate your help :)
-
Hello! I have been working with this problem for quiet some time now and still haven't reached any solution. I created a multi select(query) options in Jasper Server. This list is suppose to pass the list of cities to the report created by ireport. My query in report parses the parameter as: Code:where cities IN $p{city} In my report, i went through these possible steps to parse the parameter values: 1. Defined parameter 'city' in report as a string. This gave me an error 'java.lang.ClassCastException' at jasper Server. 2. Changed the paramter type to Object. The report now gives me an error: java.sql.SQLException: 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 '_binary'¬Ãsr1org.apache.commons.collections.set.ListOrderedSetüÓžöúÃSL' at line 19 3. So, i created a new variable, str_city. The configuration now is: city: java.lang.Object str_city: java.lang.String str_city has a default value of : $P{city}.toString() Now, the value being passed to the report is, "[city_val1, city_val2]" which obviously gives me an error. The correct output to the SQL query should be: "city_val1", "city_val2" How should i achieve this thing? How are you guys dealing with passing of multiple values?
-
Can the redirection to reports section be achieved?
-
How would you create two Single List/Multiple List Selection menus who are dependent on one other. Like one drop down having values for countries and other drop down having values for cities. City drop down is dependent on Country drop down. How can i do that in Jasper Server??
-
So, i tried again with changing of paramteres and i observed that if a Collection's object e.g: [1,2,3] is being passed to the report, then the following expression Code:where report_id in ($P{p_reportID}) would evaluate to : Code:[code] where report_id in (1,2,3) This would give an error. So, i made two variables, One p_reportID as a java.util.Collections and str_p_reportID as java.lang.String Now, str_p_reportID has a default expression of org.apache.commons.lang.StringUtils.join($P{p_reportID}.toArray(),',') I then use str_p_reportID in the query as: Code:[code]where report_id in $P{str_p_reportID} This was supposed to return ("1","2","3") but it now returns ("1,2,3"). I am kinda stuck ova here... Post edited by: umair, at: 2008/05/07 14:52
-
This join() function is'nt of java.util.Collection. Which Class does it belong to ??? I tried using org.apache.commons.lang.StringUtils.join(java.util.Collections,char) but this one also does'nt give the required results. The required result should be... e.g: Code:'str1','str2' But all these examples...which you also stated, would return, Code:[code]'str1,str2' This returns an empty report. Post edited by: umair, at: 2008/05/07 12:59 Post edited by: umair, at: 2008/05/07 15:04
-
i came accross this error using Jasper 2.1 and Japser 3.0 I wonder if this is a bug??
-
Thanx a lot... It is now customized. How is it possible to redirect the user to reports section instead of the default Repository section?
-
hey DNV, Thanx for the quick reply. I tried what you suggested and i am facing the following exceptions: Code:java.sql.SQLException: 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 '_binary'¬Ãsr1org.apache.commons.collections.set.ListOrderedSetüÓžöúÃSL' at line 20 java.sql.SQLException: 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 '_binary'¬Ãsr1org.apache.commons.collections.set.ListOrderedSetüÓžöúÃSL' at line 20 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
-
Sometimes, when i log in, Jasper Server throws the following error message: org.springframework.webflow.executor.support.FlowExecutorArgumentExtractionException: Unable to extract the flow definition id parameter: make sure the client provides the '_flowId' parameter as input or set the 'defaultFlowId' property; the parameters provided in this request are: map[[empty] rg.springframework.webflow.executor.support.FlowExecutorArgumentExtractionException: Unable to extract the flow definition id parameter: make sure the client provides the '_flowId' parameter as input or set the 'defaultFlowId' property; the parameters provided in this request are: map[[empty]] at org.springframework.webflow.executor.support.RequestParameterFlowExecutorArgumentHandler.extractFlowId(RequestParameterFlowExecutorArgumentHandler.java:81)
-
okey... so while passing these list of values through jasper server, the ireport is giving me classCastException. the receiving parameter has a type String. I know that i need to declare that 'string' parameter as an 'object' in ireport. (for handling of array string) But now, i am kinda stuck... what and how should i go about now ?? 1. How should i use this value as in a query?
