Figuring out if a week is missing 1

[gogopoppy]

Hi there,

I have a report which has a list of pay periods for my employees. Its just a list report with no groups.

The data looks like this

Joe 1/1/2009
JOe 8/1/2009
JOe 15/1/2009

Some pay periods (i.e. certain weeks) are missing and I'd like to have it say missed after the record where the pay period is missed.

I need some help with this formula.

Any help/tips would be greatly appreciated

Tx


G

 

[lbass]

You could insert another detail section and format it to "suppress blank section". Create a formula {@week}:

datepart("ww",{table.date})

Then place this formula in detail_a (and put your other fields in detail_b):

if
(
onfirstrecord or
{table.groupfield} <> previous({table.groupfield})
) then "" else
if {@week} <> previous({@week}) + 1 then
"Missed"

-LB

 

[gogopoppy]

Perfecto!!

G