topic Re: problem in smartforms in Application Development and Automation Discussions

problem in smartforms

former_member187748 — Sat, 15 Jun 2013 10:36:17 GMT

Hi all i have a smartform in which i need a requirement that if all the internal fields of the three fields( Previous Bill, Current Bill, Cumulative Bill) remains blank,Then the first four fields( SL NO, Service Number, Service Description, and Service Specification) also remains blank .

I have used the condition Like ,it_item-sl_no NE 0. in condition. but not getting the desired output,please sujjest me how to get these four field also blank if

all the values related to it are blank.

Re: problem in smartforms

former_member209120 — Sat, 15 Jun 2013 10:43:59 GMT

Hi sangeev,

Make Output field type C.

Try like this

Re: problem in smartforms

former_member187748 — Sat, 15 Jun 2013 10:59:41 GMT

Hi Ramesh i have used this too, but not getting desired result.

By doing like that, all the fields related to any vlank values gets disappeared.

Re: problem in smartforms

former_member209120 — Sat, 15 Jun 2013 11:08:49 GMT

change your output field type C.

data : outputfield(10) type c.

Re: problem in smartforms

former_member187748 — Sat, 15 Jun 2013 11:16:51 GMT

Hi ramesh, where should i declare this.....in Global Definition or at different place, please

clear it.

Re: problem in smartforms

former_member209120 — Sat, 15 Jun 2013 11:36:14 GMT

Yes in Global Definition only.

like this

Re: problem in smartforms

former_member187748 — Sat, 15 Jun 2013 11:43:44 GMT

Hi Ramesh, after defining in global definition nothing changes, still i am getting problem as i have stated in previous screenshot, one more thing, as you have shown

wa_item-pre_menge NE 0.

I have written it for all variables, like it_item-pre_amnt NE 0, it_item-curr_menge NE 0 etc

But i am not getting what i need

Re: problem in smartforms

arindam_m — Sat, 15 Jun 2013 12:49:43 GMT

Hi,

Are you looping on a table to get all the values or passing that table into smartform from calling program, Why dont you filter the items before you display like copy items from the itab passed to a Global Itab defined in Smartform and exclude those lines and then loop and display.

Say the ITAB you pass is ITAB_DATA. Create a new one in smartform say ITAB_DATA_TEMP copy the item from ITAB_DATA and DELETE the blank entries (Suggested copy assuming that you want to keep the original table if not so you can delete from main table) and display.

Cheers,

Arindam

Re: problem in smartforms

venkateswaran_k — Sat, 15 Jun 2013 13:02:17 GMT

You have to write a Program lines code... in Main_Area row of the Main Table (Next to Header)

In that for every record, you need to check the three values and assing space to the remaining fields accordingly.

Regards,

Venkat

Re: problem in smartforms

former_member187748 — Sat, 15 Jun 2013 13:15:58 GMT

Hi Venkat, i am doing this by calling a driver program associated with it, i have declared my fields

as it_item-pre_menge, it_item-pre_amnt.....etc for all the three field( PREVIOUS BILL, CURRENT BILL, CUMULATIVE BILL).

Could you sujjest me how can i write code in my smartforms to check the entries in all the three fields, and then to assign space for the variables whom i wish to be empty, (when all the three fields contain blank values, then the fields corresponding to it gets disabled)

Re: problem in smartforms

Former Member — Sat, 15 Jun 2013 13:49:20 GMT

Hi,

Please write program lines inside loop,

IF ( itab-Previous Bill

AND itab-Current Bill

AND itab-Cumulative Bill ) IS INITIAL.

flg = 'X'.

ENDIF.

Than check from where this following texts are printing,

SL NO, Service Number, Service Description, and Service Specification

In condition tab write as follows,

flg <> 'X'.

Automatically this four fields won't print.

Try this and let me know the results plz.

Regards,

Ravi Shankar L

Re: problem in smartforms

former_member188827 — Sat, 15 Jun 2013 15:24:21 GMT

on the condition tab of text element on which you are printing SL NO, enter condition

Previous Bill <> initial

Current Bill <> initial

Cumulative Bill <> initial

Repeat the same condition on Service Number, Service Description, and Service Specification.

Regards

Re: problem in smartforms

former_member187748 — Mon, 17 Jun 2013 04:54:46 GMT

Hi Ravi,

Hi,

i have written this code

IF ( it_item-pre_menge

AND it_item-pre_amnt

AND it_item-curr_menge

AND it_item-curr_amnt

AND it_item-cumm_menge

AND it_item-cumm_amnt ) IS INITIAL.

flg = 'X'.

ENDIF.

But i am getting this error "Relational Operator AND is not supported"

Re: problem in smartforms

former_member187748 — Mon, 17 Jun 2013 05:20:09 GMT

i have used in condition tab as

it_item-pre_menge <> INITIAL

it_item-pre_amnt <> INITIAL

it_item-curr_menge <> INITIAL

it_item-curr_amnt <> INITIAL

it_item-cumm_menge <>INITIAL

it_item-cumm_amnt <> INITIAL

for first three fields (S. No, Service No, Service No, but it disappers all the three fields values for all those items having any one field zero, and keep those values only which all these fields are non-zero)

My req. is that, if it finds, all the six fields values zero, then only left hand sided fields gets ommited.

(I don't have defined fields like Previous Bill, Current Bill, Cummulative Bill, i am taking the values in my smartforms as above stated fields)

Re: problem in smartforms

venkateswaran_k — Mon, 17 Jun 2013 06:53:20 GMT

Sanjeev,

I would say the following work around if you face issue in AND operator.

Instead of AND operator, define a wa_test variable as P decimals 2,

wa_test = sum of it_item-pre_menge it_item-pre_amnt it_item-curr_menge

it_item-curr_amnt it_item-cumm_menge it_item-cumm_amnt .

If the wa_test = 0 or wa_test > 0, accordingly use your logic.

Regards,

Venkat

Re: problem in smartforms

former_member187748 — Mon, 17 Jun 2013 07:09:23 GMT

Hi Venkat,

thanks for your reply, but my issue is to ommit all those values in left hand side for which all the six fields values are blank....as you have told why i will take a sum of all these fields...

i am not getting your points......also this format of code is giving error of arithmatic operation error.

Re: problem in smartforms

former_member420878 — Mon, 17 Jun 2013 07:33:16 GMT

Hi Sanjeev,

use program lines in starting of main area and try to write thwe below logic.

IF (it_item-pre_menge not INITIAL) and (it_item-pre_amnt not INITIAL)

and (it_item-curr_menge not INITIAL) and (it_item-curr_amnt not INITIAL

and (it_item-cumm_menge not INITIAL) and (it_item-cumm_amnt not INITIAL).

lv_flag = 'X'.

endif.

now add conditions node (having 2 options - true, false). -> In general tab put condition (for example => lv_flag = 'X'. )

leave true option as it is. - if your above condition got satisfied, then it will not display anything for 1st field.

In false option - add text node which you were supposed to display for 1st field.

repeat this for next first 3 fields as well.

Thanks.

Re: problem in smartforms

Former Member — Mon, 17 Jun 2013 07:43:56 GMT

Hi sanjeev,

you have to do nothing more in this.

just delete the internal table where desire fields having values 0

and print as usual..

Avirat

Re: problem in smartforms

former_member187748 — Mon, 17 Jun 2013 07:52:37 GMT

Hi Neha, i have written code like this....

IF ( it_item-pre_menge IS INITIAL ) and ( it_item-pre_amnt IS INITIAL )

and ( it_item-curr_menge IS INITIAL ) and ( it_item-curr_amnt IS INITIAL )L

and ( it_item-cumm_menge IS INITIAL ) and ( it_item-cumm_amnt IS INITIAL).

lv_flag = 'X'.

ENDIF.

But it is giving error that "Incorrect logical expression: Comparison /SELECT-OPTION can only be followed by "AND", "OR", or )"

Tell me where i am wrong in writing this code.

Re: problem in smartforms

former_member187748 — Mon, 17 Jun 2013 07:53:55 GMT

Hi Virat,

i am not getting your points, please be specific and clear that where should i do that.