cancel
Showing results for 
Search instead for 
Did you mean: 

How to restrict data in particular column in smartform?

vimal
Active Participant
0 Kudos

Hi,

my requirement is that ,if field TYPE has value 'E' then it should print in first column else use third column to print in smartform.

Can i use Condition window for this ? if yes then how ?

Please explain.

Thanks.

Edited by: VimalSharma on Aug 12, 2011 1:09 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Vimal,

Also a give try with Alternative node. Using True and False for columns one and three.

BR

Dep

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Vimal,

Include a Program lines above text node FOR FIRST COLUMN.

if wa-component1 NE 'E'.

wa-component1 = space.

endif.

Include a Program lines above text node FOR THIRD COLUMN .

if wa-component1 EQ space.

wa-component3 = 'E'.

endif.

BR

Dep

Former Member
0 Kudos

Hi Vimal,

Do you want it in template or table ?.

BR

Dep

vimal
Active Participant
0 Kudos

hi,

Its a table and would like to have a particular column to be filled only if field TYPE = 'E'.

Thanks

former_member305388
Active Contributor
0 Kudos

Suresh has already suggested you the solution. That actually works. Did you try that?


I assume you use Smartforms. In that case you should have this Field in both these columns. In the first column you should have condition TYPE = 'E' and in third column you should have condition TYPE NE 'E'

Regards
Suresh

vimal
Active Participant
0 Kudos

I am not getting the suggested solution . can anybody explain?

Former Member
0 Kudos

Hi,

Inside the table,use the CONDITION TAB in your text.

this will work only if you have that field(TYPE E) in your workarea.

try with the condition WA_TYPE = E in the CONDITION TAB.

Jshree

vimal
Active Participant
0 Kudos

I have used Alternative node and in CONDITION window provided the filter WA-TYPE = E but it is giving me following error :

Incorrect logical expression: Instead of "E", a field, a function, or "(" was expected.

Any suggestions .

Thanks,

Vimal

Edited by: VimalSharma on Aug 16, 2011 1:02 PM

Former Member
0 Kudos

Hi Vimal,

You have to use single quotes:

Instead of "E" use 'E' .

BR

Dep

SureshRa
Active Participant
0 Kudos

I assume you use Smartforms. In that case you should have this Field in both these columns. In the first column you should have condition TYPE = 'E' and in third column you should have condition TYPE <> 'E'

Regards

Suresh