Scheduling Relative Start dates in Jaspersoft

[MARK TRAVERS]

In Business object reports we used to schedule reports e.g. Capacity vs. Booking Status by OBS using the relative start date of previous month.

 

In Jaspersoft there is not the option to choose relative start date. When scheduling the report in Jaspersoft a date has to be entered and from my understanding this will mean I have to manually change the date each month.

 

Has anyone managed to work around this for the OOTB reports in Jaspersoft?

 

Thanks

Mark

[Georg Schmid]

Hi Marc,

what you can do if you always want to select the current month is to change the input control to a customized one which just returns the current month, e.g. in oracle via sysdate.

Alternatively, you could change the OOTB report via the Jaspersoft studio and change the SQL so it uses the sysdate as a filter.

The best solution would be to use a new input control to allow the user (case statement in SQL) to choose whether the current date or the filtered date should be applied.

Regards

Georg

[MARK TRAVERS]

Thanks Georg,

 

Yes think this will be the way we need to go.

 

Its a shame that we are having to customise OOTB reports when they previously worked fine in Business Objects.

[System]

Hi mark.travers - Did GeorgSchmid2014's response help answer your question? If so please mark as Correct Answer. Thanks!

[Robert_Ensinger]

We can't afford to update all OOTB Jaspersoft reports. Technically, one can schedule a report. Functionally - this doesn't work. Please vote up Use relative Time Period filters in CA provided Jaspersoft reports.