Microsoft Dynamics NAV (Archived)

Alter the way plain text on orderline shows

(0) Share

Report

Posted on by Community Member

Here some questions regarding text on orderlines:

Plain text is only possible from the description field/column and has a maximum number of characters. How can we get more space for more characters?
Is it possible to begin the text from item column?
An orderline with text still shows "0" in colums quantity, salesprice and totals on reports - how can these be "hidden"?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Suresh Kulla 49,097 Super User 2025 Season 2 on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

Since you are displaying data in the RDLC, open the layout by using view -> layout and from there check report properties where different all VB functions are written, to use any one of those functions

use just need refer like below

=Code.BlankZero(Fields!LineAmount.Value) ... just an example

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

hi JesperJensen,

You need to open the Report Layout by clicking on to the View -> Layout.

Once you are in the Layout, you can get into the Report Properties.

Best Regards,
MMV

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,601 Super User 2025 Season 2 on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

You have to check in rdlc layout

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

Sorry - just saw this is the LineAmount property...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

Hi Again,

I dont get report properties when right clicking, but if I go to "design" the report I can gain access to properties via Shift+F4. But here there are no "Code" to select on left side. Please see here:

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

Hi,

You may find the BlankZero as below:

Best Regards,

MMV

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,601 Super User 2025 Season 2 on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

BlanknZero function is already available in Report 1306

You can check it in Report Properties

Right Click on your report and select Report Properties

Select Code on Left side options

You will see BlankZero function

we have to use it as =code.BlankZero(Fields!MyField.value)

Just add Code.Blankzero in your field expression

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

Hi Suresh,

Thanks for your suggested answer. I can't find the BlankZero in any report properties - can you show me more detailed where I should put the code on ie. report 1306?

Thank you.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 49,097 Super User 2025 Season 2 on at

Like (0)

Report
RE: Alter the way plain text on orderline shows

For decimal field if you do not want to display 0 then you can copy the function from any one of the standard reports i.e BlankZero from report properties --> code or below is the function.

Public Function BlankZero(ByVal Value As Decimal) if Value = 0 then Return "" end if Return Value End Function Just use this function: ex. Code.BlankZero(Fields!Quantity.Value)

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,601 Super User 2025 Season 2 on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

1. you can reduce the width of other columns and increase the columns width of description.

Or try by setting CanGrow property of the Description column to yes

Was this reply helpful? Yes No