Replace infinity symbol with space

Replace infinity symbol with space

Posted by: bigchris on 27 September 2017, 9:13 pm EST

• 

  bigchris

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 September 2017, 9:13 pm EST

  Hi,

  I’m very new in using C1 FlexReport (v4.0.20171.248) and I’m in the process of converting 100’s of reports from another third party report designer. The other designer has an option in their formatting options for numbers which is “suppress is not a number”; which is basically a way to prevent errors from divide by zero. It seems in FlexReport that it shows the infinity symbol when this situation occurs - is there any way that I can get it, to NOT show the infinity symbol - as our users are more used to seeing a blank/space than the symbol ?

  Cheers,

  Chris.

• 

  sonu-pachaharagmail-com

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 9:13 pm EST

  Hi,
  
  For achieving your requirement, you need to write script on the OnFormat or OnPrint property of the related section in which your field is placed.

  
  'Based on data base field
  If [DbField] = 0 Then 
  Field1.Text=""
  Else
  Field1.Text=100/DbField
  EndIf
  
  

  Please see the attached image for complete implementation.
  
  Hope, it clarifies.

  Thanks,
  
  Sonu
  
  

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 24 May 2019, 10:08 pm EST

  Dear Sir/Mam,

  I have problems with flexgrid as follows:

  1. want to show blank string for all zero values in bound flexgrid. how can I do ? please suggest.

  2. how to set row.IsNode=true and row.Node.Level=0,1,2… in bound mode ? It’s not allowed in bound mode. kindly suggest…

  Best Regards-
  
  Sanjeeb