steve.cohen

When I first start Mars I receive the following error: "Init JRS built-in Parameters has encountered a problem An internal error occurred during: "Init JRS built-in parameters. Could not initialize class org.exolab.castor.xml.Introspector." -------------------------- I click OK to get past it. When I go to setup a JDBC Connection, I get the following message: "An error has occurred. See error log for more details. java.lang.NullPointerException" --------------------------- I have enclosed the Error Log. I am at a loss; I have unistalled and reinstalled both, confirmed the proper Java verson, removed all Workspaces, etc. All help is appreciated!!! Cheers, -Steve

C-Box- That fixed it!!! Thank you so much! -Steve C

C-Box - Thanks for your quick response to my posting. I did as you suggested, in that I applied Style1 to each of the fields in the frame, as well as adding the bold to the text if the condition=true. I also removed the bold settings from the fields themselves. Note I did not apply bold to Style1, only to the conditional formatting part of it. Unfortunately it still doesn't work. I've included the code again (I don't want to remove anything, even if it seems irrelevant, as it still might be). Lines 15-23 in bold/red contain the style settings. Thanks, -Steve C ======================================================== <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.0.final using JasperReports Library version 5.5.1 --> <!-- 2019-10-09T08:57:58 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Past Due Records" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bfe31c6c-c96e-46ac-ad0a-297a589f45b4"> <property name="ireport.zoom" value="1.3310000000000006"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Steve"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <style name="Title" fontName="Arial" fontSize="14" isBold="true" pdfFontName="Times-Bold"/> <style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/> <style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/> <style name="Detail" backcolor="#FFFFFF" fontName="Arial" fontSize="12"/> <style name="Row" mode="Transparent"> <conditionalStyle> <conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression> <style backcolor="#E6DAC3"/> </conditionalStyle> </style> <style name="Style1" isBold="false"> <conditionalStyle> <conditionExpression><![CDATA[$F{Due Date}.before(new java.util.Date()) && $F{State}.equals( "Open" )]]></conditionExpression> <style mode="Opaque" backcolor="#FF6666" isBold="true"/> </conditionalStyle> </style> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["U:\Training\"]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT rec.c_case_number AS "Case Number", rec.c_entry_date AS "Entry Date", rec.c_due_date AS "Due Date", rec.state_label AS "State", rec.id AS "ID", rt.c_name AS "Region", prsn.last_name + ', ' + prsn.first_name AS "Analyst Assigned", cfg.c_data as "URL" FROM t_record rec LEFT JOIN etk_user eu ON eu.user_id = rec.c_analyst_assigned LEFT JOIN etk_person prsn ON prsn.person_id = eu.person_id LEFT JOIN t_region_type rt ON rt.id = rec.c_region LEFT JOIN t_configuration cfg ON cfg.c_code = 'url' WHERE rec.state_label = 'Open' ORDER BY rec.c_case_number]]> </queryString> <field name="Case Number" class="java.lang.String"/> <field name="Entry Date" class="java.sql.Timestamp"/> <field name="Due Date" class="java.sql.Timestamp"/> <field name="State" class="java.lang.String"/> <field name="ID" class="java.math.BigDecimal"/> <field name="Region" class="java.lang.String"/> <field name="Analyst Assigned" class="java.lang.String"/> <field name="URL" class="java.lang.String"/> <background> <band splitType="Stretch"/> </background> <title> <band height="54" splitType="Stretch"> <staticText> <reportElement style="Title" mode="Transparent" x="197" y="0" width="531" height="54" forecolor="#000000" uuid="27de7345-e734-4c56-8209-277be55db119"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="30" isUnderline="true" pdfFontName="Times-Roman"/> </textElement> <text><![CDATA[Open Records]]></text> </staticText> <image> <reportElement x="0" y="0" width="197" height="54" uuid="5b443867-0851-4662-ae61-012c2ca81f82"/> <imageExpression><![CDATA["https://www.micropact.com/assets/_res/images/micropact-logos/entellitrak-logo-1x.png"]]></imageExpression> </image> </band> </title> <pageHeader> <band height="34" splitType="Stretch"> <line> <reportElement x="0" y="32" width="752" height="1" uuid="01b461ea-516b-4801-8f9d-e8cd02e506a3"/> </line> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="-2" y="0" width="113" height="30" forecolor="#000000" uuid="93c23c7a-8eea-47f8-bb64-8a914bc30609"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement verticalAlignment="Bottom"> <font fontName="Arial" size="12" isBold="true"/> </textElement> <text><![CDATA[Case Number]]></text> </staticText> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="229" y="0" width="106" height="30" forecolor="#000000" uuid="d1b5487f-5947-4ed4-853b-2af4c507e186"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement verticalAlignment="Bottom"> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[Region]]></text> </staticText> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="463" y="0" width="147" height="30" forecolor="#000000" uuid="2f0b7365-9135-477d-b472-c4c614905eb8"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[Due Date]]></text> </staticText> <staticText> <reportElement x="111" y="0" width="118" height="30" uuid="5c341205-c551-4561-a30b-8e8e3d556bb2"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement verticalAlignment="Bottom"> <font fontName="Arial" size="12" isBold="true"/> </textElement> <text><![CDATA[state]]></text> </staticText> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="335" y="0" width="128" height="30" forecolor="#000000" uuid="56270df7-deb1-4ba6-a68b-e2e5fcee8871"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement verticalAlignment="Bottom"> <font fontName="Arial" size="12" isBold="true"/> </textElement> <text><![CDATA[Entry Date]]></text> </staticText> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="610" y="0" width="140" height="30" forecolor="#000000" uuid="80ea9c6b-a752-47b4-b23c-ac89f6265294"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[Analyst Assigned]]></text> </staticText> </band> </pageHeader> <detail> <band height="40" splitType="Stretch"> <frame> <reportElement style="Style1" x="0" y="0" width="750" height="40" uuid="524d0460-5388-4c98-af03-09ab356b3c24"/> <textField isBlankWhenNull="true"> <reportElement style="Style1" stretchType="RelativeToTallestObject" x="337" y="4" width="128" height="15" uuid="43cc7638-27a5-4526-bcdf-5c34adc4ed08"/> <textElement> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{Entry Date}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="Style1" x="612" y="4" width="128" height="15" uuid="635476fb-ab07-4879-8ccb-de459d569484"/> <textElement> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{Analyst Assigned}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="Style1" x="465" y="4" width="147" height="15" uuid="38c3db87-85f6-4cce-92a1-802c1f7799d0"/> <textElement textAlignment="Left"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{Due Date}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="Style1" stretchType="RelativeToTallestObject" x="113" y="4" width="118" height="15" uuid="563989e3-f924-4eff-9913-12fcc39ae270"/> <textElement> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{State}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="Style1" x="231" y="4" width="106" height="15" uuid="04ad1100-727d-40d7-93e0-ea0b635b761f"/> <textElement> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{Region}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true" hyperlinkType="Reference" hyperlinkTarget="Blank"> <reportElement style="Style1" stretchType="RelativeToTallestObject" x="0" y="4" width="113" height="15" forecolor="#0033CC" uuid="5c43edce-cdd1-4a09-afa8-f23dc2700bca"/> <textElement> <font fontName="Arial" size="9" isBold="false" isUnderline="true"/> </textElement> <textFieldExpression><![CDATA[$F{Case Number}]]></textFieldExpression> <hyperlinkReferenceExpression><![CDATA[$F{URL}+"workflow.do?dataObjectKey=object.record&trackingId="+$F{ID}]]></hyperlinkReferenceExpression> </textField> </frame> </band> </detail> <pageFooter> <band height="25" splitType="Stretch"> <textField pattern="EEEEE dd MMMMM yyyy"> <reportElement style="Column header" x="0" y="5" width="197" height="20" forecolor="#736343" uuid="c219142d-3dfe-4a10-a377-32e76994ad00"/> <textElement verticalAlignment="Middle"> <font size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> <textField> <reportElement style="Column header" x="630" y="5" width="80" height="20" forecolor="#736343" uuid="2bdefe08-c439-4230-94fd-da3821a1117c"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement style="Column header" x="710" y="5" width="40" height="20" forecolor="#736343" uuid="924fdfc4-16a1-4f38-b09b-3546dea11e80"/> <textElement verticalAlignment="Middle"> <font size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> </jasperReport>

Hello All! Working in JasperReports v6.3.0 using Eclipse Mars 4.5.2. In my report, I setup conditional formatting that if the report is past due and still open, display the entire row in red. I also want any text in a red row to be bold (to meet 508 compliance). I added Font "Bold" to the conditional statement. (Note: I added a Frame to the band and added the fields into the Frame. The Frame is using the style ("Style1") that I created). However, when I run it in Java or HTML, I get my red background but not bold text. When I run it in DOCX, I get my bold text but not my color background. I have tried all different things, but cannot figure it out. Does anyone have suggestions? (Source Code included below). Thanks, Steve C <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.0.final using JasperReports Library version 5.5.1 --> <!-- 2019-10-08T14:08:39 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Past Due Records" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bfe31c6c-c96e-46ac-ad0a-297a589f45b4"> <property name="ireport.zoom" value="1.3310000000000006"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Steve"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <style name="Title" fontName="Arial" fontSize="14" isBold="true" pdfFontName="Times-Bold"/> <style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/> <style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/> <style name="Detail" backcolor="#FFFFFF" fontName="Arial" fontSize="12"/> <style name="Row" mode="Transparent"> <conditionalStyle> <conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression> <style backcolor="#E6DAC3"/> </conditionalStyle> </style> <style name="Style1"> <conditionalStyle> <conditionExpression><![CDATA[$F{Due Date}.before(new java.util.Date()) && $F{State}.equals( "Open" )]]></conditionExpression> <style mode="Opaque" backcolor="#FF6666" isBold="true"/> </conditionalStyle> </style> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["U:\Training\"]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT rec.c_case_number AS "Case Number", rec.c_entry_date AS "Entry Date", rec.c_due_date AS "Due Date", rec.state_label AS "State", rec.id AS "ID", rt.c_name AS "Region", prsn.last_name + ', ' + prsn.first_name AS "Analyst Assigned", cfg.c_data as "URL" FROM t_record rec LEFT JOIN etk_user eu ON eu.user_id = rec.c_analyst_assigned LEFT JOIN etk_person prsn ON prsn.person_id = eu.person_id LEFT JOIN t_region_type rt ON rt.id = rec.c_region LEFT JOIN t_configuration cfg ON cfg.c_code = 'url' WHERE rec.state_label = 'Open' ORDER BY rec.c_case_number]]> </queryString> <field name="Case Number" class="java.lang.String"/> <field name="Entry Date" class="java.sql.Timestamp"/> <field name="Due Date" class="java.sql.Timestamp"/> <field name="State" class="java.lang.String"/> <field name="ID" class="java.math.BigDecimal"/> <field name="Region" class="java.lang.String"/> <field name="Analyst Assigned" class="java.lang.String"/> <field name="URL" class="java.lang.String"/> <background> <band splitType="Stretch"/> </background> <title> <band height="54" splitType="Stretch"> <staticText> <reportElement style="Title" mode="Transparent" x="197" y="0" width="531" height="54" forecolor="#000000" uuid="27de7345-e734-4c56-8209-277be55db119"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="30" isUnderline="true" pdfFontName="Times-Roman"/> </textElement> <text><![CDATA[Open Records]]></text> </staticText> <image> <reportElement x="0" y="0" width="197" height="54" uuid="5b443867-0851-4662-ae61-012c2ca81f82"/> <imageExpression><![CDATA["https://www.micropact.com/assets/_res/images/micropact-logos/entellitrak-logo-1x.png"]]></imageExpression> </image> </band> </title> <pageHeader> <band height="34" splitType="Stretch"> <line> <reportElement x="0" y="32" width="752" height="1" uuid="01b461ea-516b-4801-8f9d-e8cd02e506a3"/> </line> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="-2" y="0" width="113" height="30" forecolor="#000000" uuid="93c23c7a-8eea-47f8-bb64-8a914bc30609"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement verticalAlignment="Bottom"> <font fontName="Arial" size="12" isBold="true"/> </textElement> <text><![CDATA[Case Number]]></text> </staticText> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="229" y="0" width="106" height="30" forecolor="#000000" uuid="d1b5487f-5947-4ed4-853b-2af4c507e186"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement verticalAlignment="Bottom"> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[Region]]></text> </staticText> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="463" y="0" width="147" height="30" forecolor="#000000" uuid="2f0b7365-9135-477d-b472-c4c614905eb8"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[Due Date]]></text> </staticText> <staticText> <reportElement x="111" y="0" width="118" height="30" uuid="5c341205-c551-4561-a30b-8e8e3d556bb2"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement verticalAlignment="Bottom"> <font fontName="Arial" size="12" isBold="true"/> </textElement> <text><![CDATA[state]]></text> </staticText> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="335" y="0" width="128" height="30" forecolor="#000000" uuid="56270df7-deb1-4ba6-a68b-e2e5fcee8871"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement verticalAlignment="Bottom"> <font fontName="Arial" size="12" isBold="true"/> </textElement> <text><![CDATA[Entry Date]]></text> </staticText> <staticText> <reportElement style="Column header" stretchType="RelativeToTallestObject" x="610" y="0" width="140" height="30" forecolor="#000000" uuid="80ea9c6b-a752-47b4-b23c-ac89f6265294"/> <box topPadding="1" leftPadding="2" bottomPadding="1" rightPadding="2"/> <textElement textAlignment="Left" verticalAlignment="Bottom"> <font fontName="Arial" isBold="true"/> </textElement> <text><![CDATA[Analyst Assigned]]></text> </staticText> </band> </pageHeader> <detail> <band height="40" splitType="Stretch"> <frame> <reportElement style="Style1" x="0" y="0" width="750" height="40" uuid="524d0460-5388-4c98-af03-09ab356b3c24"/> <textField isBlankWhenNull="true"> <reportElement stretchType="RelativeToTallestObject" x="337" y="4" width="128" height="15" uuid="43cc7638-27a5-4526-bcdf-5c34adc4ed08"/> <textElement> <font fontName="Arial" size="9" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{Entry Date}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="Detail" x="612" y="4" width="128" height="15" uuid="635476fb-ab07-4879-8ccb-de459d569484"/> <textElement> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{Analyst Assigned}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="Detail" x="465" y="4" width="147" height="15" uuid="38c3db87-85f6-4cce-92a1-802c1f7799d0"/> <textElement textAlignment="Left"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{Due Date}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement stretchType="RelativeToTallestObject" x="113" y="4" width="118" height="15" uuid="563989e3-f924-4eff-9913-12fcc39ae270"/> <textElement> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{State}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement style="Detail" x="231" y="4" width="106" height="15" uuid="04ad1100-727d-40d7-93e0-ea0b635b761f"/> <textElement> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{Region}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true" hyperlinkType="Reference" hyperlinkTarget="Blank"> <reportElement stretchType="RelativeToTallestObject" x="0" y="4" width="113" height="15" forecolor="#0033CC" uuid="5c43edce-cdd1-4a09-afa8-f23dc2700bca"/> <textElement> <font fontName="Arial" size="9" isBold="false" isUnderline="true"/> </textElement> <textFieldExpression><![CDATA[$F{Case Number}]]></textFieldExpression> <hyperlinkReferenceExpression><![CDATA[$F{URL}+"workflow.do?dataObjectKey=object.record&trackingId="+$F{ID}]]></hyperlinkReferenceExpression> </textField> </frame> </band> </detail> <pageFooter> <band height="25" splitType="Stretch"> <textField pattern="EEEEE dd MMMMM yyyy"> <reportElement style="Column header" x="0" y="5" width="197" height="20" forecolor="#736343" uuid="c219142d-3dfe-4a10-a377-32e76994ad00"/> <textElement verticalAlignment="Middle"> <font size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> <textField> <reportElement style="Column header" x="630" y="5" width="80" height="20" forecolor="#736343" uuid="2bdefe08-c439-4230-94fd-da3821a1117c"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement style="Column header" x="710" y="5" width="40" height="20" forecolor="#736343" uuid="924fdfc4-16a1-4f38-b09b-3546dea11e80"/> <textElement verticalAlignment="Middle"> <font size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> </jasperReport>