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