SAP Crystal Reports – AxioWorks Ltd

7 Reasons why SQL Server tables are a better option for reporting then SharePoint Lists

28/02/2021/in Export SharePoint to SQL Server, Power BI, Replicate SharePoint to SQL Server, Reporting, SAP Crystal Reports, SharePoint BI, SQL Server Reporting Services (SSRS) /by Danish Detho

SharePoint Lists plays a pivotal role in any SharePoint development primarily because it is the preferred source of data storage in SharePoint. All the great features like security permissions trimming, views, various types of columns, data validations, and entry forms that come out of the box and can be easily configured give SharePoint Lists an edge over any other data storage options. However, there are several scenarios that make SharePoint Lists less desirable especially when it comes to reporting. Reporting becomes very critical when we store business-critical data in SharePoint since it is vital for business users to make decisions. E.g. if you are storing customer orders in SharePoint Lists then soon you will need to develop some reports to get insights on your customer buying trends.

New version of AxioWorks SQList released (6.2.1.0)

21/02/2021/in Export SharePoint to SQL Server, Microsoft365, Newsletter, Power BI, Reporting, SAP Crystal Reports, SharePoint BI, SQList Release /by Francesco

A new version of AxioWorks SQList is out today!

It’s been a while since we released a new version, it was back in April 2020 and a lot has happened since! (and not much of it was good…)

Anyways, here we are, version 6.2.1.0 is out, let’s take a look at what comes with it.

Comparison of BI Tools: Power BI vs Cognos vs Crystal Reports vs SSRS

16/12/2018/in Export SharePoint to SQL Server, Power BI, Reporting, SAP Crystal Reports, SharePoint BI, SharePoint Reporting, SQL Server Reporting Services (SSRS) /by Francesco

Which is the best Business Intelligence (BI) tool available? Why is it the best and what distinguishable features makes it the best one? What are the alternatives? What is the current client base of this tool? Is this BI tool the right one for your business as well? What should you be looking for when evaluating BI tools? Will your business analyst or end users be capable enough to extract desired information from this tool?

In this blog, we evaluated some of the most popular BI tools out there, provided an overview and compared features, hopefully helping you to make the right choice of BI tool to meet your business requirements. A first step to finding the best tool for your company.

Building a SAP Crystal Report with SharePoint list data: How To

18/03/2018/in Reporting, SAP Crystal Reports, SharePoint Reporting /by Paul Gallagher

When it comes to a reporting solution, Crystal Reports is the de facto standard in the reporting world.

In this blog we will cover how we can generate a Crystal report based on data from a SharePoint List. To do this we will first export the data from the SharePoint list to SQL Server using SQList. Once the data is exported in SQL Server, we will use Crystal Reports to create reports using the exported data. The data export process from SharePoint lists to SQL Server can be configured to be either a continuous process or an On-demand one. So, you can choose either from them depending whether you want the generated reports to be in sync as any point of time or only at specific time.

Select currency