Display negative no's as DR in xBrowse [Solved]

[anserkk]

Friends,

How do I display a numeric column containing both positve and negative numbers as CR and DR (Credit and Debit)

For Eg

100.00 should be displayed as 100.00 CR
-200.00 should be displayed as 200.00 DR
0.00 (Zeroes as Blank)


Regards

Anser

[StefanHaupt]

Anser,

did you try the picture clause ?

Code: Select all  Expand view

PICTURE for  SAY

X  shows DB (Debit) after negative numbers
C  shows CR (Credit) after positive numbers
     


[anserkk]

Thakyou Stefan,

I tried the picture clause. Picture X did not work for me in xBrowse
I beleive it has to be a code block to evaluate whether the number is Negative or Positive or 0.00 and then apply the right Picture format.

When I tried PCITURE X it is displaying all as XXX.XX instead of the orginal no's.

My code

Code: Select all  Expand view

@ 0, 0 XBROWSE oBrw LINES CELL;
     COLUMNS 'NAME','OPENDATE','OPENINGBAL' ;
     HEADERS 'A/c Name','Op.Date','Op.Bal';
     PICTURES ,,'XXXXXX.XX';
     SIZE 210,oDlg:nHeight-35 PIXEL ;     
     OF oDlg ;
     ALIAS 'AcMaster_ACM'

[mmercado]

When I tried PCITURE X it is displaying all as XXX.XX instead of the orginal no's.

Hi Anser:

Try this:

PICTURE "@CXZ ######.##"

Regards.

Manuel Mercado

[anserkk]

PICTURE "@CXZ ######.##"

Regards.

Manuel Mercado

Thankyou Mr.Manuel Mercado

PICTURE "@CXZ ######.##" worked

Regards

Anser