An interactive visual design to create simple and complex queries from SharePoint lists/libraries and external SQL/Oracle databases. You can create a mixed query from these types of data sources and have an outstanding query data that can be analyzed in your report’s design and make data-driven decisions in real-time.​

The Query Builder has a Filter Manager feature which is a visual user interface feature that helps query 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.

the report designer can create an aggregated query for the report and represents it in the report design in a very neat and simple way for people to understand. The designer can select which column he/she wants to group this query by.

the report designer can manage how the query results will be sorted. The designer can sort the query based on its columns and can choose which columns will be sorted by and how they will be sorted (Ascending/Descending).

the report designer can create a distinct report query by selecting the distinct results option. This option will eliminate duplicate rows in returned query results data.

SPARK Builder enables users and designers to schedule the running process of reports automatically at specific dates and times. The scheduler engine, which depends on a SharePoint Timer job, will save the output of the generated report to SharePoint document library specified in the report’s scheduler settings. The user/designer will be able to create multiple schedules for a single report and saves their output files to different locations on the SharePoint farm site’s libraries.

​We provide you with many controls to design your reports and Ad-Hoc query forms including Report table, General report design controls (Label, HTML Text, Horizontal and Vertical Lines, Image, Hyperlink, and Page Viewer) controls. Expressions report design controls (Sum, Avg, Min, Max, Count, and Formula) controls. Charts controls (Column, Line, Pie, Bar, Doughnut, Scatter, Area, Radial Gauge, Linear Gauge) controls. Container report design controls (Panel, Panels Table, Accordion, and Splitter) controls. Advanced report design controls (Electronic Signature, Barcode, and QR) controls. General Ad-Hoc form design controls (Label, HTML Text, Horizontal and Vertical Lines, Image, Hyperlink, and Page Viewer) controls. Input form design controls (Button, Textbox, TextArea, Rich Text Editor, Checkbox, Checkbox List, , Dropdown list, Date, Time, DateTime, Radio Button, Toggle Switch, Currency, Slider and Round Slider) controls. Container form design controls (Panel, Panels Table, Accordion, Tab, and Splitter) controls. Integration form design controls (Lookup, People Picker, Advanced Lookup, External Data Dialog, SQL Connector, XML Connector, Web Connector, LDAP Connector, and Managed Metadata controls.​

SPARK Reports Builder provides the designer with the ability to design multilingual reports, these reports will be displayed to users depending on their operating systems or browsers' preferred languages. SPARK Reports Builder supports all SharePoint supported languages with RTL-LTR directions. Just design the report in the primary language, change the form to the desired new language, and update the design and controls’ captions and settings accordingly.

Calculations can be used to compute columns, rows, and grouped data values using expression controls, calculated columns, footer cells, formulas, and action rules. You can use the operators multiply, divide, plus, and minus in your formulas along with internal mathematical functions such as count, sum, avg, min, max, abs …etc.

With a drag-and-drop, designers can easily design and create effective reports for any device without having to write custom code, just click the controls (Report Table, Pie Chart, Sum Expression, Image... etc.) you want to add and drag them over to your report. SPARK gives beginner users the ability to create simple reports, while experienced developers can create any type of complex reports. With "What You See Is What You Get" editor, you can create your reports “look and feel” just the way you want them to be.

With SPARK Reports Builder, you can organize your large designed reports using Reports pages. Each Page can consist of a certain type of report’s information or a group of controls that report displays when the user runs it. By separating the report into multiple pages, it is not only better organized in terms of information, but also it keeps your users more engaged.

Auto-Populate button located in the "Design Group" of SPARK Reports Builder top ribbon. When the user clicks this button, the columns of the corresponding designed query will be automatically populated and built instantly in the report workspace, with all their default properties and configuration settings. The designer will be able to continue designing the report as desired, easily.

What makes SPARK Report Builder Online Help System is designed to help you find what you need quickly. Topics are brief and include references to related topics if you want to learn more. You can access the online help by selecting the help icon from any of the screens. The online help provides users with all the necessary information to help them create reports, fast.

Do not worry about how is complex your query and report’s design will be, SPARK Reports Builder provides a solution to design high-performance reports, which means whatever the query’s data and report’s design sizes are, the report will display to the user fast.

SPARK Reports Builder provides users with all the needed tools to integrate Ad-Hoc Query form with other LoB through Business Connectivity Service BCS, SQL, XML, and Web Services to consume data from these systems. Using these tools, users can easily select items from external data sources, to which tools are connecting with, and reflects their data on Ad-Hoc form’s controls.
- You can utilize the Business Connectivity Services BCS within SharePoint to access external data using "External Picker Dialog" controls and related internal functions.
- You can integrate the form with an external SQL Database (i.e. SQL Server, Oracle) using "SQL Connector" control and related internal functions without the need to use BCS.
-You can integrate the form with an external or internal XML data source, XML string stored in SP columns, or InfoPath forms by using "XML Connector" control and related internal functions.
- You can integrate the form with external LoB applications through their web services by using "Web Connector" control and related internal functions.
- You can integrate the form with LDAP data sources such as Microsoft Active Directory using the "LDAP Connector" control and populate results to the form’s controls using related internal functions.

T​he user can export reports’ data, design, and pages to PDF, Excel, CSV, and word files format. Also, he/she can print preview and print out report pages to local and network printers with a click.​

With the "Rules Manager" feature, you can create smarter reports and Ad-Hoc forms by adding dynamic formatting, formulas, actions, validations, or ready rules, which affect controls within the report or the Ad-Hoc form being designed at the runtime. You can show or hide controls or entire sections based on another control(s) or any combination of logic. You can create rules that make things happen when users enter values. You can create rules that show/hide controls or "Panel: group of controls", change formatting, set control values based on other control, enable and disable controls, make input controls read-only, show messages, show/hide the whole Ad-Hoc forms. Also, you can create complex formulas to use in rules and calculated values by utilizing more than 140 out-of-the-box SPARK functions. The rule scripting language depends on JS and JQ along with HTML and CSS codes, you can specify what action you want these rules to be triggered on like (onLoad, onChange, onClick, or onKeyup).

The "Rule Manager" has an "Assistance Panel" part, which includes the available controls, Query Columns, and functions in the report/form being designed. You can show all rules created on all controls in the report/form. You can create, disable, enable, duplicate, delete, and move the rule up and down based on their priority. You can disable/enable one rule, multiple rules, or all rules by a click.

The CAML Query Builder is an intuitive user interface that helps users/designers creating a CAML query easily and quickly. It has features to create, export, copy, and test the CAML queries through a visual interface tool without the need to write any code. Users can select columns from the query design and add an unlimited number of "Conditions" to the query. This tool enables the user to add or delete unlimited numbers of “Order By” clauses to the CAML query.

Reports designer will be able to Import a SPARK report design file “.srb” to the currently opened report designer including all rules, report design, Ad-Hoc form’s design, controls, custom scripts, styles, report’s query, and its settings.

SPARK Reports Builder has a Checksum feature, allowing the designer to get a summary list of all issues that occur when importing an exported report especially if it was from another SharePoint environment, this is very useful to trace and debugging imported reports.
Also, the reports designer will export the current report design, including all rules, report design, Ad-Hoc form’s design, controls, custom scripts, styles, report’s query and its settings to a file with extension “.srb” referring to (SPARK Reports Builder).

You can use SPARK Reports Viewer Web Part to embed SPARK reports into SharePoint pages and configure them directly there.

The first page the report’s designer will open when working with SPARK Reports is the SPARK Reports Manager page. On this page, the designer will be able to create new reports, view, delete, and manage saved (published and unpublished) site’s reports. ​

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. ​​