Topic: Suppress matching records Posted: 14 Jul 2014 at 9:57am
CR 10 Pro, SQL 2008 database
How do I configure the formula below to ignore certain matching records (tblsolog.logreason = bereavement or workers comp) but print everything else?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 23 Jul 2014 at 5:47am
why not in the object format, conditionally suppress it with logic like:
{tblsolog.logreason}="bereavement" or
{tblsolog.logreason}="workers comp"
or if this is the only item on the line, you could suppress the whole section in Section Expert.
The hard part is altering any aggregates like AVG or SUM as they probably shouldn't contain values that are not displayed.
For that you would need a running total (not my baliwick...DBlanks) or used shared variables to keep track of the values that you want/need for your aggregates. In which case you would alter your above logic to not add the the hours and minutes to some total.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum