- Creating Reports and Graphs with WOW and Excel

Creating Reports and Graphs with WOW and Excel

Since Excel is widely used for data analysis and charting, we added the capability to access data from

your Database and then chart that data into custom graphs and charts in Microsoft’s Excel program. This

is a very powerful feature because it allows you to customize the graph and charts a great deal and still

bring in the data from Database.

We also have the feature to use one of WOW’s Excel templates to create and run excel charts from data

returned in an operation. You can get your data into excel spreadsheets and have it update dynamically by

using the web query option in Excel. This means you have to set up your own Excel file.

WOW Setup for Excel Web Query

First, make sure that you have created an application and have an operation that selects from the database

some information that you would like to graph. In this case, we have selected from the pjdata.employee

table the number of employees in each department. The way we do this is select all of the departments and

then sum up all the records of employees and which department they are a part of:

SELECT deptno, SUM(deptno) AS employees_in_department FROM pjdata.employee

'employees_in_department' is a derived field meaning it is created when the select statement is run and is not

actually inserted into the database.

Creating and Updating Excel Tables from WOW Web Data

WOW excels at pulling information from any database and presenting it in a browser. This provides powerful

processing but at times you may want to have an EXCEL spreadsheet setup with graphs and other formatting

attributes and then merge database data into it at run-time. The feature described below, gives you that

ability.