Clarity

Expand all | Collapse all

Scheduling Relative Start dates in Jaspersoft

Jump to Best Answer
  • 1.  Scheduling Relative Start dates in Jaspersoft

    Posted 06-20-2016 04:13 AM

    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



  • 2.  Re: Scheduling Relative Start dates in Jaspersoft
    Best Answer

    Posted 06-20-2016 08:39 AM

    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



  • 3.  Re: Scheduling Relative Start dates in Jaspersoft

    Posted 06-28-2016 09:52 AM

    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.



  • 4.  Re: Scheduling Relative Start dates in Jaspersoft

    Former Employee
    Posted 06-24-2016 06:00 PM

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



  • 5.  Re: Scheduling Relative Start dates in Jaspersoft

    Posted 07-19-2016 09:29 AM

    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.