Browndog
-
Posts
9 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by Browndog
-
-
Perfect thanks
-
Hi
I'm using a crosstab that has 2 column groups I would like the first group to span the full width of the cell, since the second coloum is sometimes 2 cells wide, the text in the top column group will stop after only 1 cell wide instead of spanning accross the full width of the cell. I've attached a image to show what I mean.
Thanks
Post Edited by Browndog at 08/13/2009 04:55 -
Yes thanks I understand now and I've found a way to get the desired result.
Post Edited by Greg Brown at 01/30/09 04:11 -
I've got an idea on how to do this but I cant make it work.
I now what it so when the leaveCode = A/L the cell is green and S/L the cell is yellow
In the <crosstabCell> I want the color to change I add a <rectangle> and I use the <printWhenExpression> tag and different colored.
The problem I get is "Field not found : leaveCode" it seems the leaveCode field is not avaliable within the crosstab cell, is there a way around this?
Code: <crosstabCell width="50" height="25"> <cellContents> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <rectangle> <reportElement mode="Opaque" x="0" y="0" width="50" height="25" backcolor="#FF0000"> <printWhenExpression><![CDATA[new Boolean( $F{leaveCode}.equals("A/L")]]></printWhenExpression> </reportElement> </rectangle> <rectangle> <reportElement mode="Opaque" x="0" y="0" width="50" height="25" backcolor="#00FF00"> <printWhenExpression><![CDATA[new Boolean( $F{leaveCode}.equals("S/L") )]]></printWhenExpression> </reportElement> </rectangle> <textField hyperlinkType="None"> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression class="java.lang.Double"><![CDATA[$V{hoursMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell>
-
Hi,
I'm trying to change the color of a crosstab cell based on the cell content i.e. if the cell content is 1 I want the cell to be red, 2 blue, 3 green etc... Anyone got any ideas on how to do this?
Greg
-
I have this query
SELECT employee_no, numHoles*3.9 AS devMeters, (splitSets1400mm*1.4) AS gsMeters,
date
FROM shiftReport
WHERE employee_no = '1116'
I'm trying to get a stacked bar chart that shows devMeters and gsMeters stacked one of top of the other. How do I get these 2 to stack? Somthing like this:
Post edited by: Browndog, at: 2008/04/15 00:28
-
Yeah I tried that but it seems it runs the query before it assigns the default value to the parameter. I'm now running the query in my swing app and passing on the resultset. The only disadvantage I can see in this is; I'm using netbeans plugin and I can't use the preview with this method. But otherwise I'm happy :).
-
How do I use values from REPORT_PARAMETERS_MAP SQL in an sql query?
This is what I want to do:
<queryString>
<![CDATA[sELECT *
FROM shiftReport
WHERE shiftDate = $P{REPORT_PARAMETERS_MAP}.get("startDate")
]]>
</queryString>
Is there a way this can be done?
I tried to assign a variable to this value then put the varible in the query, but it seems to me that the query is being run before the variable has been assigned.
Displaying a jasperreport on a jpanel
in Products
Posted
Is it possible to embed a report into a java app? I want to display a report in a jpanel.