How to display a 0 value on a Nav Report via Visual Studio for hidden Field.
AntonyNgorora7
Member Posts: 18
Good Day all. I wanted to ask how best I can display the value 0, for a Remaining Amount field that I added in Visual Studio for a Nav Report.
Basically the Remaining Amount field should display output in two ways.
1. Remaining Amount Values that are equal to 0. And
2. Remaining Amount Values that are not equal to zero.
For the first condition I want to be able to append a 0 to the Remaining Amount column if the value of the Remaining Amount is equal to 0. I added this Expression in the visibility of the textbox for the field as this:
=(Fields!RemainAmt_DtldCustLedgEntries.Value = 0). And it returns a blank column, but I want it to return 0 instead.
The second Condition was fairly easy, had no issues with this one because this expression worked just fine:
Expression in the visibility of the textbox for the field as this:
=(Fields!RemainAmt_DtldCustLedgEntries.Value = 0).
Basically the Remaining Amount field should display output in two ways.
1. Remaining Amount Values that are equal to 0. And
2. Remaining Amount Values that are not equal to zero.
For the first condition I want to be able to append a 0 to the Remaining Amount column if the value of the Remaining Amount is equal to 0. I added this Expression in the visibility of the textbox for the field as this:
=(Fields!RemainAmt_DtldCustLedgEntries.Value = 0). And it returns a blank column, but I want it to return 0 instead.
The second Condition was fairly easy, had no issues with this one because this expression worked just fine:
Expression in the visibility of the textbox for the field as this:
=(Fields!RemainAmt_DtldCustLedgEntries.Value = 0).

0
Best Answer
-
then if it has "=(Fields!RemainAmt_DtldCustLedgEntries.Value <> 0)" get rid of it and it will show 0.
5
Answers
-
Thanks for your response. I did do that @BlackTiger. That is where the Condition lies for each separate table. The first table has this expression in the "Visibility" ("Hidden")property:
=(Fields!RemainAmt_DtldCustLedgEntries.Value = 0) and it displays a blank space for the first table, but I want it to print out 0 instead.
The second table has this expression in the "Visibility" ("Hidden")property: =(Fields!RemainAmt_DtldCustLedgEntries.Value <> 0) this works for the second table.
0 -
[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
then if it has "=(Fields!RemainAmt_DtldCustLedgEntries.Value <> 0)" get rid of it and it will show 0.
5
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 324 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
