The page is used to define which columns are displayed in the data view, the order the fields are displayed, and to set various display options.

• The order of the fields can be changed via drag & drop
• The Aggregate option provides a way to automatically display count, average and sum totals.
• Group By causes the output to be automatically grouped for each unique value in the selected data.
• Display Type identifies how the data in a column should be interpreted for presentation.
• Localization is used to adjust the formatting of date, datetime, and currency types.
• File Name is only accessible when the data type of the column is binary, blob, or varbinary . See Note 2 below.

• Numeric values can be used to present KPIs (Key Performance Indicators) markers. See the Defining KPIs section for more information.

Note 1

If you need to report date and time values in a specific format that cannot be set by the localization options it may be necessary to use the SQL Convert function in the SQL Select for the report and present the value as a text value. More information on the SQL CONVERT function, and available formats, can be found here: https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql.

Note 2

Beginning with Versago v2.4 it is possible to download files on disk or files stored as binary data in a database. The second option is primarily intended for files uploaded via a Versago form.

• Disk Source Files are identified using a full path name.
  • The source files must be in a folder location that can be accessed by Versago and Windows IIS. What this means is that files will typically need to be in a network share, e.g. “\\ShareName\FolderPath\FileName” and not in a typical file path like “C:\Data\FileName”.
    • This information is contained in the report results and acts as a pointer to the desired file.

• Database Source Files are identified by reference to specific records in a database. The information provided below refers to files uploaded via a Versago form.
• The data is found in a table named “TWBS_VGO_FormAttachments”. This table is found in the database where the data captured in the form is stored.
  • Two values are required from the record: FileName and FileContent. FileContent is the binary data that will be converted for download. FileName is used as the reference to the binary data.
  • When the data type of the column is binary, blob, or varbinary the File Name field for the FileContent row presents a drop-down list of fields from the report query. Select the column name that contains the associated file name.
  • It is not necessary to display the FileName value in the report, but showing the user the name of the file is typically very helpful.

The files in a database approach does require that the FileContent value is not NULL. As it is very possible that a report row will not have a corresponding report to download, use the following SQ. Setting FileContent to 0 when the database value is NULL allows the report to execute without errors.

isnull(t1.FileName, 'No File') as [FileName], isnull(t1.FileContent,0) as [FileContent]

In both cases, keep in mind that any user that has access to the report can download any file listed in the report. If certain files should be available to certain group(s) of users, different reports may be needed.

Multipurpose Internet Mail Extensions (MIME) types identify the types of content that can be served to a browser or a mail client from a Web server. Since Versago is a browser-based application, any file types that may be downloaded must be defined to the web server.

The most common file types (PDF, XLXS, TXT, DOCX, etc.) are already defined in IIS (the Windows web server). The general process to add/maintain MIME types is described here: https://technet.microsoft.com/en-us/library/cc725608(v=ws.10).aspx.

One MIME type that is not defined by default is for Outlook email messages. These files have the extension .msg. Specific steps to add this MIME type are found here: http://blogs.catapultsystems.com/rhutton/archive/2013/10/25/unable-to-open-outlook-message-file-in-web-browser-msg/.

It is possible to calculate values at the time a report is executed and present them as a new column. This is done using the [Add Calculated] and [Update Calculated] buttons on the “Field Display Details” page.

See the Calculated Fields page for more information.

Go here for additional information on using images in reports.

Add/Edit Data View

Home