Wednesday, 13 February 2013

Hide show field on text value Crystal Reports

Need to suppress a  field in Crystal Reports when  a filed contains  part of some text  like

"Get some Text"  and you need to suppress the field when it says "text" then in the field to be suppressed

  1. goto format text
  2. check suppress
  3. Click  x-s
  4.  add  InStr ({field name},'text' )>0 
This will hide show the field when "text" is present

if there is more then one line say in the body then add 
or
InStr (previous ({filed name}),'text' )>0


Change the 0 to 1 or -1 as appropriate to hide or show depending on what match is made by instr()







No comments:

Post a Comment

Chrome 138 the last supported

Chrome 138 the last supported  Hey Everyone, Chrome 138 is the last version of Chrome that will support Android 8.0 (Oreo) and Android 9.0 (...