EZWriter
-
EZWriter Parameters
When creating a Merge Data Source, you can add in both standard and custom parameters. To do so, click the Add Data Source Parameter button in the...
-
Creating a Table in an EZWriter Template
To create a tabular structure with a consistent table-like feel, use only a section of the template (preferably the Details) to build the entire ta...
-
Determining EZ Writer Table and Column Widths
EZ Writer (HTML) tables are measured in Pixels. The standard conversion is 96 pixels per inch. Here is a handy conversion table. However, keep in m...
-
Truncating Decimals From a Number Field
To remove the decimal values from a number (for example 123.14 displayed as 123), use the SQL CAST function. This will convert the amount to the de...
-
EZWriter Dates in Another Language
If you create EZWriter pages or Word Merge documents in multiple languages, you may want to have spelled out date names such as "September" or "Tue...
-
Formatting Dates in EZWriter Reports
If an EZWriter Data Source returns date/time fields from Enterprise, you will want to format how the date/time displays on the EZWriter report (for...
-
Using SQL Functions with EZWriter
If you have access to your Momentus Enterprise database and a database management tool such as SQL Server Management Studio, you can create SQL Fun...
-
Create Email Templates using EZWriter Templates v20
This documentation is about how to create Email templates within v20 by using EZWriter Templates and provides a step-by-step documentation for admi...
-
Add EZWriter Link as Field in Window Layout
If you created an EZWriter webpage that will be used for internal use, you can add the URL for the webpage as a field within the Momentus Enterpris...
-
EZWriter Word Merge Template Troubleshooting
If you or other users are encountering unexpected results from your Word Merge Templates while using EZWriter Data Formats, there are a few quick t...
-
What is an EZWriter Data Source?
EZWriter reporting is conformed by three main parts: - Data Source - Data Format - Client artifact (iEBMS page, Word Document or Dashboard...
-
Comments in EZWriter Merge Data Sources (v19)
EZWriter Merge Data Sources are written using a subset of SQL (Structured Query Language). When writing an EZWriter Merge Data Source, it may be be...
-
Conditional Branching in EZWriter Data Sources
Version: 19 When presenting information from the database with EZWriter, sometimes information needs to be displayed as certain way depending on th...
-
Build a Comma Separated List in EZWriter Data Sources
Version: 19 Sometimes for presentation purposes it is nice to be able to show a list of values from the database in a comma separated list instead ...
-
Handling Null Values in EZWriter Data Sources
Version: 19 Sometimes when reporting raw values from the DB, NULL values will be returned which is unacceptable for presentation purposes. To handl...
-
Formatting Text Case in EZWriter Data Sources
Version: 19 When adding HTML/Text directly into the EZWriter data source, the editor will force the text to uppercase. This may be undesirable if t...
-
Apply Money Format on EZWriter Data Source
In EZWriter, whenever using data fields that require a specific format; we have to provide the field formatted the way is needed starting from the ...
-
Reuse the Same EZWriter Data Source in Multiple EZWriter Data Formats
The results from the same EZWriter Data Source can be reused within multiple EZWriter Data Formats. This can be especially useful if you need to d...
-
BIGINT within EZWriter Data Sources
When creating an EZWriter Data Source, you are able to use SQL to CAST or CONVERT a value into a specific data type. If you CAST or CONVERT to a d...
-
Speed Up your EZWriter Data Source (v19)
EZWriter Data Sources can be used to extract data out of the Momentus Enterprise database, which can then be used within your EZWriter Data Formats...
-
EZWriter Merge Data Source - DECLARE @local_variable (v19)
Within an EZWriter Merge Data Source, only the first SELECT statement will be used to return results. If you try to create a Data Source that is r...
-
What is an EZWriter Data Format?
EZWriter reporting is conformed by three main parts: - Data Source - Data Format - Client artifact (iEBMS page, Word Document or Dashboard...
-
Using EZWriter Data Formats with Microsoft Word
You can create Microsoft Word based template documents to add as reports or folder items. To do this, follow the below steps: Click the Account Te...
-
How to Publish EZWriter Report as Webpage
EZWriter reports results can be displayed online as a webpage. This is helpful if you would like to share the report results with people that do n...
-
Understanding WRI (EZWriter) page URLs
When learning to build an EZWriter URL with the parameters embedded in the URL, it can be difficult to understand where to place the parameters and...
-
Using a Login for WRI (EZWriter) pages
When building an EZWriter webpage, there is an option to add a Logon to the page. There are two primary ways to use this functionality. Use the ...
-
Enter a New Line within the HTML Tab of an iEBMS EZWriter Page Builder Configuration
When creating or editing an iEBMS EZWriter Page Builder configuration, you can enter content in either the Text tab or the HTML tab. * While on the...
-
Using Multiple EZWriter Data Formats within an iEBMS EZWriter Page Builder (WRI) configuration
When creating an iEBMS EZWriter Page Builder (WRI) configuration, there is a drop-down that allows you to select which EZWriter Data Format you wou...
-
iEBMS EZWriter Webpage Not Showing Results
If you created an iEBMS EZWriter Page Builder Configuration to create an online report, but the page is not displaying any results, make sure the “...
-
Why is EZWriter Not Filling in UDF Values?
When using EZWriter with UDFs for Events and Orders, you much specify the value in CR073_EXT_ACCT_CODE in the Where clause of your SQL statement. ...