jkushmerick

Hi, I have a bullet chart setup in Jaspersoft Studio Pro Edition and I would like to have it so the plot background displays different colors based on the range, something like the following : "Low" 0-25 will be Red "Medium" 26-75 will be Yellow "High" 76-100 will be Green I've defined color ranges in the properties setup as outlined above, but the entire chart plot background shows as Green and I can't figure out why it's not showing all 3 colors. The source code for the color range is as follows : <fw:colorRange color="#F70A1A"> <fw:minValueExpression><![CDATA[new Integer(0)]]></fw:minValueExpression> <fw:maxValueExpression><![CDATA[new Integer(25)]]></fw:maxValueExpression> <fw:labelExpression><![CDATA["Low"]]></fw:labelExpression> </fw:colorRange> <fw:colorRange color="#FFFB03"> <fw:minValueExpression><![CDATA[new Integer(26)]]></fw:minValueExpression> <fw:maxValueExpression><![CDATA[new Integer(75)]]></fw:maxValueExpression> <fw:labelExpression><![CDATA["Medium"]]></fw:labelExpression> </fw:colorRange> <fw:colorRange color="#05FF1A"> <fw:minValueExpression><![CDATA[new Integer(76)]]></fw:minValueExpression> <fw:maxValueExpression><![CDATA[new Integer(100)]]></fw:maxValueExpression> <fw:labelExpression><![CDATA["High"]]></fw:labelExpression> </fw:colorRange> Just in case the entire chart properties are needed, here they are : <componentElement> <reportElement x="0" y="0" width="800" height="120" uuid="11a00016-c22b-40d6-b217-0eb278bbc8b1"/> <fw:horizontalBullet xmlns:fw="http://jaspersoft.com/fusion" xsi:schemaLocation="http://jaspersoft.com/fusion http://jaspersoft.com/schema/fusion.xsd"> <fw:widgetProperty name="targetThickness"> <fw:propertyExpression><![CDATA[new Integer(5)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="plotFillAlpha"> <fw:propertyExpression><![CDATA[new Integer(100)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="showPlotBorder"> <fw:propertyExpression><![CDATA[boolean.TRUE]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="plotBorderThickness"> <fw:propertyExpression><![CDATA[new Integer(2)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="numberPrefix"> <fw:propertyExpression><![CDATA["$"]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="caption"> <fw:propertyExpression><![CDATA["Current Month PPC Spend"]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="subCaption"> <fw:propertyExpression><![CDATA["Actual vs Goal"]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="chartLeftMargin"> <fw:propertyExpression><![CDATA[new Integer(20)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="chartRightMargin"> <fw:propertyExpression><![CDATA[new Integer(20)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="alignCaptionWithCanvas"> <fw:propertyExpression><![CDATA[boolean.TRUE]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="captionPadding"> <fw:propertyExpression><![CDATA[new Integer(10)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="subCaptionFontBold"> <fw:propertyExpression><![CDATA[boolean.TRUE]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="subCaptionFontSize"> <fw:propertyExpression><![CDATA[new Integer(12)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="plotFillColor"> <fw:propertyExpression><![CDATA[new java.awt.Color(-13726222)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="showShadow"> <fw:propertyExpression><![CDATA[boolean.TRUE]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="plotFillPercent"> <fw:propertyExpression><![CDATA[new Integer(20)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="targetFillPercent"> <fw:propertyExpression><![CDATA[new Integer(40)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="lowerLimit"> <fw:propertyExpression><![CDATA[new Integer(0)]]></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[""]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="showLimits"> <fw:propertyExpression><![CDATA[boolean.TRUE]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="bgAngle"> <fw:propertyExpression><![CDATA[new Integer(20)]]></fw:propertyExpression> </fw:widgetProperty> <fw:widgetProperty name="bgColor"> <fw:propertyExpression><![CDATA[new java.awt.Color(-2563088)]]></fw:propertyExpression> </fw:widgetProperty> <dataset/> <fw:valueExpression><![CDATA[$F{TotalSpend}]]></fw:valueExpression> <fw:targetExpression><![CDATA[$F{GoalSpend}]]></fw:targetExpression> <fw:colorRange color="#F70A1A"> <fw:minValueExpression><![CDATA[new Integer(0)]]></fw:minValueExpression> <fw:maxValueExpression><![CDATA[new Integer(25)]]></fw:maxValueExpression> <fw:labelExpression><![CDATA["Low"]]></fw:labelExpression> </fw:colorRange> <fw:colorRange color="#FFFB03"> <fw:minValueExpression><![CDATA[new Integer(26)]]></fw:minValueExpression> <fw:maxValueExpression><![CDATA[new Integer(75)]]></fw:maxValueExpression> <fw:labelExpression><![CDATA["Medium"]]></fw:labelExpression> </fw:colorRange> <fw:colorRange color="#05FF1A"> <fw:minValueExpression><![CDATA[new Integer(76)]]></fw:minValueExpression> <fw:maxValueExpression><![CDATA[new Integer(100)]]></fw:maxValueExpression> <fw:labelExpression><![CDATA["High"]]></fw:labelExpression> </fw:colorRange> </fw:horizontalBullet> </componentElement> I assume that I'm missing something, but I cannot find any additional information in the documentation, and I've been unable to solve the issue with trial and error. I'd greatly appreciate any help that anyone can provide. Thanks in advance, John

Can anyone offer any help with this?

Hi, I have a requirement to create a report using Jaspersoft Studio where the report will have a graph and some graphics on the first sheet and then a table with anywhere from 10 to several thousand rows of data depending on the report parameters. I've created 2 individual report files that work as intended, with the first generating a 1-sheet report that shows the graph and the 2nd report showing the table on a single sheet (this is set to ignore pagination so that there aren't breaks between the pages and the table prints on a single sheet in Excel). The problem is when I try to combine both reports by creating sub-reports inside of a master report, I get 1 Excel sheet for every page... the ignore pagination on the table report is overridden. I've read through multiple forums and examples online, but cannot get this to produce a 2-sheet Excel file with the graph on the 1st sheet and the table (regardless of how many rows the table has) print on the 2nd sheet. It seems that the master report is overridding the sub-reports. any help would be greatly appreciated.