cancel
Showing results for 
Search instead for 
Did you mean: 

How to get only Previous Month data in Report.

0 Kudos
8,270

Hi Experts,

Need your Help!

I am using Business Object XI, while creating report need to populate data only for Previous month.

As of now "Booked Date" is coming from years 2001 to till date but users want to populate data for those Flats booked previous month only.

This report is "Scheduled" BO report.

Please see the attached JPG file for your reference. Here I want to reflect only Aug 2015 data ( Aug, 1 2015 to Aug, 31 2015).

Please let me know how to get Previous month data in report.

Thanks

Sam

View Entire Topic
0 Kudos

DATA: vdate TYPE datum.

TRY.
CALL FUNCTION 'MONTH_PLUS_DETERMINE'
EXPORTING
months = -2
olddate = sy-datum
IMPORTING
newdate = vdate.
CATCH cx_root.
ENDTRY.

WRITE vdate.