ApexSQL Report

Apex SQL Report is a data driven, web reporting solution for Microsoft® SQL Server©.  Imagine the ability to leverage off an existing database and begin offering your users literally hundreds of web based, HTML reports in a few minutes rather than weeks or even months.

Apex SQL Report is the first and only reporting solution designed specifically for SQL Database Developers.  

If you have a SQL Server database you can be generating sophisticated HTML reports, graphs and excel spreadsheets without complicated server component installations, steep learning curves or expensive software.  Apex SQL Report works with your existing stored procedure base to extend their output directly to your user's desktops.

UPDATE! Apex SQL Report 4.4 Fully converted to ASP.NET and released!  March 8, 2004

Coming Soon in version 5.0 ...    

• New XML interface with much faster report generation, client side Paging and column sorting. 
• Integration with built in and custom XML Style sheets for customizable user output.  Transform your report presentation.
• Much faster performance!
• Support for more Fusion Chart Graph Types. 

Features

• NEW - Conversion to ASP.NET
• NEW - Test Apex SQL Report against your OWN database.
• NEW - Support for new FusionCharts 2.0. 
• NEW - Column level Aggregate functions
• NEW - Support for reports in pop up windows
• NEW - Export to Excel
• NEW - Supports outputting data in Graph format - includes Pie, Line, Bar and column
• NEW - Administrative console for creating users, grouping reports, managing procedures, reports, passwords and more
• NEW - Now, for administrators, reports can be viewed and/or deleted right from the report treeview
• NEW - Now users can be assigned to groups and only allowed access to certain reports
• NEW - Reports can be added to Groups and only be shown to certain users
• NEW - More user defined options added for graphing
• Reports that are created are automatically displayed in a powerful treeview control grouped by report category.
• Reports point directly to SQL Stored Procedures and analyze the procedure meta data to create filters to select user criteria and automatically create report tables.
• HTML reports allow pagination and column sorting. 
• User's can create client side report filters to show only a subset of reports and set other options like max rows returned and rows per page
• Users can select style sheets that will affect their viewing of the application only.
• Reports can be created, edited and deleted all thru an online Admin console even down to the parameter / filter level.
• Report author can edit report down to report parameters to make them required and even point an individual parameter to a stored procedure to populate a pick list for user input
• It's easy to create new categories when creating new reports

The idea is simple and I have seen this at several client sites where I implemented earlier versions of Apex SQL Report. You have a database and a client application built and deployed.  You have a few weeks worth of application usage and DATA is accumulating ... now you need reports to extract INFORMATION. The boss wants sale stats, biz ratios, how many failed orders, calls taken by reps etc. You go into a meeting and listen to him list off the basic ideas of 20 or more reports. You scratch them down on paper. you get back to your desk and there is an email with 5 more that he just thought of.  Another meeting is called with more "players" and you get another 20 reports. 

At end of the day you have a request for more than 50 reports. Some hard some easy. Some with criteria (input params) and some without. 

The kicker is the reports are needed "yesterday". 

I've been in this situation several times.  Some developers would just implement Crystal or custom web pages in ASP/Java etc and start laboriously creating each hard coded report one by one.  But I've always been averse to such needless drudgery as a developer and refuse to pay for excessive labor myself when it can be avoided. 

My solution was to make an ASP "engine" that would "process" the underlying stored procedures that would provide the data for these reports.  In it's early version it would present the procedures selected for reporting in a rudimentary menu, when the report was called the engine would check for existence of input parameters and present them to the user as HTML input boxes to collect user data. It would then fire off the proc and present the recordset in an html table.  The rest is Apex SQL Report ....

Screenshots

Customer Comment

"I congratulate you on the decision and the approach of free upgrades for life as it is a rare opportunity to see that these days, when most other software companies want more and more money for the things we as users already paid for. I think that if you believe in your product it will speak for itself"

Vilko Poznovia
Database Administrator
Silver Chain
Perth, Western Australia

Order

We are a leading provider of value SQL tools for Microsoft SQL Server developers

Single Developer License - for only one SQL Server databases Developer

Site Developer License - for many SQL Server databases Developers

Home   More Software  More Apex Sql Products

  More Software

Excel Spreadsheets