javi_123

Hi, I'm facing the same issue. Did you manage to get it working? cheers

Hi, Have you managed to resolve this issue, I'm getting the error messages as well if i follow the same approach. Thanks Javed

I'm having the same issue while installing js-7.5 from buildomatic. Didi you manage to resolve it?

They have submitted the case as a defect enhancement, lets see how long will it take to fix this problem. I think i have found another problem unless i'm doing something wrong, actually i upgarded from js 4.2.1 to 4.7 which was successful and then i tried to export the contents of the repository from js 4.7 which failed using the following command: ./js-export.sh --uris --everything --output-zip everything.zip Have you tried to export the repository resources in js 4.7? Error message ==================== Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'this_11_.maxValue' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2012-07-11 12:49:02,097 ERROR BaseExportImportCommand:45 - org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'globalProfilingState' defined in file [/opt/jasperserver/buildomatic/conf_source/iePro/applicationContext-profiling.xml]: Invocation of init method failed; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'globalProfilingState' defined in file [/opt/jasperserver/buildomatic/conf_source/iePro/applicationContext-profiling.xml]: Invocation of init method failed; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query ======================================================================= [/code]

I'm having the same problem, did you find any fix for this issue yet?

Did you guys manage to get the waterfall chart working, i have a requirement for this as well. Regards Jav

Hi All, I need to create a link in a report which points to a specfic folder in repository. In jasperserver 3.7, it was easier to point to a specific repository folder: i.e. http://localhost:8080/jasperserver-pro/flow.html?_flowId=repositoryFlow&folder=/adhoc/topics In jasperserver 4, 'repositoryFlow' has been replaced by 'searchFlow' but i'm struggling to point to a specific folder in repository. I have tried to use the following but still no result: http://localhost:8080/jasperserver-pro/flow.html?_flowId=searchFlow&folderUri=/adhoc/topics&mode=browse Please reply back with the solution. Thanks in advance. jav

Hi All, I need to create a link in a report which points to a specfic folder in repository. In jasperserver 3.7, it was easier to point to a specific repository folder: i.e. http://localhost:8080/jasperserver-pro/flow.html?_flowId=repositoryFlow&folder=/adhoc/topics In jasperserver 4, 'repositoryFlow' has been replaced by 'searchFlow' but i'm struggling to point to a specific folder in repository. I have tried to use the following but still no result: http://localhost:8080/jasperserver-pro/flow.html?_flowId=searchFlow&folderUri=/adhoc/topics&mode=browse Please reply back with the solution. Thanks in advance. jav

Hi All, I'm having problem exporting flash charts in Rtf and Flash formats. All the can see is "Flash Component" displayed in chart section when i export to Rtf. Flash exports does'nt disply anything. Are there any settings which i need to make to get it working?? I'm using jasperreports server 4.1.0 and latest version of flash player. Thanks in advance Jav

I'm not sure whether this is the best way to do it but this is what i have done to display the license page: 1: Add a new role e.g. ROLE_LICENSE . Make sure this role is assigned to all users who need to view the license page. 2: Create two report units, one report unit is for displaying the license agreement information and another report unit to accept the license agreement. I have attached the report units and this will give you a clear idea what i have done. 3: Make following changes in jasperserver-servlet-pro.xml <value>ROLE_LICENSE|redirect:/flow.html?_flowId=viewReportFlow&reportUnit=/public/reports/LicensePage&decorate=no</value> <value>ROLE_ADMINISTRATOR|redirect:/flow.html?_flowId=homeFlow</value> <value>ROLE_USER|redirect:/flow.html?_flowId=homeFlow</value> This will show the license page once a user logs in..... 4: Attached license_accepted.jrxml is calling stored procedure in the report sql. This will remove the ROLE_LICENSE from the user once they have accepted the terms and conditions. Next time when the user log in, the license page wont appear. Thats all i have done, hope this solves your problem. Regards Javi

I don't know whether it will help but here is what I would suggest and may be it will solve your problem. Lets say you have a organization called 'Fred', name you datasource as 'Fred_datasource'. Then in you report query you can do like this... SELECT .... FROM '$P!{LoggedInUserTenantId}'_datasource.tablename; When you login as a user which belongs to a particular organization, it will pass the LoggedInUserTenantId and the data will be filtered based on the LoggedInUserTenantId. This works as i have already tried it when jasperserver wasn't working on a multi tenant environment. Regards Javi

Try it with exclamation mark i.e. $P!{parameter1}

You can only see different views based on the roles. Check the roles assigned to two different.

I think its the same in the Professional edition as well but I'm not sure......Look for viewReportBeans.xml in WEB-INF/flows folder and scroll down to the bottom of the file. Remove the following line: <entry key="swf" value-ref="swfExporterConfiguration"/> Make sure you restart the jasper. Hope it helps

I haven't tried it yet but hope this link might help you guys....... http://www.raj2u.net/jasperserver-quick-how-to.html

Hi All, Resources of a Report Unit should sort by name or label but not my date and time. I have created a dashboard as a report unit in which i have got more than hundred resources in it and possibly it will increase day by day. Everytime i add a resource, it gets added at the bottom by the time it was created. I used a standard naming conventions to remember every resource but sum times i need to edit the existing resources and may need to include a subreport within a resource. The naming conventions dosnt work becuase the resources are sort by date and time. Is it possible to sort the resource folder by name or label instead of date and time?? Please reply back with a solution Regards Javed

Hi, Thanks a lot for the quick reply. Do i need to create a flow.xml file as well? Regards Javi

Hi All, I need to create a feedback form in jasperserver. It should be a simple from where user has to enter name, email address and message. Once the form is filled, the user should receive a message in their email id and i should receive a confirmation in my email id. How can i do it in jasperserver? Please reply back with the solution. Regards Javi

You need to make changes in DefaultJasperViwer.jsp file which is located under jsp directory. Regards Javed

I think you are not using the incorrect URL. Example: create the report units inside public folder and use the following URL in _report parameter: /public/LabelNameOfReportUnit folder. Hope, it will solve ur problem Regards Javed Post Edited by javi_123 at 11/10/2009 15:29 Post Edited by javi_123 at 11/10/2009 15:30

All you jasper guru's out there, could you please reply to this thread with the solution. Regards Javed

Yes these links can be removed.you need to change the code in defaultView.jsp which is located in WEB-INF/jsp/repository. Regards Javi

Rohini, I can't see any difference in the applicationContext.xml file. May be LoggedInUser is not supported in community edition but i am not sure about it. I am using jasperserver repository in iReports. I think its better to log a call to jasperserver through their support portal. I am sure they will respond quickly there becuase they charge for that...... Regards Javed

Send me you applicationContext.xml from CE. I will have a look. Regards Javed

Rohini, I really don't understand why you are not getting the values. I think it is something to do with community edition. I suggest you to enable mysql debugging and check whether the parameter is passing any value or not. Regards Javed