QueenArtemis

Can figure out why my gauge is showing more than one dial when the query results are only one row. <fw:angularGauge xmlns:fw="http://jaspersoft.com/fusion" xsi:schemaLocation="http://jaspersoft.com/fusion http://jaspersoft.com/schema/fusion.xsd"> <fw:widgetProperty name="showShadow"> <fw:propertyExpression><![CDATA[boolean.FALSE]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="animation"> <fw:propertyExpression><![CDATA[boolean.FALSE]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="upperLimit"> <fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="upperLimitDisplay"> <fw:propertyExpression><![CDATA["100"]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="lowerLimit"> <fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="lowerLimitDisplay"> <fw:propertyExpression><![CDATA["0"]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="showGaugeBorder"> <fw:propertyExpression><![CDATA[boolean.FALSE]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="gaugeBorderAlpha"> <fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="pivotBorderAlpha"> <fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="pivotFillAlpha"> <fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="bgColor"> <fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="borderColor"> <fw:propertyExpression><![CDATA[new java.awt.Color(-1)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="showBorder"> <fw:propertyExpression><![CDATA[boolean.TRUE]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="pivotFillColor"> <fw:propertyExpression><![CDATA[new java.awt.Color(-16777216)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="pivotFillAngle"> <fw:propertyExpression><![CDATA[new Integer(2)]]></fw:propertyExpression> </fw:widgetProperty> <fw:colorRange color="#2CC059"> <fw:minValueExpression><![CDATA[1]]></fw:minValueExpression> <fw:maxValueExpression><![CDATA[36]]></fw:maxValueExpression> <fw:labelExpression><![CDATA[$R{LowKey}]]></fw:labelExpression> </fw:colorRange> <fw:colorRange color="#FFCA1D"> <fw:minValueExpression><![CDATA[37]]></fw:minValueExpression> <fw:maxValueExpression><![CDATA[80]]></fw:maxValueExpression> <fw:labelExpression><![CDATA[$R{MediumKey}]]></fw:labelExpression> </fw:colorRange> <fw:colorRange color="#F43228"> <fw:minValueExpression><![CDATA[81]]></fw:minValueExpression> <fw:maxValueExpression><![CDATA[300]]></fw:maxValueExpression> <fw:labelExpression><![CDATA[$R{HighKey}]]></fw:labelExpression> </fw:colorRange> <dataset/> <fw:dial> <fw:dialProperty name="borderColor"> <fw:propertyExpression><![CDATA[new java.awt.Color(-16777216)]]></fw:propertyExpression> </fw:dialProperty> <fw:dialProperty name="bgColor"> <fw:propertyExpression><![CDATA[new java.awt.Color(-16777216)]]></fw:propertyExpression> </fw:dialProperty> <fw:valueExpression><![CDATA[$F{OVERALL_HEALTH}]]></fw:valueExpression> </fw:dial> </fw:angularGauge>[/code]I have added this to a group footer. Any ideas would be greatly appreciated. What should i be checking ?

figured it out...

Hello Friends, How do i change the startDayOfWeek or endDayOfWeek in an expression, since i believe the only way to change this is by a function, or parameter? however, i am not sure...? When i don't have access nor can have access to change the server setting. We cannot change the server setting since it's multi-client(s) server. in WEB-INF/classes/relativedate.properties I use this and its perfect, However, based on my local/timezone information, my start date is starting on Monday (1) and i need Sunday (0). I don't know how to set this. Is it set in the start and end date parameters? <parameter name="weekStartDate" class="net.sf.jasperreports.types.date.DateRange" isForPrompting="false"><parameterDescription><![CDATA[Week Start Date]]></parameterDescription><defaultValueExpression><![CDATA[new net.sf.jasperreports.types.date.DateRangeBuilder("WEEK-1").toDateRange()]]></defaultValueExpression></parameter><parameter name="startDate" class="java.util.Date"><parameterDescription><![CDATA[start Date]]></parameterDescription><defaultValueExpression><![CDATA[$P{weekStartDate}.getStart()]]></defaultValueExpression></parameter> Thanks,

Okay, so here it goes. Using Jaspersoft Sudio Pro 6.2.1. Oracle DB. I need some help on how to use a parameter that contains wildcard. In my query, i have values in a column that could contain multiple values. 1 single row containing multi values in the columns. i need to create a parameter (multi select) to get these values. if i use: AND portfolio.code LIKE '%pro_other%' within the query, this works perfectly. it will return the correct results with pro_other and then those rows that contain %pro_other%. Now, I tried to make the parameter within the jrxml: AND $X{IN, portfolio.code, portfolioKey_1} This works, however, it will only give me the specific values that ONLY have "pro_other" in the values. I have tried this: AND portfolio.code IS NULL OR portfolio.code LIKE '%' || '$P!{portfolioKey_1}' || '%' and this gives me the error: java.sql.SQLException: Execute Query fail.Execute Query fail.Invalid column index My parameter is java.util.Collection Anyone have any ideas, i would be so very grateful. Sincerely, Keri

N00b quiestion here, I am new to using Jaspersoft with CA PPM. I am trying to default some parameters that are passed. one of the parameters is called 'ppmUserUITheme' I have managed to get the other parameters to pass, however, i am getting an error on this particular one. Error: net.sf.jasperreports.engine.JRException: Byte data not found at : repo:/ca_ppm/templates/reportStyleTemplate_ca_ppm_defaultat com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:468)at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:443)at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:335)at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)Caused by: net.sf.jasperreports.engine.JRException: Byte data not found at : repo:/ca_ppm/templates/reportStyleTemplate_ca_ppm_defaultat net.sf.jasperreports.repo.RepositoryUtil.getBytesFromLocation(RepositoryUtil.java:196)at net.sf.jasperreports.engine.xml.JRXmlTemplateLoader.loadTemplate(JRXmlTemplateLoader.java:110)at net.sf.jasperreports.engine.fill.JRFillReportTemplate.loadTemplate(JRFillReportTemplate.java:109)at net.sf.jasperreports.engine.fill.JRFillReportTemplate.evaluate(JRFillReportTemplate.java:87)at net.sf.jasperreports.engine.fill.JRBaseFiller.collectTemplates(JRBaseFiller.java:1114)at net.sf.jasperreports.engine.fill.JRBaseFiller.collectTemplateStyles(JRBaseFiller.java:1137)at net.sf.jasperreports.engine.fill.JRBaseFiller.collectStyles(JRBaseFiller.java:1085)at net.sf.jasperreports.engine.fill.JRBaseFiller.loadStyles(JRBaseFiller.java:1054)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:933)at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120)at java.lang.Thread.run(Unknown Source) I can see this in the Source tab and where the param is set.<template><![CDATA["repo:/ca_ppm/templates/reportStyleTemplate_" + $P{ppmUserUITheme}]]></template> <parameter name="ppmUserUITheme" class="java.lang.String" isForPrompting="false"><parameterDescription><![CDATA[uI Theme]]></parameterDescription><defaultValueExpression><![CDATA["ca_ppm_default"]]></defaultValueExpression></parameter> I am not sure what else to check here, any ideas? thanks, Keri