Jasper horizontal bar chart data overflowing

Question

I have created a jasper report with following xml,



    
    
    
    
        
            
        
        
            
        
        
            3 and status <> 'Cancelled' and (trunc(nvl(i.initiated_on,$P{start_date})) between to_char(to_date($P{start_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy') and to_char(to_date($P{end_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy'))
union
 select  decode(inc.incident_category,1,'Actual Incident',2,'Near Hit')
 ,count(inc.incident_id) as cnt
 from ms_icm_incident inc
 where inc.incident_category <>3 and inc.status<>'Cancelled'
 and (trunc(nvl(inc.initiated_on,$P{start_date})) between to_char(to_date($P{start_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy') and to_char(to_date($P{end_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy'))
 group by inc.incident_category
 union
 SELECT decode(lov.STORED_VALUE,1,'Actual Incident',2,'Near Hit') as incident_category, 0 as cnt
 FROM ms_local_lov_t lov
 WHERE LOV_NAME='MS_ICM_CATEGORY' and lov.STORED_VALUE <>3
 and lov.STORED_VALUE not in (select  inc.incident_category
 from ms_icm_incident inc
 where inc.incident_category <>3 and inc.status<>'Cancelled'
 and (trunc(nvl(inc.initiated_on,$P{start_date})) between to_char(to_date($P{start_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy') and to_char(to_date($P{end_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy'))))
 order by decode(category,'Total',1 )]]>
        
        
        
    
    
        
            
        
        
            
        
        
            3 and POTENTIAL_SEVERITY_CALCULATED is not null and status <> 'Cancelled' and(trunc(nvl(initiated_on,$P{start_date})) between to_char(to_date($P{start_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy') and to_char(to_date($P{end_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy'))
                                           group by POTENTIAL_SEVERITY_CALCULATED)
dual group by severity
order by decode(severity,'High',1,'Medium',2,'Low',3)]]>
        
        
        
    
    
        
            
        
        
            
        
        
            3 and (trunc(nvl(initiated_on,$P{start_date})) between to_char(to_date($P{start_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy') and to_char(to_date($P{end_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy'))and status <> 'Cancelled'
group by status
union
select  status, cnt from (select distinct status,0 as cnt from ms_icm_flow_action_status
                                  union
                                  select 'Closed',0 as cnt from dual) where STATUS NOT IN
(select  status from ms_icm_incident
where incident_category<>3 and (trunc(nvl(initiated_on,$P{start_date})) between to_char(to_date($P{start_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy') and to_char(to_date($P{end_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy'))and status <> 'Cancelled'
group by status)and status not in ( 'Cancelled','OHS Investigating','Initiating Incident')
)
order by decode (status,
'Initiated',1,
'Initiated -  Need More Info',2,
'Preliminary',3,
'Investigating',4,
'Draft Report Review',5,
'Final Report Review',6,
'Re-Investigating',7,
'Final',8,
'Closed',9,
'Completed',10)]]>
        
        
        
    
    
        
    
    
        
    
    
        3 and (trunc(nvl(i.initiated_on,$P{start_date})) between to_char(to_date($P{start_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy') and to_char(to_date($P{end_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy'))
union
select (SELECT lov.DISPLAYED_VALUE
 FROM ms_local_lov_t lov
 WHERE lov.STORED_VALUE=i.incident_category
 and LOV_NAME='MS_ICM_CATEGORY')as category, count(*) from ms_icm_incident i
 where incident_category<>3 and (trunc(nvl(i.initiated_on,$P{start_date})) between to_char(to_date($P{start_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy') and to_char(to_date($P{end_date},'mm/dd/yyyy HH24:MI:SS'),'dd-MON-yyyy'))
 group by incident_category]]>

Now i am getting the chart as overflown,i have changed the following properties,

Set "Position" to "Float" Set "Stretch Type" to "Relative to the tallest object" Checked "Print when detail overflows" checkbox. But still no help.

my Jasper version is 4.5.0

Please assist.

Bhanu · Accepted Answer

Try Putting isPrintWhenDetailOverflows="true" inside every reportElement tag you are using. You have put this in only one of your tag.
Through this the element will be reprinted on the next page if the band does not fit in the current page.

Jasper horizontal bar chart data overflowing

Answers (1)

Related Questions