When you have a system of templates and have run them a number of times, say for a number of your customers, the saved data set files become a source of valuable information. It would be nice to be able to access those data files as though they were a database. That’s what the XpressDox […]
Use Google to find help fast. For example, search on "xpressdox choosefromlist".
XpressDox publishes an API for those users who would like to harness the power of document automation within their apps. See the API documentation here.
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 […]
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 […]
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.