Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (ExchangeConnector) • Record/Payment Submission
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 11:40]
runger [Display Tab Versions 2.4 and Higher] 		versago:display_tab_v24 [2020/01/08 13:35] (current)
runger
Line 6: Line 6:
  
   * 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.
  
Line 59: Line 71:
     * 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 84: Line 96:
  
 See the **//[[Calculated_Fields|Calculated Fields]]//** page 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.1578501601.txt.gz · Last modified: 2020/01/08 11:40 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