Archive

Posts Tagged ‘SQL Server’

Alternative to Reporting Services (SSRS)

January 11, 2014 Leave a comment

SQL Server Reporting Services is a popular choice for creating, deploying, and managing reports.  But there are many occasions when it is an overkill or the data source is not SQL Server.  Sunset Reports provides an attractive alternative that provides most of the features of SSRS and many features that SSRS doesn’t provide.  Sunset Reports is easier to learn, is simple to install and use, and is less expensive.

Sunset Reports provides a great award winning Report Designer, a powerful visual query builder, the ability to connect to almost any database, a huge list of export and file formats, and numerous features to deliver the reports to the user.   Sunset Reports can act as a report server with a true Windows based process running in the background.  As a report server it can push reports to users, but it can also respond to emails when a user wants to pull a report.   With the ability to schedule reports and have them queued up, you have everything you need to manage document delivery.  And since reports can also be saved as a web page, Sunset Reports can build web pages and FTP them directly to your website.

So if you are looking for another option besides SSRS, or any other report designer, then look carefully at Sunset Reports.

Advertisements

MS SQL Server Reporting Tool

May 22, 2012 Leave a comment

Sunset Reports offers several methods of connecting to SQL Server databases that makes it a good choice for creating reports.

Using the built-in Query builder you can connect directly to a SQL Server database as shown in the next figure.

The Query Builder also supports SQL Dialects for different versions of SQL Server.

Even in the Report Designer, you can use the Report Wizard and make a connection to SQL Server…

 

But of course, you can simply use the ODBC connection if you choose.