|
Jul 28
2009
|
Nexonia Blog
|
Jul 28
2009
|
|
Jul 23
2009
|
|
May 28
2009
|
We've deployed two new functions for our "advanced column" capability in Report Designer. For expenses it's ${countDistinct(expenseReport.code)} and in timesheets it's ${countDistinct(concat(user.id, week.week))}. The key to doing these reports (other than asking us to do them for you...a two-minute exercise) is to create summary reports, categorize by User then add columns for the user's name and the advance field with the formula mentioned above.
If you want it broken down by week/month/quarter/year, we recommend a second column with no label but the same formula. Then after saving it re-open it and you'll be able to set the period breakdown to whatever you'd like.
All of this takes us two minutes to do for you, or you can do it yourself (maybe faster!). :-)
|
May 27
2009
|
