Displaying a negative value

[jeff alba]

I cannot seem to be able to display a negative value in the grid.  Is there something simple I am missing?

The field type is a numeric field in Sql Server 2000.


What I currently have:
<telerik:GridBoundColumn HeaderText="Total Amount Due" DataField="TOTAL_AMOUNT_DUE" DataFormatString="{0:c}">
</telerik:GridBoundColumn>

[Princy]

Hello Jeff,

You can use custom currency format to achieve this.

ASPX:

 <telerik:GridBoundColumn HeaderText="Total Amount Due" DataField="column1" DataFormatString="{0:$###,###.###}">
 </telerik:GridBoundColumn>

Thanks,
Princy.

[jeff alba]

Thanks for your reply.  Unfortunately that doesn't work.

I have also tried it in a GridNumericColumn and it does not show the value as negative. 

And yes, I am sure the value stored in the database is negative.

Any other suggestions?

[Radoslav]

Hi Jeff,

Could you please verify that the type of the TOTAL_AMOUNT_DUE column from your database is set to int.

Looking forward for your reply.

All the best,
Radoslav
the Telerik team