Print Layout Designer and Multiple UDF

[Former Member]

Hi

We have 10 UDF's on a marketing document and need only to print the UDF with values in it below each other.

Example

Item No QTY UDF1 UDF2 UDF3 UDF4 UDF5

A123 10 2.4 2.6 3.2

What we have done is to place the UDF's below each other and selected the option the suppres zero values and on the layout section to auto adjust the height.

It works well if the scenario is

Example

Item No QTY UDF1 UDF2 UDF3 UDF4 UDF5

A123 10 2.4 2.6 2.1 Null Null

Then it will print

Item No QTY UDF

A123 10 2.4

2.6

2.1

But when you skip one UDF value as below

Example

Item No QTY UDF1 UDF2 UDF3 UDF4 UDF5

A123 10 2.4 2.6 Null Null 3.2

Then it will print

Item No QTY UDF

A123 10 2.4

2.6

Blank Line

Blank Line

3.2

We need to print it as

Item No QTY UDF

A123 10 2.4

2.6

3.2

Any suggestions will be helpfull.

[Former Member · Accepted solution]

Hi Lindsay,

If possible, put them in one line. I mean in the deferent columns for each UDF.

Otherwise, you have to try Crystal Report or some other tools.

Thanks,

Gordon

[Former Member]

We can put it on them all on one line, but we are space constraint and thats why we wanted to put it below each other. As to the crystal option it will also be it will be an extra proces and have they would have to move of the invoice screen in order to print

[Former Member]

Hi

I understand what you are explaning, but my problem is still that it will suppress the values but won't move the 5th udf value to the place of the 3rd udf, it currently suppres it and then it will leave two blank lines and then print UDF5

Example

Item No QTY UDF1 UDF2 UDF3 UDF4 UDF5

A123 10 2.4 2.6 Null Null 3.2

Then it will print

Item No QTY UDF

A123 10 2.4

2.6

Blank Line

Blank Line

3.2

We need to orint it as

Item No QTY UDF

A123 10 2.4

2.6

3.2

[Former Member]

Hi Lindsay ,

I think it is not possible to move that .When you specify the layout , you are actually storing some place for that field.I think you can only suppress and do not show in the report but to have it dynamically possible like moving field based on your requirement especially on column area ,i think it is not that easy ./I won't say it is impossible .

Hope it helps to clarify the situation .

Bishal

[Former Member]

HI Lindsay,

You can use suppress if zero if it is a numeric value .

You can get that

Select the rint layout designer you want to edit and

Edit print layout

go to properties -- format ---> suppress zero

if you want to donot want to display the label if the value is null

then

use the feature--- link to

for example if you have A

value 0

If O then A will not be displayed ,

under general ,

Link to value (which is something like F---)

Hope this help

Bishal

-