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

Samsung Android Keyboard

  If you have a Samsung phone or pad and the keyboard is set to Google give the Samsung one a try. Just go into the keyboard settings and ...