[AWS jaspersoft server created AD hocs and reports not opening]

Have you looked at the log? any error, exceptions?

Please provide more details.

[Jaspersoft Studio - Variable with formula]

Please refer to this post,

http://community.jaspersoft.com/questions/519525/bigdecimal-division

Note: this is for Bigdecimals, if you have intgers you can achieve this using

$F{aFieldName_A}.intValue() / $F{aFieldName_B}.intValue()

 

[Jaspersoft Installation . Can application database and Jaspersoft database be in the physical database server]

You can absolutely deploy database in another machine. This wouldnt cause any problem.

Refer to JasperReports-Server-Install-Guide.pdf (Chapter 5)

or 

https://community.jaspersoft.com/documentation/jasperreports-server-install-guide/v56/installing-war-file-distribution

 

[Data Staging]

you can setup report to use domain topic that are staged.. so when you run your reports, it can use staged data. but you can use staging in jaspersoft studio.

[Period in column name]

What version of JRS are you using? Although I am not too certain about redshift but there was some work done with period in column name on JRS 6.0.

[Remove row when measure cell is blank in crosstab]

Why dont you add filter? right click on the column which could have those values and click on add filter, specify the filtering criteria.

HTH

[Use Data Staging with Jasper Studio Report]

Unfortunately that cannot not be done. Data staging is based off domain topic, which isn't part of jaspersoft studio.

 

[Set up Jasperserver pro with SQL Server]

Please increase the heap size specified for JVM. using -XX:MaxHeapSize.

Refer to:

http://stackoverflow.com/questions/4401396/could-not-reserve-enough-space-for-object-heap 

[Error starting jasperserver]

Could you please provide the complete log. Thanks.

[Passing Multiple Value to Jasper Server via REST_v2]

Look into JRS-web-services-guide.pdf

Following is the example from the pdf

http://<host>:<port>/jasperserver[-pro]/rest_v2/reports/reports/samples/Cascading_multi_select_report.html? Country_multi_select=USA&Cascading_state_multi_select=W A&Cascading_state_multi_select=CA 

 

[Input Control Cache problem]

You can view the items that are being cached from

Server settings->adhoc cache. You can even clear it from there if that works for you.

I would like to know more about the input controls  Could you give more details on sql that each of the input controls run? Unless same user, uses same sql with same parameters that shouldnt really be happnening. Would help us to identify the issue with more information.

[Jasperserver won't start after shutting down - CacheException?]

Glad you figured it out!

[Select datasource, then parameters in JasperServer]

Please go through this link

https://community.jaspersoft.com/documentation/jasperreports-server-ultimate-guide/v55/roles-users-and-profile-attributes

JRS has feature called profile attribute in which different values be defined for attribute at different level (server, tenant, user). I am not 100% sure if this will solve your problem but this is worth a look. The link is for v55 but 6.0 and beyond presents more addition to the feature. Those attributes can be used in datasource/domain/adhoc/filter as of amber -2. (which is the work in progress) 

[Create Datasource with REST]

Can you give details on what is that you are passing to the server?

[Jasperserver won't start after shutting down - CacheException?]

If you are not using JRS in clustered environment, the easiest way to handle this is to hunt down CacheManagerPeerListener tag in ehcache configuration files and comment them out. There are few files, which I dont have the list yet. But they have filename of pattern *ehcache*.xml. There are 3 or so files.

HTH

[Data Staging]

It will work for reports too.

[Jasperserver won't start after shutting down - CacheException?]

What system are you using? is it Mac?

[Chaining pre filters with OR in domain designer]

Yes, it is possible but you will need a bit of work. I will summaries steps below:

• Frist create domain with all the filters that are to be applied.
• Export the domain (server settings->export)
• Unzip the file
• Find schema.xml.data, you will see line such as <filterString>users.first_name == 'Will' and users.first_name == 'Jim'</filterString>
• Replace and with or
• zip it back and import it to JRS

Thats it! you are ready to go.

Easier way would be to add those filters in adhoc viewer. :)

HTH

 

 

 

[Is it possible to integrate phonegap with jasper server?]

You can use visualize.js to embed jaserserver into your application. I think you should be able to use it with phone gap.

To get started: http://community.jaspersoft.com/wiki/visualizejs-getting-started

 

HTH

[Jasperserver community Installation error]

Could you please post the complete log. 

[How many rows of real time data(data limitation) will be accepted by Jaspersoft Server ?]

You can change it to whatever you want but be careful that it might crash the system due to large amount of data.

 

[Ad Hoc Domain parameters]

This might be more clear:

https://community.jaspersoft.com/documentation/jasperreports-server-ultimate-guide/v55/roles-users-and-profile-attributes

You can also add server level attributes from Repository ->root->System properties ->GlobalPropertiesList ->Edit (after right clicking) and make the required changes.

To access those variables, you can directly use  {attribute('attributeName')}  on your sql.

[Ad Hoc Domain parameters]

You can use profile attribute or user attribute. Those could be defined at server level, user level or tenant level.

https://community.jaspersoft.com/documentation/jasperreports-server-user-guide/profile-attributes

HTH

[How many rows of real time data(data limitation) will be accepted by Jaspersoft Server ?]

By default adhoc accepts 200,000. But you can change it from Manage->Server settings ->Adhoc settings.

HTH

[Can not start my JasperServer in Mac Yosemite]

Try this:

-Have the java.net.preferIPv4Stack=true in your ANY_OPTS and Java_Opts and also in TOMCAT

-Have your FQDN added to your hosts file not only localhost but the name of you Mac.

 

HTH.