Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying meaningful messages when running report

Status
Not open for further replies.

dospx

IS-IT--Management
Dec 31, 2015
1
US
Gurus.

I believe this must be pretty common requirement across projects. I want to display a meaningful message when the report is run. Here is the scenario for e.g. My data load for the last night failed for whatever reason and as a result the data marts doesn't have the yesterday's data. Let's take a scenario that one of the user is running the daily summary query for date between today and beginning of month. Considering that the report is still meaningful for aggregate data for each day except the missing data from yesterday, I would like to run the report but also show the message that the data is not current before the report in run.

Please let me know the most effective way to achieve this. I have thought about a couple of options but not sure if those are the most efficient ones. Would like to hear from you as how you would address this efficiently?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top