Back to the FAQ

What is the syntax we can use for expressions (e.g., for the VisibleExpression property)?

By default, Document Creator follows the C# syntax for expressions (you can also switch to VisualBasic.NET syntax via the Report Options window, under the Script tab). Here are some examples of expressions in the default C# syntax:

Syntax Expression Example Explanation 
[number] == 0
 
[SalesLine.LineAmount] == 0
 Line amount EQUAL TO 0 
[number] != 0
 
[SalesLine.LineAmount] != 0
 Line amount NOT EQUAL TO 0 
[textvariable] != ""
 
[InvHdr.YourReference] != ""
 "Your Reference" field of Invoice header NOT EQUAL TO empty 
![boolean]
 
![SalesHeader.ShowLotSN]
 NOT Show Lot-/Serial nos. (Negation) 
[expr1] && [expr2]
 
([SalesLine.TypeNo] != 0) && ([SalesLine.TypeNo] != 3)
 Line type not equal to 0 AND Line type not equal to 3 
[expr1] || [expr2]
 
([SalesLine.TypeNo] == 0) || ([SalesLine.TypeNo] == 3)
 Line type equal to 0 OR Line type equal to 3 
[number] >= 0
 
[SalesLine.Amount] >= 0
 Line amount GREATER THAN OR EQUAL TO 0 
[number] <= 0
 
[SalesLine.Amount] <= 0
 Line amount LESS THAN OR EQUAL TO 0 
[datevar] != default(DateTime)
 
[SalesHdr.DueDate] != default(DateTime)
 Date has been entered (date <> 0D) 
[textvar].StartsWith("Hello")
 
[InvHdr.FieldName].StartsWith("Hello")
 Text field STARTS WITH text "Hello" (similarly you can use: Contains and EndsWith) 
[Blob] != null && [Blob].Length > 0
 
[InvLine.ItemPicture] != null && [InvLine.ItemPicture].Length > 0
 Blob/Byte-array is filled

FAQ categories

Narrow down your search
  1. Show all
  2. Custom Fields
  3. Document Archive
  4. Document Creator
  5. Document Mail Queue
  6. General
  7. Inventory Availability Indicators
  8. Price and Item Management

Related questions

We are getting a message that our license is invalid. What should we do? Which options are available for extending reports with new fields or datasources? How does this compare to the implementation of other add-ons? What about security with regards to data processing for report rendering? How is the (data) security arranged between Business Central and the rendering component? We run into an error that says: The name does not exist in the current context. How can we fix this? We are running into an error about XML files containing invalid (hexadecimal) characters. What can we do about this? (NAV)
Copyright © 2022 Apportunix | Terms & Conditions | Privacy