[Date Picker Input Control - Start Week on Sunday not Monday]

Hi,

for relative dates, you can change week start day in WEB-INFclassesrelativedate.properties file.

For other cases, week start day is hard-coded in scripts located in bower_componentsjquery-uiuii18n for each locale:

firstDay: 1

If you modify the scripts, you have to re-optimize them or configure JasperReports Server to use non-optimized scripts:

http://community.jaspersoft.com/documentation/jasperreports-server-ultimate-guide/v561/customizing-javascript-files

Hope, this helps

[Cant pass multiple values as input control at jasperserver]

Hi,
I'm not familiar with Apex in details but from what I found out, Apex calls JasperReports server reports using HTTP API like

http://jasperreport-server/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/report_name&output=pdf&j_username=jasper_user&j_password=jasper_password&rep_parm=parm_value

If this is the case, to pass multiple values for a parameter, you should include it multiple time in the call:

http://jasperreport-server/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/report_name&output=pdf&j_username=jasper_user&j_password=jasper_password&rep_parm=parm_value_1&rep_parm=parm_value_2&rep_parm=parm_value_3

 

Hope this helps

[Not able to send email reports]

Please review the article below

http://community.jaspersoft.com/wiki/how-configure-jasperreports-server-send-e-mails-gmail-mail-account

Note, that the protocol must be smtps in both  jasperserver-proWEB-INFjs.quartz.properties and jasperserver-proWEB-INFapplicationContext-report-scheduling.xml files

[Jasperreport with restful webservice as datasource]

Hi,

I used JasperReports Server REST_v2 web-service to test your scenario and to pass required organization name as a parameter.

So, what I did:

1. In Jaspersoft Studio create new data adapter using 'XML document' type and specify JasperReports Server REST organizations service URL for File field
   and select 'Use the report Xpath expression when filling the report' option: 
   
   http://localhost:8090/jasperserver-pro/rest_v2/organizations?j_username=superuser&j_password=superuser
    
2. Create a new report using the new dataadapter with Xpath expression:
   
   /organizations/organization
   
   Run the report to verify how it works. It should return all existing organizations in JasperReports Server
    
3. Create a new parameter with java.lang.String type, for example p_org, and then modify Xpath expression to
   
   /organizations/organization[id=$P{p_org}]
    
4. Run the report, enter organization_1 as the parameter value. The report returns 1 record for organization_1
    

Here you can find a short summary how to use Xpath expression to filter data:

http://www.w3schools.com/xml/xml_xpath.asp

Hope this help you to implement your task

[Generating reports based on ROLES]

Hi,

role_name is the column name in a table, you should replace it with your column. LoggedInUserRoles built-i parameter is a collection that contains a list of roles of logged in user (a a user can belongs to multiple roles).

[Generating reports based on ROLES]

I think you can simply use LoggedInUserRoles builtin parameter in report query:

select * from table where  $X{IN, role_name, LoggedInUserRoles}

[Jaspersoft Studio / Pie Charts]

Hi,

it seems that the report main query does not return data. That is why you get empty document.

Try to specify a dummy SQL for the report main query or setup When No Data Type report property to 'All Sections No Detail'

[How to scale/zoom report embedded through visualize.js]

JSFiddle examples below may help you:

Disable autoresize and resize report manually - http://jsfiddle.net/6c8mu5my/15/

Fit report to container - http://jsfiddle.net/NesterOne/7ChRr/
You may need to change URL in the second example.

[Disable crosstab interactivity]

Hi,

try adding net.sf.jasperreports.crosstab.interactive=false property to WEB-INF/classes/jasperreports.properties file

[what is the keystore password for jasper-pro 5.0.1 tomcat]

Not sure if the question is still actual, but just in case - you can find required password in WEB-INFclassesesapisecurity-config.properties file

keystore.password

parameter

['Other' category in HTML5 pie chart]

Unfortunately, HTML5 Pie chart has no built-in properties to limit the number of slices.

You can try the following solution:

 - create a report variable that calculates summary value (Countries freight for sample Orders table)

 - add Chart Category expression to group countries with percentage value less than a fixed value (to say less than 5% of total summary value) to Others slice: 

 

IF((SUM($F{FREIGHT})/$V{V_TOTAL})>0.05,$F{SHIPCOUNTRY},"Others") 

 

[Loading User/Roles from a separate database.]

Hi,

JasperReports Server stores users and roles information in its own database - repository. It is possible to configure JasperReports Server to use exteral authentication (LDAP,  CAS, external database). You can find more details in 'JasperReports Server Authentication cookbook'

https://community.jaspersoft.com/documentation/jasperreports-server-authentication-cookbook/introduction

[How to execute some database function before running report]

Hi,

it looks like using Scriptlet with the report may help you to implement your requirements. A scriptlet is a Java class used to execute special elaborations during report generation. A scriptlet exposes a set of methods that are invoked by the reporting engine when a particular event occurs, such as the creation of a new page or the end of processing a detail row.

You should use beforeReportInit() method to call the Oracle PL/SQL code before report initialization.

You can find more information about scriptlets in iReport Ultimate Guide

http://community.jaspersoft.com/system/files/documentation/ireport-ultimate-guide.pdf

Also, there is a great external article

http://www.tutorialspoint.com/jasper_reports/jasper_report_scriptlets.htm

[i want to print negative number as zero "0" in iReports]

Hi Abhi,

generally, you can modify Expression property for 'Text Field' element that prints required field, something like this:

IF($F{field_name}<0,0,$F{field_name})

[HTML5 Charts - Including Filters]

Hi,

if I've got your requirements correctly, you should add 2 parameters to the report to filter data as described in the article below:

https://community.jaspersoft.com/wiki/using-report-parameters-jaspersoft-studio

Then, when you publish the report to a JasperReports Server, input controls will be automatically generated to filter the report data

[Dashboard Report]

Hi,

you may find useful the article below regarding session timeouts in JasperReports Server:

http://community.jaspersoft.com/wiki/timeouts-jasperreports-server