Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
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
-
Options
txeriff
Member Posts: 492
then if it has "=(Fields!RemainAmt_DtldCustLedgEntries.Value <> 0)" get rid of it and it will show 0.
5
Answers
=(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.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!