 |
Creating a report for outstanding items
Tip submitted by
Sui Chan
Level: Intermediate
Works with: Notes/Domino
Updated: 06/02/2003
Related link:
More Tips from LDD |
 |
If you want to create a report listing outstanding items, such as overdue to do tasks, consider adding a sorted column to a database view that contains a formula like the following to calculate the age in days of the document:
@Abs(@Integer((@Now - @Created) / (60 * 60 * 24)))
You may want to categorize the view into "30 and more days," "60 and more days," and "90 and more days" groups to enhance the display. To do that, use the following column formula:
@If(@Abs(@Integer((@Now - @Created) / (60 * 60 * 24))) >= 90;"90 and more days";@Abs(@Integer((@Now - @Created) / (60 * 60 * 24))) >= 60;"60 and more days";@Abs(@Integer((@Now - @Created) / (60 * 60 * 24))) >= 30;"30 and more days";"30 and less days")
Then select the option Type: Categorized on the Sorting tab of the Column Properties box. Select "Show twistie when row is expandable" in the Column Info tab of the Column Properties box.
Depending on the size of your view, you may want to improve its performance by creating an Age field on the form. Then create an agent that calculates the Age field on a periodic basis so that the @If function on the view column is more efficient. The following code can be used to create the agent:
@If(Age >= 90;"90 and more days";Age >= 60;"60 and more days";Age >= 30;"30 and more days";"30 and less days")
| SUBMIT YOUR TIPS! |
| We encourage you to send us your tips (You can also click the "Would you like to submit a tip?" graphic below.) Your tips can be anything you've discovered about any Lotus product. The most important thing is that your tip be interesting, useful, or handy. And be sure to include complete information about how your tip works. For ideas, take a look at our tip archives. If we publish your tip, we'll send you the IBM Redbooks Lotus Collection on CD. |
|
|
|