Crosstab data doesn't render- Blank

[chetan_33]

Hi All,

 

I am using jasper and iReport1.2.5 and created a very simple crosstab on the same lines (& nearly same business model) of ShipmentsReport in jasper sample. But the data within crosstab is not being rendered. Its totally blank.

All the necessary parameter passing was done as in sample. I even tried to have data fetched in the subdata set without using parameters. But to no help. The only change is it is within a external grouping on organisation in main report whcih is working fine.

 

My sql query is pasted at end here

I wasnt able to attach a 250 KB doc (screen grabs with details of iReport ) and I can mail you if u need more information. You can zoom and see the details for helping me

 

Is this a bug in jasper/iReport??

I see Similar postings at

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&view=threaded&id=268&catid=8

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=189#189

 

##################

sub data set Query

 

SELECT

sapKna.Name1 as alias_STPartn_Name1, material.PHier2_Val, material.PHier3_Val, material.FAKD1, absUms.JAHR, absUms.MONAT,absUms.MENGE , absUms.EINHEIT, absUms.WERT,absUms.WAEHR

FROM

aduint.CUB_AbsUms absUms,

aduint.SAP_KNA1 sapKna,

aduint.ADIS_BW_MATERIAL material

WHERE

( cast(JAHR as numeric) >= (DATEPART(YYYY,CURRENT_TIMESTAMP)-4) ) AND

(

(absUms.PNRAG LIKE '%0000684465%') OR

(absUms.PNRAG LIKE '%0000001734%') OR

(absUms.PNRAG = $P{PARAM_subDataSet_PNRAG})

) AND

(

absUms.VKORG LIKE '%%' OR

absUms.VKORG = $P{PARAM_subDataSet_VKORG}

) AND

sapKna.KUNNR = absUms.PNRWE AND

material.MATNR = absUms.MATNR

order by alias_STPartn_Name1, absUms.PNRWE,material.PHier2, material.PHier3, material.FAKD1, absUms.JAHR, absUms.MONAT

######################

 

Post edited by: chetan_33, at: 2006/07/28 08:50

Post edited by: chetan_33, at: 2006/07/28 08:52

[lucianc]

Hi

 

This is a bug introduced in iReport 1.2.5:

http://jasperforge.org/sf/go/artf1474?nav=1

 

A workaround is to set the comptability level of iReport to 1.2.0. I don't know whether there is a better workaround.

 

Regards,

Lucian

[chetan_33]

Thanks lucianc

By changing to jasper 1.2.0 it now works

save my another day.

[iamrobert]

try to remove the following text in the jrxml file:

<incrementWhenExpression><![CDATA[]]></incrementWhenExpression>

[dkcy209]

another workaround:

 

>go to crosstab properties

>add the following lines in [increment When experession]

 

new Boolean(true)