Jump to content
Changes to the Jaspersoft community edition download ×

Crosstab data doesn't render- Blank


chetan_33

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

  • 3 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...