Help

The SetDataSourceData Function

July 4, 2017 User Reference

Values in databases can be changed by the user in the interview using the various “Save” options as described in Control how the user can change data source data. The template author can also instruct XpressDox to modify values in a data base, using the SetDataSourceData function. As an example, suppose there is a data […]

Read the full article →

Download the AdventureWorks database

July 3, 2017 Cookbook

Some of the sample templates which are delivered with XpressDox make use of one of the early instances of the Microsoft AdventureWorks SQL Server database.  This database can no longer be obtained from any Microsoft web site, and so a backup is made available here. You can download either the .bak file itself, by clicking […]

Read the full article →

Using a Stored Procedure as a Data Source

June 30, 2017 Cookbook

This Cookbook article refers to the AdventureWorks database which needs to be installed at a location available to your development environment. If you have not already done so, you can download the database from Download the AdventureWorks Database. It is assumed that you already know how to configure a datasource for a SQL Server database. […]

Read the full article →

The GetDataSourceData and GetXMLElementValue functions

May 9, 2017 Help

If you need to get data from a data source and have those data available in an interview (and hence in the data set), then the commands IncludeDataSourceData and ChooseFromDataSource would be what you would use. If, while authoring the template, you come to a point where you need one or more the values of […]

Read the full article →

Define Folder Shortcuts

April 11, 2017 Cookbook

Suppose you have defined a set of folders to contain clauses for insertion using the My Clauses or Shared Clauses features in the XpressDox ribbon.  Normally you would group clauses together into folders containing clauses for similar uses.  For example, they might be “Contracts”, “Notices”, “Letters”, etc. In some cases the folder and sub-folder structure […]

Read the full article →

The UpdateTableFormattingForPdf Function

March 9, 2017 User Reference

Sometimes, not in every case, when using the RemoveColumnIf command, in conjunction with The SaveAsPDF Command, it can turn out the the PDF renderer does not render the table where the column has been removed correctly. The UpdateTableFormattingForPdf function will usually fix this table rendering. Suppose you have a command «RemoveColumnIf(Amount = 0,1)» inside a […]

Read the full article →

The SetWebCustomButton Command

February 13, 2017 User Reference

As its name implies, this command is used to create a custom button on the Web interview. The template author can use this, and then, when the template is integrated into a client system, the button can be used by the web designer to implement custom behaviour in the web interview. «SetWebCustomButton(Press here for custom […]

Read the full article →

The SecondsBetween Function

February 13, 2017 User Reference

The fillpoint «SecondsBetween(Later,Earlier)» will return the number of seconds between the value in data element Later, and that in Earlier. For example: The race started at «ChooseUsingTimePicker(StartTime)»«FormatTime(StartTime,’hh mm tt’)» and ended at «ChooseUsingTimePicker(EndTime)»«FormatTime(EndTime,’hh mm tt’)». The elapsed time was «SecondsBetween(EndTime,StartTime)» seconds, which was not a new record.

Read the full article →

The SaveAsRTF Command

February 13, 2017 User Reference

The command «SaveAsRTF(Yes)» is used to instruct XpressDox to save the assembled document in RTF format.

Read the full article →

The CultureName Function

February 13, 2017 User Reference

This function can be used to take different action depending on the “culture” active at the time. All possible cultures are defined in Table of Language Culture Names, Codes, and ISO Values. The function has two possible arguments, viz. “Input” (or just “In”) and “Output” (or “Out”) «CultureName(‘Input’)» will return the culture which is used […]

Read the full article →