cancel
Showing results for 
Search instead for 
Did you mean: 

Smartform Text Condition

Former Member
0 Kudos

HI,

I have a report which has 12 months and different revenues and cost types in a

grid display. I am printing

only if the field has >=1. The report is printing the whereever there is empty

space instead of properly columns ex

Descp Mon1 Mon2 Mon3

XXXX 99 00 00

YYYY 00 88 00

ZZZZ 00 00 44

After the condtion my output looks like this

Descp Mon1 Mon2 Mon3

XXXX 99

YYYY 88

ZZZZ 44

The report should print like this

Descp Mon1 Mon2 Mon3

XXXX 99

YYYY 88

ZZZZ 44

Any help is hightly appreciated.

Harsha

Accepted Solutions (0)

Answers (1)

Answers (1)

jayanthi_jayaraman
Active Contributor
0 Kudos

Hi,

Try to use alternate and in the General attribute set the condition if not the field is intial print the text..i.e.put the text element only in the true part.

Former Member
0 Kudos

Hi,

Thanks for the reply, I didnt get your answer, could you eleborate?

Regards,

harsha

jayanthi_jayaraman
Active Contributor
0 Kudos

Hi,

Hope you will be printing the output using text element one by one[if not,alter it in that way].i.e.13 text elements for priting a row[since 12 months and one other field].

Before the text element of each month,create a alternate node by right clicking the loop.Drag and drop the text element inside the true condition of alternate.

In General attibutes,give the condition as wa-month <> space.

Former Member
0 Kudos

Thanks again.

Its not working, same problem.

Harsha

jayanthi_jayaraman
Active Contributor
0 Kudos

Hi,

If you put the text element <b>only in alternate node's true condition</b>,and set the condition as month1 > 0 ,then it should work.

Message was edited by:

Jayanthi Jayaraman

Former Member
0 Kudos

Thanks, same thing I did, its not working. The column is getting shifted

first empy row/column.

Regards,

Harsha

Former Member
0 Kudos

hai,

take that variable as numeric yaar then that ' 00 ' will also print

Regards,

Sree

Former Member
0 Kudos

Thanks a ton Sriram,

But due to space constrants, i am moving my amounts to char based field

(000.00). Can I have a decimal points in numberic (000.00)?

Regards,

Harsha