Matrix Form

VeronicaS

Hi,

Is it possible to suppress the display of a line in a matrix box if all of the cells have a blank or zero value?

Thanks,
Veronica

kriki

In theory it is possible, but practically it close to impossible. Because to know all cells are blank, you need to calculate them all.
You also have to program some triggers on the form to show or not show the record. Or you have to create a temptable with all the values to show, but for doing that you first need to calculate all of them.

nunomaia

The easiest way it’s to use a temporary table, but performance will decrease a lot if you have a huge table in that temporary table.

VeronicaS

Many thanks for your replies. You've confirmed what I thought, that a temporary table is the best way, and that this could downgrade performance...

Veronica