Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • downloads • contact • Schedule • Field Display • Record/Payment Submission
versago3:dataview_display

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
versago3:dataview_display [2022/09/14 16:02]
dlee [Field Display] 		versago3:dataview_display [2024/03/14 14:16] (current)
dlee [Field Display]
Line 11: Line 11:
   * **Localization** is used to adjust the formatting of date, datetime, and currency __types__.   * **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 1** below.   * **File Name** is only accessible when the data type of the column is binary, blob, or varbinary .  See **Note 1** below.
 +
 +<WRAP center round info 80%>
 +Users will be able to sort by clicking column heading. Multiple column can be sorted by using the CTRL key
 +</WRAP>
  
 **Note 1** **Note 1**
Line 22: Line 26:
   * **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.   * **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.   * 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. +    * Two values are required from the record: FileName and FileContent.  __FileContent__ is the binary data that will be converted for download.  __FileName__ contains the file name of the binary. 
-    * 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. +    * The Display Type of __FileContent__ should be set to File 
-    * 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.+    * It is not necessary to display the __FileName__ value in the report, but showing 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.   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.  
versago3/dataview_display.1663185777.txt.gz · Last modified: 2022/09/14 16:02 by dlee

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki