Products Purchase Support News Members Company
Why ApexSQL?
To See the Top Reasons to Buy Apex SQL Software tools: Click Here.
ApexSQL Univ Studio
$1,999 All ApexSQL Tools with 1 yr Maint and all New tools Free for 1 yr. Learn More
FREE SQL Tools
FREE ApexSQL Tools and Add-ins. Learn More
Killer Discounts
Unbeatable Killer Upgrades and Discounts. Learn More
ApexSQL Gear
Click Here for our ApexSQL Gear Store.
SUCCESS STORIES
"... I forgot to mention that I have personally evaluated 10-15 SQL administration utilities for SQL & yours are some of the best I've seen, keep up the good work."

Lee Davies
Software engineer
Occam direct marketing
www.occam-dm.com

"As your product offers the best set of features i've seen so far and your customer-service has fully convinced me (couldn't be better ... keep it going like this)"

Martin Schwier
Proj. Manager
WDT Datentechnik
GmbH, Germany

"Thanks for the quick (and honest) reply. I am impressed. Your company sounds like it's truly different from the rest ..."

Paul Barbin
DBA
Lewis, Inc.

Latest Version: 2008.05

Price: $399



 



Ad hoc reporting for SQL Databases

ApexSQL 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.

ApexSQL Report is the first and only reporting solution designed specifically for SQL database developers.

Source Code license available starting at $1,999. Contact sales@apexsql.com for more information

ApexSQL Report is a sophisticated data driven reporting application, written in ASP.NET, that uses Stored Procedure Metadata to create sort able and page able HTML reports. Create output in HTML, Excel and animated graphs.

What's New! Click Here to learn about the new features in ApexSQL Report 2008.

Product Information

Product Demo
ApexSQL Report News
ApexSQL Report Datasheet
What's New in ApexSQL Report 2008 (Datasheet)?
What's New in ApexSQL Report 2008 (Detailed Summary)?

 

ApexSQL Report Help File
ApexSQL Report Knowledge Base
ApexSQL Report FAQs
ApexSQL Report Step-by-step Guide(s)

Features

Easily administrate reports directly from the interface

Drill down to find more information (Tablular report)

Drill down to find more information (Graphical report)

Set a date

Get connected

Select your reports

Define your picklists

Test your picklist Procedures

Easily Navigate the Report Wizard

Visualize information graphically

Quickly administrate users and permissions

Get help directly from the user interface

Column sorting

Column grouping

Aggregate functions

Secure access to reports through usernames and passwords

Report Gallery

Pie Graphs

Column Graphs

Other

Concept

(by Brian Lockwood, founder of Apex SQL)

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 ....

What People are Saying


"I'm asking a lot of questions on your support forum for Report, but I have to say this product is seriously easy to use! I'm getting reports online at a mad rate right now. Considering that I couldn't build a Web page with anything other than static HTML on it if I had to save my life, being able to build reports this way is immensely valuable to me and the company I work for. I'll probably continue pestering you with technical questions and feature requests, but I thought I should mention this is a great product just with what I can already do with it."

Gus Gwynne
DBA
PostMark

© 2009 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy