Archive

Posts Tagged ‘Gauges’

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
Advertisements

Compare Toolbars with MS Access

March 1, 2013 Leave a comment

In the following figure we have compared the report designer toolbars between Access 2010 and Sunset Reports.

MS Access vs Sunset Reports Toolbar

MS Access vs Sunset Reports Toolbar

The red arrows show a match with the toolbar items between the two software programs.   The dotted red line shows an approximate match.  Access provides only a rectangle as a shape while Sunset Reports provides 23 shapes.  (Ever try to put a circle or an arrow on an Access report?).  Those items on the Access toolbar with a question mark are for items that really do not belong on a report.  (Why would you put tab controls, buttons, drop down lists, etc. on a report?)

The items on the bottom of the figure with a blue callout show items that Sunset Reports has and Access does not have.  Although one might argue that the “Unbound Object Frame” (2) or the “Bound Object Frame” (4) can provide this missing functionality.  If you can accomplish something similar, it is far more difficult and more restrictive than the native Sunset Reports controls.   The “Hyperlink” control on the Access Toolbar is actually available on all the controls in Sunset Reports.  And finally, Access has a control called “Attachment” (3).  This is an attempt to provide a link to an external file or an database object.  If the object is an image, use the Sunset Reports picture box.  If the object is text, use the Sunset Reports Rich Text control.

Sunset Reports Gauges

January 15, 2013 Leave a comment

With Version 1.89 you now have 4 new items on the toolbar in the report designer.   These items are:

  • Full Circle GaugeGauge
  • Half Circle Gauge
  • Horizontal Gauge
  • Vertical Gauge

With the combination of gauge types and background styles, you have over 100 gauges to choose from.

There are numerous properties associated with each gauge and some properties can be bound to your data source.

For more information, see the this PDF file – > Sunset Reports Gauges

Categories: Examples, Features Tags: ,

Version 1.89 Released

January 15, 2013 Leave a comment

This version adds

  1. Gauges to the toolbox so you can now have gauges on your reports
  2. The report converter for importing your report designs from Microsoft Access, Crystal Reprots, Data Dynamics Active Reports. Dev Express. and Microsoft Excel is also being updated
  3. You can now create calls to Stored Procedures
  4. Several bug fixes are also included

This is a FREE update to all existing licensed Sunset Reports users.

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.

Dashboards and Gauges

March 27, 2011 Leave a comment

A big trend in business these days is looking at dashboards and gauges that measure business metrics.   Key Performance Indicators (KPI) are a typical type of value that is shown on the dashboard.   You can use Sunset Reports to create reports with multiple charts on the same page and also include pivot tables with KPI graphics.   But we have to mention another product called CleverQ, which is much better setup for dashboards and gauges.   We also have to mention that a version of Sunset Reports is built into this product as it’s report manager.  But CleverQ goes beyond reports, it contains analytical tools, seasonal trend analysis, forecasting, gauges, advice, drilldown capabilities, data extraction, and more.   So if you need any of these features, check out http://www.cleverq.com/.