BusinessObjects Board

Dynamic Report Variable: Last Full Months Sales

Hello Experts,

Goal: report variable creation which returns the sales for the last completed month

Notes:
-Report is scheduled to run the 10th of every month with data reported on from January 1 of the year through the 9th of the month
-Report variable needed is to isolate sales from the previous full month
Example: report ran for 1/1/2015-12/7/2015 and the report variable would need to return dates for 11/1/2015-111/30/2015.

The goal is to have this report continue to be automated, as I do not want to access the report every month to adjust a static report variable.

Thank you in advance!
Ross


rossbuckner (BOB member since 2012-09-04)

Ross,

This topic will probably help you:

Build relative dates and use these to restrict your queries. Schedule the report to run on the 10th. Similarly, you can add these date objects to your result objects and then use them in the report variables to present your date range.

Regards,
Mark