Browndog

Is it possible to embed a report into a java app? I want to display a report in a jpanel.

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.