Conditional Styles in a CrossTab

[mdares]

Hello,

 

I am trying to conditionally color a column depending on whether the date represented is a weekend or not. I have created the following style at the top of my jrxml:

 

Code:

	<style name="Weekend" isDefault="false" mode="Opaque" backcolor="#80FF80">
		<conditionalStyle>
			<conditionExpression><![CDATA[new Boolean(....utils.DateUtil.isWeekend($F{entryDate}))]]></conditionExpression>
			<style isDefault="false" style="Weekend" backcolor="#80FFFF"/>
		</conditionalStyle>
	</style>

 

I have a dataset used by this crosstab defined as such:

 

 

Code:

[code] <subDataset name="Vacation"> <field name="costingCode" class="java.lang.Object"> <fieldDescription><![CDATA[costingCode]]></fieldDescription> </field> <field name="entryDate" class="java.util.Date"> <fieldDescription><![CDATA[entryDate]]></fieldDescription> </field> <field name="hours" class="java.lang.Float"> <fieldDescription><![CDATA[hours]]></fieldDescription> </field> <field name="task" class="java.lang.Object"> <fieldDescription><![CDATA[task]]></fieldDescription> </field> <filterExpression><![CDATA[new Boolean(((....pojos.CostingCode)$F{costingCode}).getCostingCodeType()==1)]]></filterExpression> </subDataset>

 

The other places I use the entryDate field within the crosstab work fine but when I try and apply this style I get the error:

 

Code:

[code] net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. Field not found : entryDate

 

This led me to believe the scope of the field defination may need to be greater than the subdataset and I tried defining the entryDate field directly under the <jasperReport>, but to no avail.

 

Any help would be appreciated - I think that this must be a simple mistake on my part. The report works fine until I apply this style.

 

Matthew Dares

[lucianc]

Using dataset fields in crosstab conditional styles does not work because it doesn't make sense.

 

Imagine the following scenario: you have a entryDate field in the dataset and you group dataset records in the crosstab per entryDate year. Now if you would use a conditional style that depends on entryDate for the crosstab group header, to what value would entryDate evaluate in the condition expression? A crosstab group/bucket corresponds to many dataset entryDate values. Therefore you can only use the bucket value (via the crosstab variable created for the group) in conditional style expressions.

 

Another scenario: you have a hours field in the dataset and you create a crosstab measure that sums this field per year/task/etc. You cannot use a conditional style that depends on the hours field for a crosstab data cell since, again, a data cell accumulates data for many dataset records. You can only use the accumulated measure value (again via the crosstab variable created for the measure).

 

HTH,

Lucian

[tunguyen]

I understand the reason why a bucket header can only be the value of the bucket expression.  However, there is a valid case where I wanted to display something other than the bucket expression value.  For example, one of my buckets is the sum of items for the week, and the bucket expression is formatted as "yyyy-ww".  Now, I wanted to print the date at the start of the week (e.g., "10-19-2008"), instead of the value "2008-42".   Or if I wanted to display a more descriptive text instead of "2008-42" as in the week number of the year. 

The way it is, the group header cannot be anything other than the bucket expression value.

[tunguyen]

OK, I finally figured it out that I can use a custom Java class to get to the Sunday (start of the week) of the date in question, and print out the date of that Sunday, instead of printing out the week number of the year.  If anyone has questions on how to do this, contact me.