I was hoping that someone might have run into this recently.  I've still not found a solution.

Thanks!

Is it possible that James Smith was inserted or updated after you created the index?  FILLFACTOR = 100 means that all of your indexing capability was used up when you...

I'm unpleasantly surprised, since this appears to be a basic concept in Informix and Oracle. 

Can it be simulated, perhaps by turning off particular named constraints, then turning them back...

Thanks for the reply!  It put me on the right track for solving it -- though I ended up using the iif on the format rather than the expression itself.

=IIF...

What happens when you preview the reports in the builder?  What about print-preview?