Apex-SQL Report: reporting solution for SQL Database Developers

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.

Don't wait for the higher priced new version! Buy now and get the upgrade for free.

New with version 6.0 ...

Completely rewritten in C#.NET
Fully functional evaluation download
Reports run more than 50% faster
Totally redesigned interface
Installer configures database and virtual directory. No further steps required
Downloadable demo
30 day trial period

ApexSQL Report - Features

Support for new Fusion Charts 2.0
Column level aggregate functions
Support for reports in pop up windows
Export to Excel
Supports outputting data in graph format - includes pie, line, bar and column
Full copy of FusionCharts developer license included with each license of Apex SQL Report a $99 value. Includes help file, implementation guide and .fla file to customize look and feel of graphs
Administrative console for creating users, grouping reports, managing procedures, reports, passwords and more
Now users can be assigned to groups and only allowed access to certain reports
Reports can be added to groups and only be shown to certain users
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
Reports can be created, edited and deleted all through an online administration console
Report authors can edit reports 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

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

Frank Holznagel: Photo Calendar, Manager, Scanner - 1-More Scanner/Watermarker, Mister Pix - Frank Holznagel Software - 1-More Photo-Calendar/Photo-Manager

Womble Multimedia Software - Mpeg Video Wizard - Frame accurate editing

All-For-Mp3, Audio Mid Recorder, MP3 WAV Converter - Mp3 wav Converter makes it easy to have both - The program converts wav music files

Admire-Soft: Audio Recorder - A professional audio recording + editing software - Sound files recording studio on your computer

Kaspersky for Lotus Notes/Domino - Integrates with the Lotus Notes/Domino server as an additional module - Kaspersky scans in real-time mode

ApexSQL Report: SQL Database Developers © Free jr-s - Apex-Sql Report - a reporting solution designed specifically - 02.02.2012 16:36:44