Jaspersoft TIBC adhoc designer

Note:

1. Use the data Filters (Data Level) to zoom into the details of the data to show on the graph. Otherwise without clicking it will show only the total overall the data instead of the each particular data of the rows.

2. The rows data level is important to zoom into so that it will reveal each particular data



Product Family: $P{Product Family ? " + "}

For repository links in a chart dashlet, use the syntax ?$P{"filter_in_target=", dashlet_param, ? "&"}. For example, the following link allows multi-select with the c_country_1 input control in the 05. Unit Sales Trend report:
repo:/public/Samples/Reports/05._Unit_Sales_Trend?$P{"c_country_1=", Store Country, "&"}

When Mexico and USA are selected, this expands to the following link:

repo:/public/Samples/Reports/05._Unit_Sales_Trend?c_country_1=Mexico&c_country_1=USA

References:

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v611/dashboard-properties

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v611/specifying-parameters-dashlets#DashletParameters

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v611/adding-hyperlink-chart-dashlet

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-user-guide/v611/specifying-parameters-dashlets#WebPage



Important:

1. Calculated Field Reference

Date settings in the server files
JasperReportsServer-47-Professional-Openshift/deployments/jasperserver-pro.war/WEB-INF/bundles/adhoc_masks_ja.properties

ADH_100_MASK_date_0 = medium,hide
ADH_100_MASK_date_1 = short,hide
ADH_100_MASK_date_2 = long,hide
ADH_100_MASK_date_3 = medium,medium
ADH_100_MASK_date_4 = hide,medium

ADH_100_MASK_int_0 = #,##0
ADH_100_MASK_int_1 = 0
ADH_100_MASK_int_2 = $#,##0;($#,##0)
ADH_100_MASK_int_3 = #,##0;(#,##0)

ADH_100_MASK_dec_0 = #,##0.00
ADH_100_MASK_dec_1 = 0
ADH_100_MASK_dec_2 = $#,##0.00;($#,##0.00)
ADH_100_MASK_dec_3 = $#,##0;($#,##0)

ADH_100_MASK_time_0 = hide,medium
ADH_100_MASK_time_1 = hide,short
ADH_100_MASK_time_2 = hide,long

ADH_101_EXAMPLE_NUMBER = -1234.56