As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
Assuming that the metrics are coming from different data sources. Create a report for each condition or metric that outputs a single record with a link to the detailed version of that metric.
Then create a single report that INCLUDEs those reports.
Then create a view with a two blocks, the left side will contain the single report and the right side will display the output of a selected link.
The single report, when run, will in turn run the INCLUDEd reports. If the filters in those reports return records, the links will display otherwise nothing will appear.
Most people will not want that, so you'll put a little HTML in those alert reports to display something meaningful, no link but a message. Maybe something like "No Merchants Trrited" or "Credit Volume < Debit Volume for Europe".
Once I created a table for our HR group, they used MS Access and typed in messages using with links to documents in a public folder. There was a field for began publish and end publish. I used the above idea to provide an announcement page on our dashboard. It worked pretty well and it was easy to set up. Actually they still use it. I set that up in 2005, took about two hours. Great ROI on that one.This message has been edited. Last edited by: Don Garland,