Sales Viewer has been designed to generate graphical reports on Daily sales performance, unit sales and sales by range on the basis of Revenue by sector and Revenue by product. The purpose of this template is designed to be a reference for any person wishing to implement or any person interested in the architecture of sales viewer for the ClaySys AppForms.
In ClaySys AppForms Sales Viewer , a combobox is available to select the category. If we select the category as Revenue by sector, the statistical report will show the Daily sales performance, unit sales by sector and sector sales by range as shown in the figure.
- Sharepoint 2013
Sharepoint list is used as a datasource for Sales Viewer. SharePoint lists consist of rows and columns that store data in a similar fashion to a traditional relational database management system such as SQL Server. However, a benefit of lists is that SharePoint includes Web Parts that provide simple methods for managing the data. If the data was stored in a database, it would require custom user interface components to access it and manipulate it. Also, specialized skills are required to design, implement and maintains a custom database. Another advantage of using lists is that custom workflow and event handlers can easily be registered to them.By default ID, Title, Modified, Created, Modified By, Created By, Attachments columns are available in sharepoint list. Apart from these default list columns , user can add more columns depending on requirement.
|List Name||Column Name||Data Type|
'Sales Viewer' list is used to configure a search control. Based on the values in this search control, the graphical data in chart control is presented.
|UnitSales||Single Line of text|
|Dashboard||Single Line of text|
|Range||Single Line of text|
|Title||Single Line of text|
|DailySales||Single Line of text|
In ClaySys AppForms Sales Viewer , a combobox is available to select the category. If we select the category as Revenue by sector, the statistical report will show the Daily sales performance, unit sales by sector and sector sales by range. If we select the category as Revenue by Product, then the statistical report will shows the Daily sales performance, unit sales by product and Product sales by range.
|List Of Forms Used|
|SalesViewer Form Design Rule Design||'SalesViewer' Form is used to present data in a graphical format with respect to the values in the sales viewer list.|
The rule named 'Dashboard' fills the search control 'srcDailySalesbySector' and sets the values to the label controls based on the value in the combobox 'cmbRevenue', on 'cmbRevenue' as trigger. Depends on the values in the search control the Chart controls will be populated. This process is converted into concise, yet readily understood rule expression statements that represent the underlying execution logic of the form as shown in the figure.
Sales Viewer template is designed to be a reference for any person wishing to implement or any person interested in the architecture of sales viewer for the ClaySys AppForms. In this template , chart control is used to display the Daily sales performance in an attractive graphical format.
A how-to is an informal, often short, description of how to accomplish a specific task. A how-to is usually meant to help non-experts, may leave out details that are only important to experts, and may also be greatly simplified from an overall discussion of the topic.
Add Web Part01
Click on Site Settings Wheel in the upper right corner of your site and then select “Site Contents Page”.050607080910
Upload List Template01
On the right corner of the window, click on settings.0203050607