Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Schedule • Display Tab Versions 2.4 and Higher • Preparation • Forms Home • Crystal Reports in Versago and Bizweaver • Introduction (ExchangeConnector) • Display Tab Versions 2.3 and lower • Configuring Crystal Reports for Versago and Bizweaver • Introduction (Roles, Profiles, Users) • CC - Application Screens and Custom SAP Tabs
versago:display_tab_v24

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
versago:display_tab_v24 [2020/01/08 09:56]
runger 		versago:display_tab_v24 [2020/01/08 13:35] (current)
runger
Line 3: Line 3:
 The “Display” page is used to define which columns are displayed in the report, the order the fields are displayed, and to set various display options. The “Display” page is used to define which columns are displayed in the report, the order the fields are displayed, and to set various display options.
  
-{{  :versago:reports7.png?700  |}}+{{:versago:displaytab_v24.png?800|Display tab v2.4}}
  
   * The **Visible** checkbox indicates if the column is to be displayed in the report. When the checkbox is selected (the default) the column is displayed. Use of this setting is helpful when you have columns that are used for filtering and linking but do not need to be displayed.   * The **Visible** checkbox indicates if the column is to be displayed in the report. When the checkbox is selected (the default) the column is displayed. Use of this setting is helpful when you have columns that are used for filtering and linking but do not need to be displayed.
 +
   * **Name** shows the column name from the source query and data type provided from the data selection. It is provided for information only and cannot be changed.   * **Name** shows the column name from the source query and data type provided from the data selection. It is provided for information only and cannot be changed.
 +
   * **Display Field Name** is what the user sees when the report is displayed. The default value is the “Name” when the report is created. The display name is almost always changed to something that will make sense to the end user.   * **Display Field Name** is what the user sees when the report is displayed. The default value is the “Name” when the report is created. The display name is almost always changed to something that will make sense to the end user.
 +
   * The **Display Title** option provides a way to suppress the display of the column name in the report. When the checkbox is selected (the default) the column header is displayed. If the checkbox is cleared the column header is not displayed.   * The **Display Title** option provides a way to suppress the display of the column name in the report. When the checkbox is selected (the default) the column header is displayed. If the checkbox is cleared the column header is not displayed.
 +
   * The **Total** option provides a way to automatically display page and report totals for numeric columns.   * The **Total** option provides a way to automatically display page and report totals for numeric columns.
     * When this option is selected, the page total of the column is displayed at the bottom of each page, as well as the report total.     * When this option is selected, the page total of the column is displayed at the bottom of each page, as well as the report total.
-  * The **Display Order** column indicates the sequence in which columns are displayed and can be used to change the display order. See the //**[[#changing_report_column_order|Changing Report Column Order]]**// section for more information.+ 
 +  * The **Display Order** column indicates the sequence in which columns are displayed and can be used to change the display order. See the //**[[changing_report_column_order|Changing Report Column Order]]**// section for more information. 
   * **Group** causes the output to be automatically grouped for each unique value in the selected data.   * **Group** causes the output to be automatically grouped for each unique value in the selected data.
-  * Only one value can be marked as “groupable.” A message is displayed when moving to the next step if multiple grouping items are found. The message indicates which item will be used for grouping.+    * Only one value can be marked as “groupable.” A message is displayed when moving to the next step if multiple grouping items are found. The message indicates which item will be used for grouping.
     * The grouping set in the report definitions can be removed when the report is executed but cannot be changed by the user.     * The grouping set in the report definitions can be removed when the report is executed but cannot be changed by the user.
 +
   * **Sorting** allows columns to automatically be sorted when the report is executed.   * **Sorting** allows columns to automatically be sorted when the report is executed.
     * Options are ascending and descending. Select the desired option from the drop-down list.     * Options are ascending and descending. Select the desired option from the drop-down list.
     * Sorting is applied based on the display sequence of the columns. You may need to change the display sequence to get the sorting you desire.     * Sorting is applied based on the display sequence of the columns. You may need to change the display sequence to get the sorting you desire.
       * If no sorting option is selected, the data is presented in whatever order it is read from the database.       * If no sorting option is selected, the data is presented in whatever order it is read from the database.
 + 
   * **Type** identifies how the data in a column should be interpreted for presentation.   * **Type** identifies how the data in a column should be interpreted for presentation.
     * Depending on your needs, the Type may need to be selected manually from the drop-down list.     * Depending on your needs, the Type may need to be selected manually from the drop-down list.
Line 39: Line 47:
     * This option is only displayed when the __type__ of **Image** is selected.     * This option is only displayed when the __type__ of **Image** is selected.
     * Options are 45 or 65 pixels.  45 is the default.     * Options are 45 or 65 pixels.  45 is the default.
 +
   * **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__.
-    * This column has a drop-down list of formatting options for the data type. This allows the presentation to be easily tailored to different locations. The current culture designation is for this value in this report. It cannot be set to change based on the user. So, a user in the United States and a user in Great Britain will see whatever format is selected even through their local cultures use different formats+    * This column has a drop-down list of formatting options for the data type. This allows the presentation to be easily tailored to different locations. The current culture designation is for this value in this report. It cannot be set to change based on the user. So, a user in the United States and a user in Great Britain will see whatever format is selected even through their local cultures use different formats. 
   * **File Name** is only accessible when the data type of the column is binary, blob, or varbinary .  See **Note 2** below.   * **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|Defining KPIs]]**// section for more information.   * Numeric values can be used to present **KPIs** (Key Performance Indicators) markers. See the //**[[Defining_KPIs|Defining KPIs]]**// section for more information.
  
Line 49: Line 60:
  
 **Note 2** **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. 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.
  
-  - **Files on disk** are identified using a full path name. +  * **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”. +    * 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.+      * This information is contained in the report results and acts as a pointer to the desired file.
  
-  * **Files in a database** 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__ 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.     * 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.+    * 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.   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 69: Line 81:
 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.
  
-**Calculated Fields**+===MIME Types (Technical Topic)=== 
 + 
 +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/. 
 + 
 +====Calculated Fields====
  
 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. 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.
Line 75: Line 95:
 {{  :versago:reports10.png?400  |}} {{  :versago:reports10.png?400  |}}
  
-See the **//[[Calculated_Fields|Calculated Fields]]//** section for more information.+See the **//[[Calculated_Fields|Calculated Fields]]//** page for more information. 
 + 
 +====Images in Reports==== 
 +Go **//[[images_in_reports|here]]//** for additional information on using images in reports.
versago/display_tab_v24.1578495419.txt.gz · Last modified: 2020/01/08 09:56 by runger

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