Community
Participate
Working Groups
this.style can be used only for single column, - this is not working for html text with an expression such as <value-of format="###,###,###.00"> row["AMOUNT"] </VALUE-OF> NOW THE NUMERIC FORMAT WILL BE AVAILABLE AS A PARAMETER SUCH AS params["NumericFormat"] when i write the script in oncreate <value-of format=params["NumericFormat"]> row["AMOUNT"] </VALUE-OF> this does not seems to work. The formating is ignored. Is there any workaround? regards
what's the data type of row["amount"]? Is it a number?
what's the data type of row["amount"]? Is it a number? Yes , number
Could you attach the report designs which working and not? Thanks.
The issue is for expressions, i am not able to change numeric format as detailed below <value-of format=params["NumericFormat"]> row["AMOUNT"] </VALUE-OF> other it is fine
could we support this feature as: <value-of format-expr="params["NumericFormat"]"> row["AMOUNT"] </VALUE-OF> the format-expr defines a expression and the result is used as the format pattern. The "format" property will overide the format-expr.
This will add lot of value , since in most cases we need to provide expressions (Total.sum) etc . Currently the only alternative is to use data instad of Total.sum and get the formating done. RThis is bit lenghtly. esplly. when there are more sub totals (grouping) If we can provide <value-of format-expr="params["NumericFormat"]"> row["AMOUNT"] </VALUE-OF> like this , it will add value since the formating can be controlled using a parameter Thks
<value-of format-expr="params["NumericFormat"]"> row["AMOUNT"] </VALUE-OF> the format-expr defines a expression and the result is used as the format pattern. The "format" property will overide the format-expr. This may be better way to format numeric and also ddate expressions
Add attribute ¡°format-expr¡± to support specifying format by script.
Fixed.
I have submitted a enhancement to support this new attribute in Dynamic Text of Text Item in designer. Please refer to enhancement #261310.
I have tried following cases, for example: by parameter expression: <VALUE-OF format-expr='params["format"]'>1234</VALUE-OF> by constant <VALUE-OF format-expr='"Fixed"'>1234</VALUE-OF> by script StringFormat= "@@@-@@@" <VALUE-OF format-expr=StringFormat>Hello</VALUE-OF> by column binding script <VALUE-OF format-expr='row["Format"]'>1234</VALUE-OF> They worked in 2.5.0 v20090119-0630 build. I will track the UI enhancement for this new attribute and some related bugs of using invalid expression. Mark this bug as verified first.