Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
'DynamicFormatting' of grid columns
To all,
I've got a grid that's displaying highly reduced data. I've got it to the point that it looks almost exactly like its corresponding hard-copy report, including blank space (empty rows). To get this effect I had to format the columns with:
MyGrid.Column1.FORMAT = 'Z 99,999,999,999'
My users have come back and said they want to see zeros where there are zero values. If I remove the 'Z' format code, they'll get zeros everywhere.
The cursor driving the grid has two fields HeaderRow and HiLiteRow, which are logicals that are used to drive the DynmaicBackColor of the columns. I want to use these fields to dynamically format the cells; If its a HeaderRow or HiLiteRow, suppress zeros, otherwise show zeros.
I tried:
MyGrid.Column1.FORMAT = "IIF(PdaGrid.HeaderRow .OR. PdaGrid.HiLiteRow, 'Z 999', '99,999,999,999')"
with disasterous results.
Any suggestions?
TIA
Thom C.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement