Archive

Archive for the ‘Analytical Software’ Category

Quick Introduction

May 26, 2017 Leave a comment

Sunset Reports is based on award winning components and proven technology, and provides users an alternative to such software as Crystal Reports, SSRS, and others.  The report designer handles all types of content.   And you can even import report designs from other software as well.  The report queue allows for scheduling of reports, file and document distribution including recurring schedules and provides easy to use list and calendar views.  Besides using Sunset Reports as a reporting tool, it is perfect for information management, data analysis, business analytics, visualizations, web site design, making labels, data conversion, document management, document distribution, and more.

This slideshow requires JavaScript.

All In One Software

April 23, 2013 Leave a comment

As we continue to see how people use Sunset Reports, we are amazed to find out that the product can do so much.   In surveying our current user base, we have found the functionality of the software going beyond what we originally intended.   Here is a small list of how the software has been used (The first few were obvious, but included here to make the list as complete as possible.)

  • Reporting Tool
  • Data Analysis
  • Business Analytics
  • Management Dashboards
  • Charting
  • Visualizations
  • Business Graphics
  • Web Site Design
  • Web Page Designer
  • Label Maker
  • Word Processor
  • Dunning Letters
  • Data Conversion Tool
  • Document Management
  • Document Distribution
  • FTP Client
  • File Backup Manager
  • Report Server
  • Report Subscriptions
  • Meeting Presentations
  • Report Scheduler
  • Model What-if Scenarios
  • Email Blasts

If you are using the product for something not on this list, drop us a line, we would love to hear from you.

Feature List

March 27, 2013 Leave a comment
Data Connectivity Data Sources MS Access (all versions), SQL Server, MS Excel, Oracle, OLEDB, ODBC, MS Outlook, MySQL, and more
Visual Query Builder Grouping, Sorting, Filtering, Sub-queries, derived tables, Union queriesAdvanced properties: Aliases, Virtual fields, Various SQL Dialects, Visual representation modes
Report Design Contents grouping, filters, sorting, bands, sub-reports, styles, summaries, calculated fields, watermarks, backgrounds, bookmarks, parameters
Controls text boxes, lines, shapes. barcodes, checkboxes, page info, panels, images, page breaks, tables, postal codes, rich text controls, cross-band controls, hyperlinks, multi-columns, cross-references, gauges, map control
Pivot Tables OLAP, Key Performance Indicators, (KPI) Graphics
Charts & Graphs 56 Types with many options2D, 3D, Regression and Trends
plus Parameters, scripts, wizards, labels, mail merge, Drilldown, Drillthrough, Document Map, Multiple reports within a single reportImport from Crystal Reports, Microsoft Excel, Microsoft Access, Data Dynamics Active Reports, and DevExpress
Report Definitions Parameters Select from a data sourceText, Numeric, Static Dates, Dynamic Dates, Fixed and Prompted
plus Multiple definitions using the same design, Descriptions, Titles, External files (treat a file from other software as a report), Print/Preview, Export, Email
Distribution & Delivery Report Processor Runs as a service in the background
Similar functionality to a Report Server
Has the functionality of a server without an operating system server, database server, or web server
Handles report subscriptions
Report Bursting, Report Exploding, Report Splitting, Email Blasts, Email Broadcasting
Report Queue Schedule one time, Schedule recurring, List and Calendar views
Email Requests Monitor email requests, Reply to emails with attached reports/documents
FTP Transfer reports to FTP Site
Website Semi-Static Website, Automatic Index page creation for reports including nested folders
File Formats Document: pdf, html, mht, rtf, txt
Data: txt, csv, xls, xlxs
Graphic: bmp, emf, gif, jpeg, png, tiff, wmf
PDF’s can be password protected

QuickBooks and CleverQ

January 5, 2013 Leave a comment

Intuit has provided an ODBC source called QODBC which is a data source interface to Quickbooks.   With this ODBC interface you can extract data from Quickbooks allowing reports and other information gathering applications to use the data.   A version of Sunset Reports is included in a product called CleverQ which can extract Quickbooks data in a different way and can provide dashboards, gauges, scorecards, charts, reports, and more.   It can also import data from Microsoft Excel, Access, and other compliant ODBC databases.  Click HERE to find out more.

The Perfect Data Analyst Tool

July 7, 2012 Leave a comment

If you are a data analyst or do data analysis work, Sunset Reports may be the perfect tool for you.   It can connect to a varient of business applications and databases.   You can create very sophisticated queries and data extractions.   With the report designer, you can produce almost any kind of report you want with many different type of charts or graphs, pivot tables for OLAP sources or any source, calculations, statistical and regression analysis, forecasting, and more.   The results can be sent to a variety of formats and distributed in a number of different ways.   It is ideal for making recommendations, interpreting data, discovering trends, problem solving, data mining, quantitive analysis, and data visualization.

Knowledge Worker

May 31, 2012 Leave a comment

From Wikipedia, a Knowledge worker is a worker whose main capital is knowledge.   The term is sometimes confused with Information Worker, which is a person who captures data and turns it into information.   Information Worker may be a more accurate name for someone who uses Sunset Reports.

The right tool can make being an information worker much more productive and that is what Sunset Reports is all about.   If you need to take data and …

  • Analyze it
  • Disseminate it
  • Organize it
  • Monitor it

… then check out our product.   It is probably just what you need.

Chart Series Views and Indicators

April 19, 2012 Leave a comment

For certain chart types, you can add an indicator to the series views.  There are 9 different types: Regression Line, Trend Line, Fibonacci Arcs, Fibonacci Fans, Fibonacci Retracement, Simple Moving Average, Exponentional Moving Average, Weighted Moving Average, and Triangular Moving Average. Each one has some additional properties that are different from each other. Most people are already familiar with regression, trend, and moving averages. The Fibonacci indicators are primarily used for financial analysis, but with Sunset Reports you can use them with not only stock and candlestick charts, but for any 2D X-Y chart as well as the Gantt series of charts. There are a number of good websites that will give you details of the Fibonacci indicators. Quickly, these indicators expose the golden rule symmetry between two series and are useful to forecast levels of support or resistance for a trend.  Check out this link for more information- Fibonacci Number

More posts coming on this topic, so keep checking back.