Month To Date Report

[robcarr]

Dear All,

This is my first post in this forum and I am learning BO as I go along, I have created a report and I currently have to enter in the start date and end date of the report, is there a way to automatically set the start date to the 1st of the current month and the end date to yesterdays date, so when the report is scheduled to run, it will always show the most upto date data for the month.

Also how do I go about setting the report up to run daily and send it to myself.

Thanks

Thanks Rob.

 

[BrianTyler]

Rob,

You always have to be careful with this sort of report, as thigs go wrong when months start on Sundays etc.

I suggest you build objects into your universe to identify the first day of the current month and the previous month.

The syntax used will vary depending on the underlying databases.

In DB2, the first day of this month is:
(current date + 1 days - day(current date) days)

The first day of last month is
(current date - 1 month + 1 days - day(current date - 1 month) days)

 

[blom0344]

For those type of prompts look into predefined prompts that one can create as universe objects (by incorporating database functions and such).

You would need Broadcast Agent for scheduling and sending reports the way you want

T. Blom
Information analyst
tbl@shimano-eu.com

 

[DrSmyth]

Unless of course you know a bit of VBA in which case you can replicate many of the Broadcast Agent functions.