Reflex Reporting

MULTI-SITE, REAL-TIME SHAREPOINT REPORTING ON-PREMISE APPS

Reflex Reporting

Reflex Reporting makes it easy to produce reports from content in your SharePoint lists. The core function of Reflex Reporting mirrors SharePoint List items into a SQL table in real-time.
NO CREDIT CARD REQUIRED
START FREE

By being a Certified Microsoft Partner we have access to the latest training, resources and dedicated support. This means we are always up-to-date on the latest features, releases and early product information to provide our clients a robust, seamless SharePoint experience.

By being a Certified Microsoft Partner we have access to the latest training, resources and dedicated support. This means we are always up-to-date on the latest features, releases and early product information to provide our clients a robust, seamless SharePoint experience.

W H Y  R E F L E X   R E P O R T I N G

SHAREPOINT APP REPORTING SOLUTIONS

If you’re a SharePoint or Project specialist looking to implement reporting solutions faster without the risk of clunky customisations, partner with us to simplify your implementation.


ARE YOU CREATING REPORTS FROM SHAREPOINT THE RIGHT WAY?


As a SharePoint or Project specialist, you’re working with clients that have complex Project and Portfolio reporting requirements that pull data from across SharePoint sites.


As a consultant, you’re tasked with creating reports from your clients’ Project, Portfolio or SharePoint environment but it’s difficult because the data is scattered and obfuscated.


Plus, you often identify that the client’s Microsoft Support is compromised by components directly querying SharePoint backend database.


What’s more, users complain that the reports are wrong - but you discover it’s because they’ve changed their SharePoint list structures and caused the problem themselves.


It’s frustrating to try and build the reports in that scenario to start with, and frustrating to try to support the clients adequately after it’s done.


You want to be able to build reports on SharePoint lists as if they were nicely structured SQL server database tables.

You’d also love to be able to prevent users from changing the list structure in SharePoint (and as an extra bonus, be able to add indexes to improve report performance).


If only there were an app for that! (Hint: there is.)

Real Time Data

✔️ Real-time data extraction into a dedicated reporting database


✔️ Configurable list structure locked in


✔️ Collating common structures from across an entire SharePoint farm


✔️ Adding indexes to the reporting tables


✔️ Automatically stripping out HTML markup


✔️ Ability to extract elements from multi-valued fields


✔️ Ability to join SharePoint list data with Project data in report queries

Book a meeting →

Simple Faster Reports

✔️ A simpler, faster way to develop reports.


✔️ Reports themselves that run faster and are easier to support.


✔️ Clients who think you’re a god. They love you because things just work.

Book a meeting →

What People Say

SharePoint Reflex Reporting App FAQ's

  • Isn’t it enough just to query the SharePoint content databases directly – why do we need Reflex Reporting?

    There are three major issues with using the above approach: 

    • Querying the SharePoint content database directly voids support from Microsoft as it can cause table locks and prevent SharePoint from working correctly. 
    • The report author has to figure out which field to access as SharePoint stores all list content in a single table with fields named like nvarchar1, nvarchar2 or datetime2, datetime3. 
    • The report author has no control over the reliability of the content the report reads, and users can change the fields in lists, breaking reports and providing users with invalid information. 

    Reflex Reporting solves these problems, by creating a reporting database specifically for reports to read the content. The reporting database is made up of tables that represent the list structures defined in SharePoint and use easy to identify field names (i.e. the same field names the user sees in a list). 

  • Why should I choose Reflex Reporting – doesn’t SharePoint web services provide everything I need to produce reports?

    SharePoint web services has the following issues: 

    •  You can’t query content from list instances across a site collection. 
    • The sorting, grouping, and summing functionality is very limited
    • SharePoint web services is very slow to execute because queries must run through XML, web services and then SharePoint before eventually hitting the SQL database and then the data has go back through the same channel again before the report can read it. 
    • It’s slow to develop because the report author usually needs to manually craft a SOAP request (web service call) in a text editor. (i.e. no designer).
    • The report author still has no control over the reliability of the content the report reads, and users can change the fields in lists, breaking reports and providing users with invalid information. 
    • This solution is not migratable. SSRS does not provide a SharePoint list connector or support SOAP requests to SharePoint Online lists. 


    Reflex Reporting avoids these problems, by allowing the report to query content directly from a SQL server database, providing all the performance and functions of SQL server (i.e. table indexes, sorting, grouping, summing etc). Virtually all reporting tools provide report authors with an easy to use interface to query SQL server tables and most report authors know and understand how to create a SQL query. 

Get started today! No credit card required.

Request your 30-day trial offer towards Reflex Reporting in your own SharePoint environment >

Upon submitting this form, you will be contact for details and instructions for our On-Premise Reflex Reporting services.

Share by: