Monday, November 30, 2015

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

No comments:

Post a Comment

Adjustable DC to DC step up voltage booster using LM2577 -Adj P+ chip

One simple circuit to step up voltage using LM2577 -Adj P+ chip. The schematic is from Texas Instrument and it works expected - and below is...