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

Videos library

Product Type:
Filter By Category:

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.


Schedule Running Workflows on Office 365 Using SPARK Workflow

In this video you will see how you can create schedules to run your tenant’s workflows using SPARK Workflow for Office 365. Using this great feature you will be able to run your site's and your list item's workflows on a specific date and time for one time, multiple periods or unlimited recurring periods. the user will be able to stop the schedule or delete it through SPARK Workflow scheduler management page.


How to develop SPARK forms custom controls and parts using forms snippets

In this video you will see how to create, develop and design custom controls and form’s parts using SPARK Forms Builder, save them as snippets and use them in multiple forms all over the farm’s sites by dragging and dropping them just like any other control. In addition these snippets can be exported as snippet files, for backups or even to be imported in another site collections, web applications or even other farms. You can add your own and other developers snippets to your existing and new forms with a click. No limits to what you can do with SPARK Forms Builder and its great development platform.


Edit SPARK Workflow Task Form Using SPARK Forms Builder

In this video, you will see how you can customize the default SPARK Workflow task from using SPARK Forms Builder in a few minutes. You can remove and add controls from the tasks list to the task from, redesign it, set validation and action rules, control how the outcomes would display to users and even create a multi-lingual form interfaces that will display to the based on his/her preferred browser or user profile language. There is no limits for what you can do in the task form, and this will provide a very rich experience to your SharePoint users in a way you did not think it is even possible.


Edit SPARK Workflow Task Form Using SPARK Forms Builder

Sep 23 , 2019 Workflow Design

In this video, you will see how you can customize the default SPARK Workflow task from using SPARK Forms Builder in a few minutes. You can remove and add controls from the tasks list to the task from, redesign it, set validation and action rules, control how the outcomes would display to users and even create a multi-lingual form interfaces that will display to the based on his/her preferred browser or user profile language. There is no limits for what you can do in the task form, and this will provide a very rich experience to your SharePoint users in a way you did not think it is even possible.


How To Create Anonymous Forms For Office 365 Using SPARK Forms Builder

In this video, you will see how you can create public forms to be accessed by anonymous users outside your tenant and integrate them to your office 365 SharePoint lists and libraries using SPARK Forms Builder. You can design forms, enable them to be accessed by external anonymous users without the need to create any guest users or pay extra cost for having this feature on your O365. You will be able to publish the links of these forms on your public web site or embed them in its public pages and have all data submitted by the anonymous users stored and managed in your tenant without the need to write a single line of code. You will be able to view stored data for anonymous users as well. Build a complete hybrid intranet-internet environment for your customers and users in a couple of minutes.


12345
​​