Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Field Display
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 15:00]
dlee 		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.  
Line 33: Line 37:
  
 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. 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.
 +
 +<WRAP center round info 80%>
 +Video regarding files and Data Views
 +</WRAP>
  
 ====Highlights==== ====Highlights====
Line 46: Line 54:
 {{ :versago3:dv_display03.png?400 |}} {{ :versago3:dv_display03.png?400 |}}
  
-  - Enter the new field name +  - Enter the name for the new derived field 
-  - Use the available function to build your formula+  - Use the available functions to build your formula
   - Click validate to check your syntax   - Click validate to check your syntax
   - Save the derived field   - Save the derived field
  
 ====Images in Data Views==== ====Images in Data Views====
-Go **//[[images_in_reports|here]]//** for additional information on using images in reports.+ 
 +The following image formats are supported. 
 + 
 +  * PNG (preferred) 
 +  * JPG 
 +  * GIF 
 +  * BMP (not recommended) 
 +   
 +Each image must be provided in four (4) sizes. 
 + 
 +  * 45 x 45 for thumbnail image 
 +  * 65 x 65 for thumbnail image 
 +  * 250 x 250 for mouse-over (hover) image 
 +  * 1024 x 1024 for on-click (large) image 
 +   
 +Images are held in the folder C:\Program Files(x86)\TWBS\Versago\WebApp\SiteImages. 
 + 
 +<WRAP center round info 80%> 
 +Video regarding images and Data Views 
 +</WRAP> 
  
 ---- ----
versago3/dataview_display.1663182040.txt.gz · Last modified: 2022/09/14 15:00 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