Textbox format in report

[Danilo Lopez]

Hi everyone am new in this  greate  forum .. =)  .. am from chile  and   i  work with telerik controls and reports .
i write  because  need a little help..
i create a report     its fills whit a store procedure  . ...  now . in the report   i have a  textbox formated  currency  .. whit  2 decimals ($222,00)
 but  in some cases  i dont want that  , i just need   a  0 decimals  ($222)  ..        i try passing  a value from store procedure and set the format value like this        format : =Fields.[format ]   . .. in store procedure  'format '  is   {0:C2}       but  dont work.

there is some way to set dynamically  the  format value     ? .. 

thanks    !
 

[Joel]

I know it is not the answer you are looking for, but we modify the stored procedure here to do the formatting and send as varchar how we want it displayed when we use variably formatted fields like this.  It just seems to be easier in the end.

[Danilo Lopez]

I thought the same thing  .. but finaly   i found other way


 make 2 panels      visible false .  

in the first   i add    textbox ( 0 decimals)  format  ,  and the another panel   textbox  whith  2 decimals format 



and   use  conditionalformating   to  decide who show the value      by the procedure