Is it possible to change the default in Jaspersoft 6.3 when running a report for ?Use Business Hours?, as the default is currently set to Yes?

book

Article ID: 16996

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction



Is it possible to change the default in Jaspersoft 6.3 when running a report for “Use Business Hours”, as the default is currently set to Yes?

For my Organization, we always need to set “Use Business Hours” to No, and sometimes my Operators forget to change the default setting which results in incorrect and invalid reports.

Environment

Spectrum 10.2.x Jaspersoft 6.3

Resolution

Although its technically not supported, there is a way to change the default setting for “Use Business Hours” from “Yes” to “No”.

 

a. Log into JasperReports Server and go to repository.
b. Navigate to root/Public/ca/Spectrum/inputcontrols/common/single_select/
c. Click on $R{p_useBusinessDayHours_KEY} and select "Edit"
d. In the "Edit Input Control" page, leave all default values and click on Next until you reach "Edit List of Values".
e. In "Edit List of Values" page, remove "True" with value "1" and add it back again, so that "False" with value 0 comes first and "True" with value 0 comes second.

f. Press submit to save the changes.
g. Reports from now on should default to “Use Business Hours” as No


Please note that these changes/customizations are not supported and will be reset once the customer performs a Jasper Integration or "redeploy" on the same server.  This currently works for 9 out of 10 reports and it does not work for “Availability: Group” report.