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 […]
Use Google to find help fast. For example, search on "xpressdox choosefromlist".
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. […]
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 […]
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 […]
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 […]
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 […]
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 command «SaveAsRTF(Yes)» is used to instruct XpressDox to save the assembled document in RTF format.
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 […]