Data not getting printed properly in Smart Form

[Former Member]

Dear freinds ,

I have created a smart from , the item details are not getting printed against the header (TEXT) details .

i have requirement as follows :

Name : ________ Sex : M/F Dateof Bith __________

Qualification :_____________Years of Education _____

Advance Amount ___________________

i have taken the Name , Qualification , Date of birth, years of education and Advance Amount in header and i want the

data for this in the above blanks from the detaiil.

So i have take Table option . Header i have given all the Text (Name , Qualification , Date of birth, years of education and Advance Amount ) and int he Main Area i want to have the

data for the above since the Field above Advance Amount has multiple data will be coming from database , so iam using in the smart form Loop .......i have put the table under the loop.

In the Footer i haeve the conclustin description.

Now my problem is that the data is not getting printed correct .....

In the blank place against Name i want to have data ex Chandu..( i have used &Wa_final-name) ......the data(Chandu) is geeting printed at wrong place

it is getting printed just above the footer data not in the blanks where the data has to get printed.

finally iam getting output as below

Name : ________ Sex : M/F Dateof Bith __________

Qualification :_____________Years of Education _____

Advance Amount ___________________

Chandu 07/0/1980

Bsc 10

5000

I hear by furnish all my details correctly -

---

> footer data.

could any one correctly where i went wrong.

regards

srinivas.

[naimesh_patel · Accepted solution]

Header is meant to print the only headers. In your case, you have to print the Name, Qualification, DoB etc alongwith the data. So, puting these Name , Qualification , Date of birth, years of education and Advance Amount into the Header area will not work.

Put it into your MAIN area like:

Name :&w_name& Sex : M/F Dateof Bith &w_dob&
Qualification :&w_qua& Years of Education &w_edu&

and so on.

Texts in the Header are used when you want to generate a output in the tabular format.

Regards,

Naimesh Patel

[Former Member · Accepted solution]

Dear Naimesh Patel,

Thank you for giving me very good idea , it has worked and it working as per my requirement thank you allot for the help.

I have one problem coming in the data displaying.

i have data as follows :

Loan Type Loan Amount

LT01 500

LT02 1000

LT03 400

which is coming from my smartform output which is correct.

however for some particular personnel no.s i will not be having

all the 3 loans types being used by the user ........

for ex if an employee has used only two loans by him

ex : Lt01 and Lt03 and he having awailed Lt02 .........

it shouldnt be displayed on the SMART Form output at all

i should get data as

Loan Type Loan Amount

LT01 500

LT03 400

but iam getting presently from my smartform output as

Loan Type Loan Amount

LT01 500

0.00

LT03 400

which is wrong as per the requiremnt the 0.00 should not be appearing at all as i dont have the LT02

actually in my smartform Main area i have given as

: &WA_final-loanamt1&

: &WA_final-loanamt2&

: &WA_final-loanamt3&

there by amount is getting printed as 0.00 ......since amount is currency it is getting printed as 0.00 . ..........how to skip

this and get the data as

Loan Type Loan Amount

LT01 500

LT03 400

Please tell me this is problem iam only getting. Please help me

regards

srinivas.

[Former Member · Accepted solution]

hi,

use 3 seperate text elements for the loans and put a condition : amount not equal to 0.00 so as soon as 0.00 comes it will skip the text element.

[Former Member · Accepted solution]

Dear Nitesh,

I have created a loop (It_final into wa_final )and kept three text boxes . in first text box itself i have written directly as

if not wa_final-loanamt1 is intial.

&WA_final-loanamt1& .

endif.

the result i have found is now if not wa_final-loanamt1 is intial is also getting printed....

please could you let me know how to write a condition in smartform.

thanks & regards

srinivas.

[Former Member · Accepted solution]

Dear Nitesh Kumar ,

Iam not able to skip the record it is giving me as 0.00 only

as per you below i have done like this please suggest me where i went wrong.

Table > Main Area> program_lines> i have created a Text_amount > in the Text_amount i have passed &wa_final-loanamt&.

to skip the record i have kept the condition the below code in the Program lines just before the Text (Text_amount)

break-point.

if wa_final-LOANAMT eq ''0.00' .

skip.

endif.

but it is coming at the breatk-point i found the value as '0.00' ---so till here it is correct

after this it is going to the Text_amount (which is having &wa_final-amount --code) and again displaying

for as 0.00 .....how to restrict after th condition in the program lines and not allowing to go to the text_amount ??.

please help me

regards

srinivas.

[naimesh_patel · Accepted solution]

Create a three separate Text Nodes to be able to print all the three Loan Values. In the condition Tab of each text node, put a condition like:

WA_final-loanamt2 NE INITIAL

So, your main will look like:

MAIN
.. HEADER
.. MAIN
....other printing
....TEXT_LOAN1
...... condition WA_final-loanamt1  NE INITIAL
...... &WA_final-loanamt1&
....TEXT_LOAN2
...... condition WA_final-loanamt2  NE INITIAL
...... &WA_final-loanamt2&
....TEXT_LOAN3
...... condition WA_final-loanamt3  NE INITIAL
...... &WA_final-loanamt3&

Regards,

Naimesh Patel

[Former Member]

Hi srinivas,

In the main window create the loop after the loop create

the text node as per you requirement.

Name : ________ Sex : M/F Dateof Bith __________

Qualification :_____________Years of Education _____

Advance Amount ___________________

Drag and drop the fields into the respective blanks and

display the data accordingly.

After the text node create the text node for the footer

text and dsiplay

Regards,

Sravanthi

[Former Member]

Hi

When you create the Table . Use Table Painter to Create Row and Columns for Each line Type.

When you Use Text element to print text and Values , there is Output Options tab where you can specifiy " NEW LIne, Line Type , New Cell / Skip Cell" to print at exact Location,

Regards

Naveen