...
Java Conditions
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
new Boolean($P{letterNumber}.equalsIgnoreCase("1st")||$P{letterNumber}.equalsIgnoreCase("2nd")) |
...
new Boolean ( ! $F{provider_code}.equals( "Morling" ) ) |
...
new Boolean( $V{amountDueTotal}.compareTo( new Double (0.00) ) > 0 ) |
...
new Boolean ( $V{PAGE_NUMBER}.toString() == "1" ) |
...
new Boolean ($F{chessn}!=null && !$P{unitEnrolmentEndDate}.equals("")) |
...
new Boolean ( $F{course_level}.equals("VET"))
new Boolean ( $F{enrolment_status_id}.equals( "ENROLMENT_COMPLETED" ) ) |
Dates
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
new SimpleDateFormat("dd MMMM yyyy").format( new Date()) |
...
new java.util.Date(2017, 1, 1) |
...
"Teaching Period: " + new SimpleDateFormat("dd MMMM yyyy").format( $F{current_semester_name} ) |
...
new SimpleDateFormat("EEEEE, dd MMMMM yyyy").parse($P{todaysDate}) |
...
new SimpleDateFormat("dd/MM/yyyy").format($P{report_date}) |
...
Casting
...
"Admitted to the "+$F{course_name}+" on "+new |
...
...
...
$F{course_enrolment_start_date}) |
Casting
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
"You currently owe: $" + new DecimalFormat("###0.00").format($V{amountDueTotal}).toString()
$V{PAGE_NUMBER}.toString()
"Total credit points required: " + new DecimalFormat("0").format($F{credit_points_required}).toString() |
...
From <https://stackoverflow.com/questions/4832133/formatting-double-into-a-string-in-ireport>
...
( $V{gpa_total}==null ? new Double (0) : $V{gpa_total} ) |
Static field formatting
Inline casting of fields
...
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
"Accumulated grade point average: " + ( $V{gpa_total}==null ? "0.00" : new DecimalFormat("0.00").format($V{gpa_total}).toString() ) |
Uppercase
...
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
Example: $V{studentFormalName}.toUpperCase() |
From <https://community.jaspersoft.com/questions/533776/touppercase-functionality-fields>
Text field formatting
Set mark-up and confirm is styled text
...
| Note |
|---|
|
On the Text tab of the field Properties set the "is styled text" to true and the Markup select field to "HTML" |
Bold
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
<style isBold=\"true\" pdfFontName=\"Helvetica-Bold\"> This becomes bold </style> |
Underline
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
<style isUnderline=\"true\" >Underline me! </style> |
Italic
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
<style isItalic=\"true\" pdfFontName=\"Helvetica-Oblique\"> I'm leaning to one side </style> |
Colour
...
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
<style forecolor=\"#0000ff\"> Colour me surprised </style> |
Dot-points
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
+"•" |
...
" <style isBold=\"true\" pdfFontName=\"Helvetica-Bold\">Total Earned Credit Points: </style>" + $V{earnedCreditPoints}.intValue()
"/var/opt/ems/nida/files/"+$F{file_name}
$P{reportSourcePath} + "/images/cairnmillar_letter_header.png"
Escaping double quote
| Code Block |
|---|
"Thank you for your application for enrolment at Group Colleges Australia (\"GCA\") Pty Ltd trading as Universal Business School Sydney (UBSS)." |
Sample dynamic where clauses
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
( $P{eduProgramEnrolmentId |
Escaping
Escaping double quote
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
|
"Thank you for your application for enrolment at Group Colleges Australia (\"GCA\") Pty Ltd trading as Universal Business School Sydney (UBSS)." |
Sample dynamic where clauses
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
( $P{eduProgramEnrolmentId}==null || $P{eduProgramEnrolmentId}.equals("") ? "" : " AND epe.edu_program_enrolment_id = '"+$P{eduProgramEnrolmentId}+"'" ) +
( $P{academicTermId}==null || $P{academicTermId}.equals("") ? "" : " AND tp.custom_time_period_id = '"+$P{academicTermId}+"'" ) +
( $P{courseId}==null || $P{courseId}.equals("") ? "" : " AND epe.edu_program_id = '"+$P{courseId}+"'" ) +
( $P{providerId}==null || $P{providerId}.equals("") ? "" : " AND epe.home_institution_party_id = '"+$P{providerId}+"'" ) +
( $P{studentNumber}==null || $P{studentNumber}.equals("") ? "" : " AND lsi.student_number = '"+$P{studentNumber}+"'" ) +
( $P{censusPeriodId}==null || $P{censusPeriodId}.equals("") ? "" : " AND esu.dest_census_date IN "+$P{censusPeriodId}) +
/*
( $P{censusDateFrom}==null || $P{censusDateFrom}.equals("") ? "" : " AND esu.dest_census_date >= '"+$P{censusDateFrom}+"'" ) +
( $P{censusDateTo}==null || $P{censusDateTo}.equals("") ? "" : " AND esu.dest_census_date <= '"+$P{censusDateTo}+"'" ) +
*/
( $P{unitEnrolmentStatus}==null || $P{eduProgramEnrolmentIdunitEnrolmentStatus}.equals("") ? "" : " AND epeeue.eduenrolment_program_enrolmentstatus_id IN "+$P{unitEnrolmentStatus} )
+((($P{eduProgramEnrolmentId}== '"+null || $P{eduProgramEnrolmentId}+.equals("'"))&&
) + ( $P{academicTermId}==null || $P{academicTermId}.equals(""))&&
? "" : " AND tp.custom_time_period_id = '"+$P{academicTermId}+"'" ) +
( $P{courseId ($P{courseId}==null || $P{courseId}.equals(""))&&
($P{providerId}==null || $P{courseIdproviderId}.equals(""))&&
? "" : " AND epe.edu_program_id = '"+$P{courseId}+"'" ) +
( $P{providerId ($P{studentNumber}==null || $P{studentNumber}.equals(""))&&
($P{censusDateFrom}==null || $P{providerIdcensusDateFrom}.equals("")) ?&&
"" : " AND epe.home_institution_party_id = '"+$P{providerId}+"'" ) +
( $P{studentNumber ($P{censusDateTo}==null || $P{censusDateTo}.equals(""))&&
($P{censusPeriodId}==null || $P{studentNumbercensusPeriodId}.equals("") ? "" : " AND lsi.student_number = '"+$P{studentNumber}+"'" ) +
( $P{censusPeriodId))&&
($P{unitEnrolmentStatus}==null || $P{censusPeriodIdunitEnrolmentStatus}.equals("") ? "" : )))?" AND esuepe.destedu_program_census_date IN "+$P{censusPeriodId}) +
/*
( $P{censusDateFrom}==null || $P{censusDateFrom}.equals("") ? "" : " AND esu.dest_census_date >= '"+$P{censusDateFrom}+"'" ) +
( $P{censusDateTo}==null || $P{censusDateTo}.equals("") ? "" : " AND esu.dest_census_date <= '"+$P{censusDateTo}+"'" ) +
*/
( $P{unitEnrolmentStatus}==null || $P{unitEnrolmentStatus}.equals("") ? "" : " AND eue.enrolment_status_id IN "+$P{unitEnrolmentStatus} )
+((($P{eduProgramEnrolmentId}==null || $P{eduProgramEnrolmentId}.equals(""))&&
($P{academicTermId}==null || $P{academicTermId}.equals(""))&&
($P{courseId}==null || $P{courseId}.equals(""))&&
($P{providerId}==null || $P{providerId}.equals(""))&&
($P{studentNumber}==null || $P{studentNumber}.equals(""))&&
($P{censusDateFrom}==null || $P{censusDateFrom}.equals(""))&&
($P{censusDateTo}==null || $P{censusDateTo}.equals(""))&&
($P{censusPeriodId}==null || $P{censusPeriodId}.equals(""))&&
($P{unitEnrolmentStatus}==null || $P{unitEnrolmentStatus}.equals("")))?" AND epe.edu_program_enrolment_id='No Parameters'":"")
|
Sample address blocks
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
enrolment_id='No Parameters'":"")
|
Sample address blocks
| Code Block |
|---|
| language | java |
|---|
| theme | Midnight |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
|
($F{billing_property_name} != null ? $F{billing_property_name} + "\n" : "") +
($F{billing_street_subaddress} != null ? $F{billing_street_subaddress} + " " : "") +
($F{billing_postal_subaddress} != null ? $F{billing_postal_subaddress} + " " : "") +
($F{billing_street_subaddress} != null || $F{billing_street_subaddress} != null ? "\n" : "")+
($F{billing_street_number} != null ? $F{billing_street_number} + " " : "") +
($F{billing_street_name} != null ? $F{billing_street_name} + "\n" : "") +
($F{billing_city} != null ? $F{billing_city} + " " : "") +
($F{billing_state_province_geo_id} != null ? $F{billing_state_province_geo_id} + " " : ($F{billing_state_abbreviation} != null ? $F{billing_state_abbreviation} + " " : " ")) +
($F{billing_postal_code} != null ? $F{billing_postal_code} + "\n" : "") +
($F{billing_country_name} != null ? $F{billing_country_name} + "\n" : "")
($F{billing_address1} != null ? $F{billing_address1}.replaceAll("\\\\'", "'") + '\n' : "") +
($F{billing_address2} != null ? $F{billing_address2}.replaceAll("\\\\'", "'") + '\n' : "") +
($F{billing_city} != null ? $F{billing_city}.replaceAll("\\\\'", "'") + '\t' : "") + " " +
($F{billing_state} != null ? $F{billing_state_abbrev}.replaceAll("\\\\'", "'") + " " : ($F{billing_state}!=null ? $F{billing_state}.replaceAll("\\\\'", "'") + " " : "")) +
($F{billing_postal_code} != null ? $F{billing_postal_code}.replaceAll("\\\\'", "'") : "") +
($F{billing_country} != null && !$F{billing_country}.equals("AUSTRALIA") ? "\n" + $F{billing_country}.replaceAll("\\\\'", "'") : "")
($F{postal_address1} != null ? $F{postal_address1}.replaceAll("\\\\'", "'") + '\n' : "") +
($F{postal_address2} != null ? $F{postal_address2}.replaceAll("\\\\'", "'") + '\n' : "") +
($F{postal_city} != null ? $F{postal_city}.replaceAll("\\\\'", "'") + '\t' : "") + " " +
($F{postal_state} != null ? $F{postal_state_abbrev}.replaceAll("\\\\'", "'") + " " : ($F{postal_state}!=null ? $F{postal_state}.replaceAll("\\\\'", "'") + " " : "")) +
($F{postal_state_abbrev} != null ? $F{postal_state_abbrev}.replaceAll("\\\\'", "'") : "") +
($F{postal_country} != null && !$F{postal_country}.equals("AUSTRALIA") ? "\n" + $F{postal_country}.replaceAll("\\\\'", "'") : "")
($F{residential_street_number} != null ? $F{residential_street_number}.replaceAll("\\\\'", "'") + ' ' : "") +
($F{residential_street_name} != null ? $F{residential_street_name}.replaceAll("\\\\'", "'") + '\n' : "") +
($F{residential_street_subaddress} != null ? $F{residential_street_subaddress}.replaceAll("\\\\'", "'") + '\n' : "") +
($F{residential_city} != null ? $F{residential_city}.replaceAll("\\\\'", "'") + '\n' : "") + " " +
($F{residential_state} != null ? $F{residential_state}.replaceAll("\\\\'", "'") + " " : ($F{residential_state}!=null ? $F{residential_state}.replaceAll("\\\\'", "'") + " " : "")) +
($F{residential_postal_code} != null ? $F{residential_postal_code}.replaceAll("\\\\'", "'") + '\n' : "") + " " +
($F{residential_country_geo_id} != null && !$F{residential_country_geo_id}.equals("AUSTRALIA") ? "\n" + $F{residential_country_geo_id}.replaceAll("\\\\'", "'") : "") |
...