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

Passwords Made Easy

Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...