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 running into an error message about an object that cannot be instantiated. What can we do about this? A watermark is applied to our reports when printed. Why is that? Users of the Microsoft Dynamics NAV Windows Client are suddenly running into error messages about a Document Creator assembly or file not being found. What can we do about this? We are unable to activate the stand-alone Document Creator Designer. What should we do? We are using Document Creator from a Docker container, but it does not use the correct fonts. What is causing this and what could we do about this?
Copyright © 2022 Apportunix | Terms & Conditions | Privacy