Well, there are a couple of different ways to do it.

1) YOu could certainly do it with Print Whens, but it would complicate your calculations (if any)

2) You could SELECT three child cursors with the appropriate records and set an appropriate relation between the "real" table and each of the three children, each of which has only records of the relevant type. Set the target alias of each band to an expression representing the alias of each cursor.

The second is probably the more appropriate way, since multiple detail bands work really well with multiple children of the same parent -- this is the "data problem" they were created to solve in the first place <g>.

HTH,

>L<