Hi All,

Is there any way, do not write the value of zero.
(if the value = 0 then do not write)
becoz I cannot assign ""(space) to variable if the variable type = long

Thank You.

Hi,

There are 2 ways..

1. In report script fo the required layout write this.

E.g. you need to supress detail.1

detail.1:
before.layout:
if value = 0 then
lattr.print = false
endif

2. In print condition of the layout write this

value <> 0

Hi All,

Is there any way, do not write the value of zero.
(if the value = 0 then do not write)
becoz I cannot assign ""(space) to variable if the variable type = long

Thank You.

Hello,

open your threats in the proper Forums, please.
(This one in DEV, maybe a admin can move)

if variable = 0 then
lattr.print = false
else
lattr.print = true
endif

Depends on what you want to achieve .

Regards

But, i want to write that record (row), only that one field variable which contain zero value i want to write as null.

Thank You.

Hi,

In that case, go to report layout, double click on the field, under print condition write value <> 0

Done. It will print as blank if the value = 0.

Thanks Bernd. Moved to correct forum.

Thanks Mr. bhushanchanda,

This error came out:

FYI, domain is tcmcs.long



rtdsqlgp00000242:
repgen '2tdB61Oa mod sqlgp0000024' -c 'tdB61Oa mod ' -o "D:/ERPLN/BSE//tmp/tmp033365579" -T 0 -z -qe "D:/ERPLN/BSE//tmp/tmp033365580" -x "D:/ERPLN/BSE//tmp/tmp033365581" -L
bic "D:/ERPLN/BSE//tmp/tmp033365579" -z -u -o rtdsqlgp00000240 -f "D:/ERPLN/BSE//tmp/tmp033365578" -qe "D:/ERPLN/BSE//tmp/tmp033365580"
tmp033365579( 334): Error: '<>' not expected. (context: Detail 1, PrintExp 'equalless30')
tmp033365579( 342): Error: '<>' not expected. (context: Detail 1, PrintExp 'greater30')
tmp033365579( 345): Error: 'else' not expected.
tmp033365579( 347): Error: 'endif' not expected.
tmp033365579( 356): Error: 'endif' not expected.

5 ERRORS REPORTED.

Hi,

What have you written in print condition?

You do not need to write if and else.

Just write value <> 0 or value > 0 (In case if you want to print only when value is greater than 0)

Post a screen shot if possible.

hi,

I did not write anything,
Please refer attachment,

Will check tomorrow,going back..

Hi,

It should be

equalless30 <> 0

or:

$$ <> 0

Regards Günther

Hi Mr Bhusan & Mr Gunther,

Both solution works.

Thank You Very Much.