XLReport Blog

Latest Post

Can a Business Intelligence Platform Make Spreadsheets Obsolete?

Microsoft Excel and other spreadsheet programs have become indispensable business tools. Not only are spreadsheets useful for keeping track of data and making calculations, they contain a number of business intelligence features and data visualizations. However, as vital as spreadsheets have become, they are relatively complicated to understand and use. While you can connect to [...]

Self Service Real-Time Data Access with XLReport Parameters

With XLReport you can easily define unlimited user input parameters. Once a parameter was defined, the user can click the “Refresh Parameter” button to assign new parameters and the Excel sheet will be updated accordingly with real-time data. Learn more about XLReport Parametes.

XLReport version 1.1.1 now displays your assigned Parameters in a Comment

When a parameterized Query data is inserted into Excel it will show a comment above the data which displays the parameter values. Hover over the comment to view its text.

Self Service Real-Time Data with XLReport Parameters.

XLReport allows to define Parameters to Queries. So; every time a real-time data set is inserted into Excel the user will be asked to assign a parameter. This can also be useful for creating dashboards using the same query with different parameters. Once the data was inserted into Excel you can work with it as [...]

3 Minutes to efficiently connect to Real-Time Data in Excel

View the XLReport Getting Started Video and learn in 3 minutes how to connect to your databases and retrieve real-time data.

XLReport – Two New Real-Time Data Refresh Features

Until now, XLReport offered two “Refresh” data functionalities. 1.) “Refresh” the current Excel sheet. 2.) “Refresh All” Excel sheets in the current workbook. When you inserted a real-time data XLReport object into Excel, then the whole XLReport query structure was inherited and, if you edited the underlying query (e.g. adding some new fields), XLReport would [...]

Excel GeoFlow Real Time Data with XLReport

Just tested the new Microsoft Excel GeoFlow add-on and it works beautifully together with XLReport real time data.   1.) Insert XLReport real time data into Excel Let’s use the XLReport query “Sales by Country”.   Here is the result: 2.) Insert the Excel GeoFlow map · Adjust the GeoFlow map settings as you like. [...]

“Geoflow” for Excel: 3D Big Data Visualization Built on Bing Maps

Today Microsoft is announcing the public preview of project codename “Geoflow” for Excel. “Geoflow” is a 3D visualization tool that helps users map, explore and interact with both geographic and chronological data, enabling discoveries that could be difficult to identify with traditional 2D tables and charts. Moreover, “Geoflow” emphasizes visual storytelling through collaborative features that [...]

Why XLReport Leverages Excel as Your Business Intelligence Tool

Organizations are continuously facing pressure to deliver ad-hoc information that effectively meets their business goals. This requires them to have access to real-time data, while also combining, integrating and finally delivering this information to end-users whenever and wherever it’s required. The Problem Most companies manage huge amounts of data distributed on different databases and separate [...]

Real-Time Dashboards with XLReport and Excel Power View

In this example we’ll show how to create a real-time connected Excel Power View using XLReport queries provided with the XLReport sample project. 1.) Create a real-time connected Excel sheet · Let’s select the “Sales by Country” Query. · Double click the query object. · Select “Excel Live Data”. · The data will be inserted [...]

Telling Stories with Data via Freeform Sketching

Just awesome! SketchInsight is an interactive whiteboard system for storytelling with data by using real-time sketching. Creating personalized, expressive data charts becomes quick and easy. The presenter simply sketches an example, and SketchInsight automatically completes the chart by synthesizing from example sketches. More…

New support for query tables in Excel Services improves workbook sharing across an organization

With the enhancements to Excel Services as part of the new Office, Excel now supports query table refresh. Workbooks with query tables now can be seamlessly refreshed on the go from any browser! No need to convert your query table to a pivot table or download a workbook to desktop Excel client to refresh your [...]

Ten Reasons You will Love XLReport as Your BI Tool

Data Connections 1. XLReport allows direct database connections to databases like MS SQL Server, MS Access, MySQL, Oracle, Informix, DB2, Excel, text files and any other database that has an ODBC or OLEDB driver. Query Your Data without Limitations 2. You will face no limitation building your queries. Any SQL syntax supported by the database [...]

Edit a XLReport Query and Save it as a New Query

Sometimes you just need to do small changes to an existing XLReport Query and save it as a new one. Instead of building the Query from scratch you can edit an existing Query and save it with a new name. Watch the video!

Create Queries from existing XLReport Queries

Besides building queries from your database tables and views, XLReport also allows designing queries from already existing XLReport Queries. It also combines XLReport Queries with database tables and views. Watch the video!

XLReport almost ready for release

We’re almost done with beta testing XLReport. So far so good; just a few minor bugs to clean and we’ll be ready to go. So hopefully we’ll be able to release XLReport in a few days. Meantime watch the quick tour video.

Real Time Data in Excel without the Pain? Now you can!

Real Time Data in Excel without the Pain? Now you can! Take the XLReport Quick Tour!

XLReport Quick Start Guide available

  The XLReport Quick Star Guide is available. This Quick User Guide is meant to introduce the main features of XLReport. To get more details, you’ll find links to our online help files for further information.

Microsoft "Data Explorer" Preview for Excel

Try the upcoming capabilities for Self-Service BI with the Microsoft “Data Explorer” Preview for Excel. This preview gives you an early look into upcoming features that simplify access to public and corporate data. Now you can easily discover, combine, and refine data for better analysis in Excel.   More information…

Excel 2013 Power View and XLReport playing along well together

Real time data Excel worksheet created with XLReport. Power View map created with Excel 2013.

XLReport Database Connection strings are encrypted and not visible to end-users

Suppose you created an Excel file with external data, where you connected to your database, entered all the database access information like user, password, database location and son on. Everything is working great with your real time connected Excel sheet to your database.   And now you want to deploy this Excel file to co-workers [...]

XLReport offers the functionality to create XLReport Query objects from existing ones.

Often you’ll need to create a new Query from an existing one; e.g. let’s suppose you have a detailed Query already setup up and want to create a summary Query from it. Instead of building your Query from scratch you can build it from the detailed one. Watch the video for more insight.  

A preview of XLReport

Excel 2013 Business Intelligence enhanced…

“This release of Excel enables business users to do self-service Business Intelligence directly in the client, which now becomes a complete and powerful self-service BI tool – users have all they need in one familiar application in order to do data modeling, exploration and visualization of the data.” More…   We really love what Excel [...]

What is a Real Time Live connected Excel sheet anyhow?

Normally Excel files are "static"; meaning that the data does not change until the user makes edits. However XLReport supports inserting real-time data. Powerful spreadsheets can be created to which are automatically updated when you click the XLReport command button “Refresh”. What XLReport does, is retrieving the most recent data-set from the connected database.

Be Secure with XLReport: All your Data Connection strings are encrypted and not visible to end-users.

With XLReport – your Data Connection strings are encrypted and not visible to end-users. One of the great fearers of XLReport is that it encrypts the data connection string. This makes it secure to deploy XLReport Excel files to end-users. Note: MS Excel native functionality to get External Data will always show the connections string [...]

XLReport – Painless Real Time Data Analysis and Reporting with Excel – READY SOON!!!

XLReport = Painless Real Time Data Analysis and Reporting with Excel!

The problem is not analyzing the data in Excel; most people know how to do that.

The real problem is getting the correct data into Excel. That’s why we just launched XLReport – www.xlreport.com – which makes it easy to connect to your database, create queries and push the data into Excel. It even allows to export to real time data Excel file.

Interesting article about Excel reporting

Coming from a reporting background, one of the most important and frequently used reporting tools is Microsoft Excel. Even if a business uses a reporting package to grab their data from a database, excel is often the way it is presented. Almost every reporting software utilizes Excel as an output type. For those businesses that [...]

We know most people like Excel as reporting tool.

People like to use Excel for reporting. They know how to use it. The problem is always getting the data into Excel in an easy manner. Most folks do that by copying rows from the database and pasting it into Excel. That is very cumbersome, especially if you have to do that frequently. Now; XLReport [...]