javi_123

July 24, 2021

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

cheers

April 10, 2020

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

July 11, 2012

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]

July 9, 2012

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

January 27, 2012

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

Regards

Jav

July 20, 2011

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

July 20, 2011

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

July 8, 2011

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

May 18, 2011

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

September 30, 2010

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

September 23, 2010

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

Posted September 22, 2010 · September 22, 2010

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

September 20, 2010

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:

Make sure you restart the jasper.

Hope it helps

September 16, 2010

I haven't tried it yet but hope this link might help you guys.......

http://www.raj2u.net/jasperserver-quick-how-to.html

December 30, 2009

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

December 2, 2009

Hi,

Thanks a lot for the quick reply.

Do i need to create a flow.xml file as well?

Regards

Javi

December 2, 2009

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

November 11, 2009

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

Regards

Javed

November 10, 2009

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

Hide a user from the user list · August 24, 2009

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

Regards

Javed

August 13, 2009

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

July 24, 2009

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

July 24, 2009

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

Regards

Javed

July 24, 2009

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

July 24, 2009

You need to create report throught iReports and then upload it on the jasperserver.

Inside the report you just need to populate the fields through REPORT QUERY browser in iReports and then upload the same report to jasperserver in Ad hoc Components/topics folder.

You can upload the report to jasperserver through iReports by using the jasperserver plugin in iReports. To enable the plugin, choose Window > JasperServer Repository. Then you need to Add a new server and add the server information. After adding the server information, you will be able to view the Repository contents. Look for Ad hoc Components/topics folder and save the report in that particular folder.

I have also attached an example report and you can save it in the Ad hoc Components/topics folder.

Hope it will help.

Regards

Javed

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by javi_123

Products

Explore