Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Adding and Updating Business Partner Contacts • SAP Business One Inventory Transfer with Bins • Introduction (Bizweaver) • IIS Configuration • downloads • Introduction (SAP Business One Integration on SQL Server) • SAP Business One Enumerators • Introduction (Record Submission) • SAP Business One Service Layer using Bizweaver v2.5 and higher • SAP Business One Service Layer using Bizweaver v2.4
versago:calendar_report_configuration

Differences

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

Link to this comparison view

Next revision 		Previous revision
versago:calendar_report_configuration [2019/01/08 12:22]
runger created 		versago:calendar_report_configuration [2019/11/13 13:36] (current)
akoehler [Display Tab]
Line 1: Line 1:
-====== Introduction (Calendar Reports Configuration ======+====== Introduction (Calendar Reports Configuration) ======
  
 Versago calendar reports are a special type of report that allows date-focused reporting in a calendar format. This document describes the specific elements of configuring a report for calendar presentation. Versago calendar reports are a special type of report that allows date-focused reporting in a calendar format. This document describes the specific elements of configuring a report for calendar presentation.
Line 11: Line 11:
 The following documents contain additional information that may be helpful with understanding these processes. The following documents contain additional information that may be helpful with understanding these processes.
  
-  * [[versago:administration_console]]+  * [[versago:administration_console|Admin Console]]
   * Versago – Reports Configuration Guide   * Versago – Reports Configuration Guide
  
Line 24: Line 24:
 **Regular report presentation** **Regular report presentation**
  
-{{:c:\shared\pandocconvert/media/image2.png?576x112}}+{{  :versago:calrpt2.png?400  |{{:c:\shared\pandocconvert/media/image2.png?576x112}}}}
  
 **Calendar report presentation of the same information** **Calendar report presentation of the same information**
  
-{{:c:\shared\pandocconvert/media/image3.png?575x512}}+{{  :versago:calrpt3.png?400  |}}
  
 The calendar presentation supports the display of up to three (3) data elements from the underlying report for each date on the calendar. The calendar presentation supports the display of up to three (3) data elements from the underlying report for each date on the calendar.
  
-{{:c:\shared\pandocconvert/media/image4.png?115x93}}+{{  :versago:calrpt4.png?200  |}}
  
 ====== Before You Begin ====== ====== Before You Begin ======
Line 66: Line 66:
   * All the visible columns in the underlying report are displayed in a pop-up “mini-page” when the user clicks on a date item. This pop-up is where things like date formatting, links, etc. are applied. The items appear in the order defined in the “Display” step of the configuration.   * All the visible columns in the underlying report are displayed in a pop-up “mini-page” when the user clicks on a date item. This pop-up is where things like date formatting, links, etc. are applied. The items appear in the order defined in the “Display” step of the configuration.
  
-> {{:c:\shared\pandocconvert/media/image5.png?384x284}}+ {{  :versago:calrpt5.png?400  |}}
  
 ===== Record Submission Tab ===== ===== Record Submission Tab =====
Line 74: Line 74:
 ===== Calendar tab ===== ===== Calendar tab =====
  
-  * See the [[#calendar-setup|Calendar Setup]] section below for detailed information.+  * See the //**[[#calendar-setup|Calendar Setup]]**// section below for detailed information.
  
 ===== Sub-Report tab ===== ===== Sub-Report tab =====
Line 87: Line 87:
  
   * This tab is skipped in this setup process.   * This tab is skipped in this setup process.
 +
 +
  
 ====== Calendar Setup ====== ====== Calendar Setup ======
Line 108: Line 110:
 In this configuration the selected information is shown on a single date in the calendar. In this configuration the selected information is shown on a single date in the calendar.
  
-{{:c:\shared\pandocconvert/media/image6.png?384x207}}+{{  :versago:calrpt6.png?400  |}}
  
-{{:c:\shared\pandocconvert/media/image7.png?384x314}}+{{  :versago:calrpt7.png?400  |}}
  
 ==== Start & End Date Configuration and Presentation ==== ==== Start & End Date Configuration and Presentation ====
Line 116: Line 118:
 In this configuration the selected information is shown across all dates in the calendar from the start date to the end date. Note that the display information appears at the beginning of each week where the date range for the item is included. In this configuration the selected information is shown across all dates in the calendar from the start date to the end date. Note that the display information appears at the beginning of each week where the date range for the item is included.
  
-{{:c:\shared\pandocconvert/media/image8.png?384x208}}+{{  :versago:calrpt8.png?400  |}}
  
-{{:c:\shared\pandocconvert/media/image9.png?384x313}}+{{  :versago:calrpt9.png?400  |}}
  
 ===== Display Details ===== ===== Display Details =====
Line 126: Line 128:
 As an example of how this flexibility might be used, if our sample report is titled “Production Order Starts by Item,” we could show the item number without a label since the report title tells the user that the item number is the key. But we might still have a label for the order number and quantity since those values might not be as obvious. As an example of how this flexibility might be used, if our sample report is titled “Production Order Starts by Item,” we could show the item number without a label since the report title tells the user that the item number is the key. But we might still have a label for the order number and quantity since those values might not be as obvious.
  
-{{:c:\shared\pandocconvert/media/image10.png?384x175}}+{{  :versago:calrpt10.png?400  |}}
  
 ====== Appendix A – Using Times from SAP Business One ====== ====== Appendix A – Using Times from SAP Business One ======
Line 132: Line 134:
 To use time as part of the calendar selection/presentation it must be defined as a SQL data type of time. In SAP Business One, time values are stored as whole numbers (integers). To use these “time” values in a calendar report they must be converted to a SQL time value. The conversion statement needed is shown below. To use time as part of the calendar selection/presentation it must be defined as a SQL data type of time. In SAP Business One, time values are stored as whole numbers (integers). To use these “time” values in a calendar report they must be converted to a SQL time value. The conversion statement needed is shown below.
  
-cast(left(right('00' + cast(TimeValue as nvarchar),4),2) + ':' + right(TimeValue,2) as time) as [ConvTime]+<code sql>cast(left(right('00' + cast(TimeValue as nvarchar),4),2) + ':' + right(TimeValue,2) as time) as [ConvTime] </code>
  
 This converts the numeric value to text (nvarchar), adds leading zeros and the “:” separator, and then converts the whole thing to a SQL Time value. This converts the numeric value to text (nvarchar), adds leading zeros and the “:” separator, and then converts the whole thing to a SQL Time value.
  
 Using this statement to report both date and time for SAP Business One Activities, the full SQL statement looks like this: Using this statement to report both date and time for SAP Business One Activities, the full SQL statement looks like this:
 +<code sql>
 select select
- 
 t0.Clgcode, t0.CardCode, t0.CntctDate, cast(left(right('00' + cast(t0.cntctTime as nvarchar),4),2) + ':' + right(t0.CntctTime,2) as time) as [ConvTime], t0.Details t0.Clgcode, t0.CardCode, t0.CntctDate, cast(left(right('00' + cast(t0.cntctTime as nvarchar),4),2) + ':' + right(t0.CntctTime,2) as time) as [ConvTime], t0.Details
- 
 from OCLG t0 from OCLG t0
 +</code>
versago/calendar_report_configuration.1546968132.txt.gz · Last modified: 2019/01/08 12:22 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