Use Google to find help fast. For example, search on "xpressdox choosefromlist".

Category: Help

Download the AdventureWorks database

Download the AdventureWorks database

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 […]

Using a Stored Procedure as a Data Source

Using a Stored Procedure as a Data Source

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. […]

The GetDataSourceData, GetXMLElementValue and GetXPathValue functions

The GetDataSourceData, GetXMLElementValue and GetXPathValue functions

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 […]

Define Folder Shortcuts

Define Folder Shortcuts

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 […]

The UpdateTableFormattingForPdf Function

The UpdateTableFormattingForPdf Function

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 […]

The SetWebCustomButton Command

The SecondsBetween Function

The SecondsBetween Function

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.

The SaveAsRTF Command

The CultureName Function

The CultureName Function

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 […]

The AlignErrorMessages Command

The AlignErrorMessages Command

This command allows the template author for Web interviews to specify where the error messages for data elements in the interview should appear. «AlignErrorMessages(Top)» will cause any error messages to be displayed above the relevant data element in the Web interview, and the converse is true for «AlignErrorMessages(Bottom)»