Ask Search:
Christopher TeachoutChristopher Teachout 

How to report on the most recent record

I created a custom object to store information that is usually updated monthly.  Normally I would just set the date range to CY Current Month to include the most recent record in my organization's monthly report but sometimes, like right now, the information isn't available yet to make a new record. Is there a way to automaticly retrieve the most recent record for a report or will I just need to make a note to do it manually?
Amber Neill BoazAmber Neill Boaz
I'm confused on the timing here.  If you run a report with Current Month you'll either get a record (ideal state) or not (isn't populated yet).
Are you looking for a notification that the record has been created and will appear in the report?
Christopher TeachoutChristopher Teachout
This report is part of a larger report that is given to our BoD. The information in this report is based on labor statistics which are released by the government. If new stats haven't been released for the month I need to include the most recent stats on the report.

I want to automate the reports that are generated for the BoD's report so that the office staff, who are very busy, don't have to worry about running the reports manually. I hope this clairifies my need.
Amber Neill BoazAmber Neill Boaz
Ah! That makes more sense!
If you set the date range on the report to be the last 45 days, you'd be sure to get only one record.  (This assumes that the data comes out roughly every 30 days.)
Christopher TeachoutChristopher Teachout
I think you are right, I use the 15th of the month as the standard date entered so 45 days should be just fine. Under normal cirumstances that should work but the State of Michigan hasn't released any information for this year yet. I guess I'll just have to keep my eye on it until they catch up. Thanks for the advice though, that should take care of the problem in the future.