Hiding fields in smartform

[Former Member]

Hi all

I am working on a smartform in which I have to display the fields RATING and CREATEDBY if OVERRIDDEN=yes otherwise hide them.I have to get this OVERRIDDEN value from the database table ZTLOANRATE.Please tell me the process.

Thanks

Regards

Giri

[Former Member]

HI,

use the IF statement in smartforms when u r printing.

<b>/: IF &ZTABLE-OVERRIDE& EQ 'YES'

PR &ZTABLE-FIELD1&,,&ZTABLE-RATING&,,&ZTABLE-CREATEDBY&,,&ZTABLE-FIELD2&

/: ELSE

PR &ZTABLE-FIELD1&,,,,,,&ZTABLE-FIELD2&

/: ENDIF.</b>

Regards

SAB

[Former Member]

insert a programming logic & write ur select query there

[Former Member]

HI

I wrote programming code but my doubt is how to hide the field names just like on screens if we want to hide a field then we use screen-invisible=1.just like this do we have any particular code to hide the fields in the smartform.

[Former Member]

While writing use <b>NO-DISPLAY</b> along with the write statement.

[Former Member]

Use the Conditions tab of your Text node.

Depending on how you are doing this, you could have two seperate Text Nodes, one that displays the fields and on that doesn't. In the Conditions Tab you would have one where Override = yes and one where Override = No.