This is a migrated thread and some comments may be shown as answers.

Currency Format on textbox not working

2 Answers 1355 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Brant
Top achievements
Rank 1
Brant asked on 19 Dec 2008, 04:21 PM
I am having a very stupid problem.  I have a linetotal field on a report that is databound from a field in a table that is of currency data type.  It is showing on the telerik report as non currency.  No matter how I try to set the format of that textbox to currency "Format("{0:C2}",=fields.linetotal) or just setting the format property to currency, it will not work.  What am I missing here?

2 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 20 Dec 2008, 04:36 PM
Hello Brant,

We were not able to reproduce such a problem on our end. In fact the Product Catalog report from our online examples has a few fields that are of data type money and are properly formatted through the format property {0:C2}.

All the best,
Steve
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Charles
Top achievements
Rank 1
answered on 09 Jul 2013, 07:08 PM
I know this is really old but I was having the same issue and this was the first article I found so I figured I would post this here

Originally I was using this as my field value:
{SUM(IIF(Fields.[myFieldName1] > Now(), Fields.[myFieldName2], 0))}
I changed it to:
=SUM(IIF(Fields.[myFieldName1] > Now(), Fields.[myFieldName2], 0))
Now it works, I need to take a look at the documentation to verify this but I'm guessing it didn't work because { } means string to the API. 

Hopefully this will help others getting started with Telerik.
NICHOLE
Top achievements
Rank 1
commented on 17 Jun 2022, 04:30 PM

Super helpful! Thank you!
Tags
General Discussions
Asked by
Brant
Top achievements
Rank 1
Answers by
Steve
Telerik team
Charles
Top achievements
Rank 1
Share this question
or