Textbox format in report

3 posts, 0 answers
  1. Danilo Lopez
    Danilo Lopez avatar
    2 posts
    Member since:
    May 2010

    Posted 13 May 2010 Link to this post

    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    !
     

  2. Joel
    Joel avatar
    148 posts
    Member since:
    Oct 2006

    Posted 14 May 2010 Link to this post

    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.

  3. Danilo Lopez
    Danilo Lopez avatar
    2 posts
    Member since:
    May 2010

    Posted 14 May 2010 Link to this post

    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

     

Back to Top