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. Licensing/Subscriptions
  9. PDF Merge
  10. Price and Item Management

Related questions

We are trying to add a GS1-128 (a.k.a. EAN-128 / UCC-128) barcode with variable-length Application Identifiers, but I am getting an invalid barcode. What can I do to fix that? We run into an error that says “A task was canceled.”. What can we do about this? (On-Premise) The designer does not start anymore after reconfiguring my PC. What can I do to resolve this? How can we add Item pictures to our document layouts? Can we put Document Creator report layouts under source control?
Copyright © 2024 Apportunix | Terms & Conditions | Privacy