jslater

Hi all Software Versions iReport : 3.7.0 and JasperServer : 3.7.0 Issue The report uses a List object to provide the user with a multi-select parameter which is then used in a query. Work perfectly in iReports. But when published in JasperServer provides the following error "com.jaspersoft.jasperserver.api.JSExceptionWrapper: Unknown column name : <column name>" Attempted After searching the forums replaced all occurences of the following file, jasperreports-3.7.0.1.jar with jasperreports-3.7.1.1.jar (taken from JS 3.7.1). Unfortunately no success :-( Please could someone be kind enough to provide a helping hand as I am totally lost and helpless now. Thanks in advance John

Anyone willing to help a fellow Jasper user? Cheers John

Hi All Could I be given a guiding hand in the right direction please: What I need is a query screen allowing a user to Select a date range and also Select a specific person from a list box (this list box is populated with all the names of the people held in the database, so is not hard coded)Depending on the above selected values the report can be generated and the data displayed. Selecting a date is fine, however I am more concerned about the selecting the specific individual, Where do I start? do I need to consider subreports? I hope I have made sense. Looking forward to some advice. Thank you in advance. Cheers John

Hi All Thanks to all for your help. Finally resolved the issue by creating another database field with the integer equivalent of the specfic text that was expected to control the field colour, that is 'Likely Cause' = 1 and should display in Red'Possible Cause' = 2 and should display in Amber'Unlikely Cause' = 3 and should display in GreenThis new field was then used in the condition expression rather than the text field. This worked perfectly. I hope this helps someone else with a similar requirement, Thank you once again to all those who helped. Cheers John

Slow Thank you for your reply. I am really getting fustrated with the issue. :-( As requested, I have pasted the code as it currently exists for the report However, I have managed to get the colours working with an integer variable. So I can only assume that there maybe an issue with the condition expression statements, e.g. am I using the correct class 'equals', I really dunno? Your help will be very much appreciated Thanks John Code:<?xml version="1.0" encoding="UTF-8"?><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="report name" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <style name="AlternativeStyle" isDefault="false" backcolor="#FF0000"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean ($F{DiagnosticView_Status}.equals( "Possible Cause" ))]]></conditionExpression> <style isDefault="false" style="AlternativeStyle" mode="Transparent" backcolor="#FF0000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean ($F{DiagnosticView_Status}.equals( "Impossible Cause" ))]]></conditionExpression> <style isDefault="false" style="AlternativeStyle" mode="Transparent" backcolor="#00FF00"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean ($F{DiagnosticView_Status}.equals( "Unlikely Cause" ))]]></conditionExpression> <style isDefault="false" style="AlternativeStyle" mode="Transparent" backcolor="#FFC800"/> </conditionalStyle> </style> <queryString> <![CDATA[sELECT DiagnosticView."WhenChanged" AS DiagnosticView_WhenChanged, DiagnosticView."TransactionID" AS DiagnosticView_TransactionID, DiagnosticView."Status" AS DiagnosticView_Status, DiagnosticView."Date" AS DiagnosticView_Date, DiagnosticView."Time" AS DiagnosticView_Time, DiagnosticView."ObjectType" AS DiagnosticView_ObjectType, DiagnosticView."Action" AS DiagnosticView_Action, DiagnosticView."ObjectName" AS DiagnosticView_ObjectName, DiagnosticView."ChangedBy" AS DiagnosticView_ChangedBy, DiagnosticView."FromApp" AS DiagnosticView_FromAppFROM "dbo"."DiagnosticView" DiagnosticView]]> </queryString> <field name="DiagnosticView_WhenChanged" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DiagnosticView_TransactionID" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DiagnosticView_Status" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DiagnosticView_Date" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DiagnosticView_Time" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DiagnosticView_ObjectType" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DiagnosticView_Action" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DiagnosticView_ObjectName" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DiagnosticView_ChangedBy" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DiagnosticView_FromApp" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <group name="Status"> <groupExpression><![CDATA[$F{DiagnosticView_Status}]]></groupExpression> <groupHeader> <band height="47"> <textField> <reportElement mode="Opaque" x="397" y="12" width="100" height="12" backcolor="#EAF1DD"/> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Action"]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="197" y="12" width="100" height="12" backcolor="#EAF1DD"/> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Time"]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="597" y="12" width="100" height="12" backcolor="#EAF1DD"/> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Changed By"]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="297" y="12" width="100" height="12" backcolor="#EAF1DD"/> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Object Type"]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="697" y="12" width="100" height="12" backcolor="#EAF1DD"/> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["From Application"]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="97" y="12" width="100" height="12" backcolor="#EAF1DD"/> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Date"]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="497" y="12" width="100" height="12" backcolor="#EAF1DD"/> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Object Name"]]></textFieldExpression> </textField> <textField pattern=""> <reportElement style="AlternativeStyle" mode="Opaque" x="0" y="0" width="802" height="12" backcolor="#D7E4BC"/> <textElement textAlignment="Center"> <font fontName="Arial" size="9" isBold="true" isUnderline="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DiagnosticView_Status}]]></textFieldExpression> </textField> <textField> <reportElement x="197" y="24" width="100" height="12"/> <textElement> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DiagnosticView_Time}]]></textFieldExpression> </textField> <textField> <reportElement x="297" y="24" width="100" height="12"/> <textElement> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DiagnosticView_ObjectType}]]></textFieldExpression> </textField> <textField> <reportElement x="397" y="24" width="100" height="12"/> <textElement> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DiagnosticView_Action}]]></textFieldExpression> </textField> <textField> <reportElement x="497" y="24" width="100" height="12"/> <textElement> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DiagnosticView_ObjectName}]]></textFieldExpression> </textField> <textField> <reportElement x="597" y="24" width="100" height="12"/> <textElement> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DiagnosticView_ChangedBy}]]></textFieldExpression> </textField> <textField> <reportElement x="697" y="24" width="100" height="12"/> <textElement> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DiagnosticView_FromApp}]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="97" y="12" width="100" height="12" backcolor="#EAF1DD"/> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Date"]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="0" y="12" width="100" height="12" backcolor="#EAF1DD"/> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["TranID"]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="24" width="100" height="12"/> <textElement> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DiagnosticView_TransactionID}]]></textFieldExpression> </textField> <textField> <reportElement x="100" y="24" width="100" height="12"/> <textElement> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{DiagnosticView_Date}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="23"/> </groupFooter> </group> <background> <band/> </background> <title> <band/> </title> <pageHeader> <band height="15"> <staticText> <reportElement mode="Opaque" x="545" y="2" width="255" height="12" backcolor="#EAF1DD"/> <textElement textAlignment="Right"> <font fontName="Arial" size="9" isBold="false"/> </textElement> <text><![CDATA[Diagnostic Report for Purple Telecom]]></text> </staticText> <textField> <reportElement mode="Opaque" x="0" y="2" width="547" height="12" backcolor="#EAF1DD"/> <textElement> <font fontName="Arial" size="9"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Activity in Genesys CME "]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band/> </columnHeader> <detail> <band/> </detail> <columnFooter> <band/> </columnFooter> <pageFooter> <band/> </pageFooter> <summary> <band/> </summary></jasperReport>

Hi Gaby38 Removed the Opaque from the Style and maintain on database field. No success :-( Am I missing something else, am stumped as there is nothing more I can think off :-( Thanks John

Any help would be much appreciated. My requirement is the following: I have a database field that needs to change colour depending on the string it contains, that is 'Likely Cause' it should display in Red 'Possible Cause' it should display in Amber 'Unlikely Cause' it should display in GreenAs can been seen in the code I have used a conditional style, named 'AlternativeStyle'. This style has then been associated with the 'style' property of the specifc database field. Unfortunately it is not working. Please could someone point out where I am going wrong. Thanks in advance. Regards John Code: <style name="AlternativeStyle" isDefault="false" mode="Opaque"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean ($F{DiagnosticView_Status}.matches("Likely Cause"))]]></conditionExpression> <style isDefault="false" style="AlternativeStyle" mode="Opaque" backcolor="#00FF00"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean ($F{DiagnosticView_Status}.matches("Possible Cause"))]]></conditionExpression> <style isDefault="false" style="AlternativeStyle" mode="Opaque" backcolor="#FF9900"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean ($F{DiagnosticView_Status}.matches("Impossible Cause"))]]></conditionExpression> <style isDefault="false" style="AlternativeStyle" mode="Opaque" backcolor="#FF6600"/> </conditionalStyle> </style>

Any help would be much appreciated. My requirement is the following: I have a database field that needs to change colour depending on the string it contains, that is 'Likely Cause' it should display in Red 'Possible Cause' it should display in Amber 'Unlikely Cause' it should display in GreenAs can been seen in the code I have used a conditional style, named 'AlternativeStyle'. This style has then been associated with the 'style' property of the specifc database field. Unfortunately it is not working. Please could someone point out where I am going wrong. Thanks in advance. Regards John Code: <style name="AlternativeStyle" isDefault="false" mode="Opaque"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean ($F{DiagnosticView_Status}.matches("Likely Cause"))]]></conditionExpression> <style isDefault="false" style="AlternativeStyle" mode="Opaque" backcolor="#00FF00"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean ($F{DiagnosticView_Status}.matches("Possible Cause"))]]></conditionExpression> <style isDefault="false" style="AlternativeStyle" mode="Opaque" backcolor="#FF9900"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean ($F{DiagnosticView_Status}.matches("Impossible Cause"))]]></conditionExpression> <style isDefault="false" style="AlternativeStyle" mode="Opaque" backcolor="#FF6600"/> </conditionalStyle> </style>

Hi Further to my previous email. I would like to do the following, if the GroupHeader field text equals 'Likely Cause' it should display in Red 'Possible Cause' it should display in Amber 'Unlikely Cause' it should display in GreenPlease can I be provided with a guiding hand in how to achieve this and more importantly where this should be done Thanks in advance. Regards John

Hi Christina You are a star! Thank you very much for the quick response; hours of pulling my hair has been resolved within minutes! Thank you again! John

Dear All I am very new to JasperReports, so I please be kind to me.... :-) Would someone be kind enough to provide me with a helping hand for my jasper question. Question: I wish for a a Report Group Header to be 'hidden' (I think, that is with Band Height=0) if the database field retrieved is a NULL otherwise set the Band Height to say 40. In which location of the XML is thecode be written Please do help a fellow techy :-) Thank you very much in advance. Regards JS