​​​​​​​​​​​​​ SPARK Community Home > Videos
​​​​ ​​

Videos library

Product Type:
Filter By Category:

Using the Forms Manager Feature in SPARK Forms Builder

In this video you will see how to use SPARK Forms Manager. SPARK Forms Manager is a central secured section provided by SPARK Forms Builder solution in which the site administrator can manage all site’s forms from a single page. You can access it by clicking on “SPARK Forms Manager” site’s menu item. SPARK Forms Manager enables you to perform the following operations: Delete Forms permanently from your sites, publish/unpublish forms, lock forms for being edited by other users/designers, bulk backup, edit forms, search for forms, clear forms versions history and export forms


How to Apply Paging to Large Data Repeaters Using SPARK Forms Builder

In this video you will see how you can configure and design an Advanced Repeater control to handle large data from other lists using paging feature in less than two minutes on SPARK Reports Builder. You will see how you can configure this control internal properties to handle large data through paging, which reduce loading time significantly and provide a neat user friendly interface for users to navigate through repeater pages fast without the need to load the entire form page.


How to build formulas in your report using the Formula control in SPARK Reports Builder

In this video you will see how you can create, configure and design a Formula expression control and have it ready in your report in less than two minutes, using SPARK Reports Builder. You will see how you can concatenate text, execute mathematical operations, and include dynamic functions and controls to be reflected in the report using this amazing control.


How to use Expression controls in your report using SPARK Reports Builder

In this video you will see how you can create, configure and design Sum, A vg, Min, Max and Count expression controls and have them ready in your report in less than two minutes, using SPARK Reports Builder.


How to use Radial and Linear Gauges in your report using SPARK Reports Builder

In this video you will see how you can create, configure and design Radial and Linear gauges to reflect your query data visually in two minutes.


How to work with Line and Bar Charts in SPARK Reports Builder

In this video you will see how you can create, configure and design Line and Bar charts to reflect your query data visually. Also, you will see how you can reflect aggregated data “Grouped By” on these types of charts easily in two minutes.


How to work with Pie and Doughnut Charts in SPARK Reports Builder

In this video you will see how you can create, configure and design Pie and Doughnut charts to reflect your query data visually. Also, you will see how you can reflect aggregated data “Grouped By” on these types of charts easily in two minutes.


How to dynamically highlight cells, hide or show columns and rows in SAPRK Reports Builder

In this video you will see how you can dynamically highlight reports cells, hide/show entire columns and hide/show entire data rows using SPARK Reports Builder rules.


How to create a dynamic report table footer using SPARK Reports Builder

In this video you will see how you can create and manage report’s table footers and add dynamic formulas to its cells using SPARK Reports Builder for SharePoint. You will see how you can calculate entire column’s total and the sub totals of aggregated “Grouped By” query reports, easily in few minutes without the need to write an line of code.


Working with Calculated Columns using SPARK Reports Builder

In this video, you will see how you can create calculated columns to generate results based on formula from other columns on the same data row using SAPRK Reports Builder. You will see how you can do an arithmetic operations using data from other columns on the same data row and how to create a dynamic hyperlinks to open the display items page dynamically based on the item column ID. In addition, you will see how you can create a sub report and link it to the parent data rows using dynamic hyperlink calculated column. There are no limits to what you can do using this fantastic type of column and how you can harness it to provide great solutions for your users.


Create Ad-Hoc query reports using SPARK Reports Builder

In this video you will see how to create Ad-Hoc query reports using SPARK Reports Builder. The Ad-Hoc Query feature allow designers to create a rich, dynamic and interactive form to allow passing dynamic query values to the reports based on users interactions. Ad-Hoc Form designer has many great controls to design an outstanding interface for users to retrieve list values for domestic and external resources, and to specify reports queries’ parameters. In addition, you will see how to bind the form with a dynamic “Query Filter. The Query Builder has a Filter Manager feature which is a visual user interface feature that helps reports designers building simple/complex and static/dynamic filters for the query. The report’s designer will be able to filter the query based on static value, Available controls in the Ad-Hoc Query Form, or columns from selected designed query entities. The filter will retrieve the filter values on the report loads or the user clicks the “Run Report” button at the report’s top ribbon at runtime.


Embed reports and dashboards into your SharePoint pages using SPARK Reports Builder

In this video you will see how you can create dashboard reports, charts and embed them into a SharePoint page using SPARK Reports Builder and SPARK Reports Viewer web part.


Reports Scheduling using SPARK Reports Builder

In this video you will see how you can schedule running your reports and export their output data files to SharePoint libraries as PDF, CSV, Excel and Word files. You will be able to select a specific repetition schedule or infinite schedule type. Saved output files can be overwritten, counted or have date/time signature on their file names.


Create a report from a mix of data sources (SharePoint sites and SQL/Oracle external databases using SPARK Reports Builder

In this video you will see how you can create simple to complex reports and dashboards based on data from a variety of data sources such as SharePoint lists/libraries, SQL Server, and Oracle databases. SPARK Reports Builder was developed based on Microsoft best practices with regards to how it connects, integrates, collects and presents data, online, on time and on the spot without the need to directly connect to SharePoint databases or periodically migrates data to other secondary databases.


Create Aggregated Reports using SPARK Reports Builder

In this video, you will see how you can create an aggregated data report in SharePoint, visually by clicking a few buttons and without writing a single line of code. You will see how you can build visual query from your lists and libraries and group them by a specific column to get aggregated data from the query to be presented in a fabulous way as a dynamic interactive report to your users. In addition, you will learn how to create an outstanding charts for your report and present its aggregated data in visual interactive way using Pie Chart, Doughnuts Chart and column chart. SPARK Reports is the new way to create visual, interactive and fabulous reports on SharePoint environments in a couple of minutes, to provide users with a great tool to present and analyze stored data and information in graphical simple way.


SPARK Reports Builder Sneak peek

A sneak peek video about an upcoming amazing tool for creating reports on SharePoint and Office 365. In this video you will see how you can create complex query from sites’ lists, libraries and external SQL/Oracle databases and how build a responsive report for your users with few clicks, visually; without the need to write any line of code. Prepare yourself to represent your SharePoint and external data sources data to your users in a way that you never thought it would be possible.


How to create a SharePoint form

With our SharePoint Web Forms Builder (SPARK), millions of non-technical users, designers, business users and subject matter experts, without the need for programming knowledge and skills, can now quickly and easily build both on-premise and cloud-based enterprise-class forms and applications by placing a rich set of drag-drop controls in a user-friendly editor and let them configuring the control’s properties, style, validations, rules and formats and then publishing these forms to SharePoint lists/libraries/content types with a click.


Repeater Control Advanced Operations in SPARK Forms Builder

In this video you will see how you can do an advanced operations on your form’s repeater control such as getting repeater row number (index), validate sub-controls in repeater, add repeater rows, delete repeater rows, get repeater rows count, copy rows to another repeater control and move rows to another repeater control.


Working with SPARK Tasks Dashboard Web Part Advanced Features

This video will show you how you can use and configure SPARK Tasks Dashboard Web Part to provide your users with informative section about their tasks and a centralized location to access and manage them easily and effectively. You will see how to add, and edit this great web part, how to select the task’s retrieving criteria, show/hide columns, connect it to current site or different site in web application. In addition, this video will show you how the user can use the visual indicators, sort data, filter them and use the advanced filter dialog to create a combined/complex filter criteria.


Create IF Else and Run IF Conditions Using SPARK Workflow

This video will show you how you can create an “IF Else” complex conditions set using only the “IF Else” activity in SPARK Workflow. No need to create a nested, design-complicated workflow to try including an “if else” conditions in it, you can do it now easily with one activity and controlling all the aspects related to your conditions from one centralized location. You can enable the “Else” condition in order to create bypass route if no other condition is met in the activity. In addition, this video will show you how you can use the “Run IF” condition which only run its sub-activities if the condition is met.


12345
​​