Microsoft Dynamics NAV (Archived)

Alter the way plain text on orderline shows

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (10)

Answers (0)

Suggested answer

Suresh Kulla 43,745 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
mmv 11,465 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
Suggested answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

You have to check in rdlc layout
Community Member Microsoft Employee on at

Like (0)

Report

RE: Alter the way plain text on orderline shows

Sorry - just saw this is the LineAmount property...
Community Member Microsoft Employee 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:
mmv 11,465 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
Suggested answer

Mohana Yadav 59,139 Super User 2024 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
Community Member Microsoft Employee 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.
Suggested answer

Suresh Kulla 43,745 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)
Suggested answer

Mohana Yadav 59,139 Super User 2024 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