[Display 5 pages on jasper]

Is it because this query only works with the current week and not deffered?

[Display 5 pages on jasper]

How do I print 5 pages. It renders sometimes a full month or even 4 days when i try the following dates and disregards the actual date range. The query is linked to Jasper and passes a date range as parameters

 

Actual Query

select e.employee_id,
       e.initials || ' ' || regexp_replace(e.surname, '([^()]*)', '') farm_manager,
       r.research_station_id,
       r.name,
       dr.attendance_date attendance_date
  from research_station r
  join employees e
    on (e.employee_id = r.farm_manager)
cross join (select ($P{Date_from} + rownum - 1) attendance_date
               from dual
             connect by level <= ($P{Date_from} - sysdate + 1)) dr
  join employee_jobs ej
    on (e.employee_id = ej.employee_id)
where r.research_station_id = $P{Research_Station_id}


What I have tried:

Test Query

select e.employee_id,       e.initials || ' ' || regexp_replace(e.surname, '([^()]*)', '') farm_manager,       r.research_station_id,       r.name,       dr.attendance_date attendance_date  from research_station r  join employees e on (e.employee_id = r.farm_manager) cross join (select (to_date('16032020','DDMMYYYY') + rownum - 1) attendance_date from dual  connect by level <= to_date('20032020','DDMMYYYY') - sysdate + 1) dr  join employee_jobs ej on (e.employee_id = ej.employee_id) where r.research_station_id = 2;[/code]

[Moving .git files from one folder to another]

There is a .jrxml file which is tracked using Sourcetree. I now need to move this file with its changes to a new folder and commit to Bitbucket. The status on Bitbucket needs to show as "MOVED" with the tracked changes of Sourcetree.My current doings show the file as added. 

 

Thanks.

[How to replace null value to other string words]

$F{Field} == null? $F{SQL SELECT} : $F{Another Field}

[Jfree Chart setMaximumBarWidth - Layout A4]

I currently have a chart with 27 bars 1displayed horizontally. I would like to set at least foreach bar a width of 1cm. I have tried many functions of the Barrenderer class e.g. setItemMargin() and setMaximumBarWidth() also in conjunction.

Currenly  the bars are being displayed as "very thin lines". How do I solve this situtation.

Please note that images are protected and for security reasons are saved on a file server. Please find link below:

 

https://ibb.co/zrR9Vgz

 

Thank you

Kind regards

 

[JFree Bar Chart]

I have created a bar chart using Jasper Studio. The bars currently are thin and and all have a different colour. How do I set each bar to a width of 1cm and all the same colour. Please view current image of the graph. Also herewith is my customizer class in which I created in Eclipse:

package Customizer

import org.jfree.chart.JFreeChart;

import net.sf.jasperreports.engine.JRChart;

import net.sf.jasperreports.engine.JRChartCustomizer;

public class CustomLegendList implements JRChartCustomizer

{

public void customize(JFreeChart chart, JRChart jrChart)

{

CategoryPlot cplot = (CategoryPlot)chart.getPlot(); cplot.setBackgroundPaint(SystemColor.inactiveCaption);//change background color //set bar chart color ((BarRenderer)cplot.getRenderer()).setBarPainter(new StandardBarPainter());

BarRenderer r = (BarRenderer)chart.getCategoryPlot().getRenderer();

r.setSeriesPaint(0, Color.blue);

}

}

 

[Jasper - Select first Item from group using Expressions]

I have  TextFields that displays a list of zones and stations i n a grid layout. The zones col has a list of zone names and station avg's. The stations col has a station name and station avg. A zone has many stations and not all stations has a avg.

How do I select one zone and display all stations that has readings only. I am using sql to create the query.