Archive

Posts Tagged ‘barcode’

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

Compare Toolbars with Crystal Reports

March 9, 2013 Leave a comment

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

Crystal Reports vs Sunset Reports Toolbar

Crystal Reports vs Sunset Reports Toolbar

The red arrows show a match with the toolbar items between the two software programs.  Crystal Reports only has a rectangle as a shape while Sunset Reports provides 23 shapes.

The items on the bottom of the figure with a blue callout show items that Sunset Reports has and Crystal Reports does not have.

For the items on the top toolbar with a green callout:

1 – Insert Group (This is handled differently in Sunset Reports)

Compare Toolbars with SQL Server

March 8, 2013 Leave a comment

In the following figure we have compared the report designer toolbars between SQl Server Report Builder and Sunset Reports.

SQL Server vs Sunset Reports Toolbar

SQL Server vs Sunset Reports Toolbar

The red arrows show a match with the toolbar items between the two software programs.  SQL Server only a rectangle as a shape while Sunset Reports provides 23 shapes.

The items on the bottom of the figure with a blue callout show items that Sunset Reports has and SQL Server does not have.

For the items on the top toolbar with a green callout:

1 – List (This is the default report format in Sunset Reports and does not need a button)

2 – Data Bar (This is a new control coming in an upcoming release of Sunset Reports.  In the meantime, you can use a horizontal bar chart or a horizontal bar gauge)

3 – Sparkline (This is a new control coming in an upcoming release of Sunset Reports.  In the meantime, you can use a line chart)

Code Scanner

December 15, 2012 Leave a comment

If you have an iOS device like an iPhone or iPad, there is a great app from AT&T called the “AT&T Code Scanner”.  Use your iOS device to scan QR, Datamatrix, EAN, or UPC codes.  All these codes can be created with Sunset Reports.

For more information, go to this link: https://itunes.apple.com/us/app/at-t-code-scanner-qr-data/id381292358?mt=8

ATTScanner

Categories: Examples Tags: , , , , , , ,

Data Matrix Bar Code

December 14, 2012 Leave a comment

Another type of bar code that Sunset Reports can create is a Data Matrix code.  It is is a two-dimensional matrix barcode consisting of black and white “cells” or modules arranged in either a square or rectangular pattern. The information to be encoded can be text or numeric data. Usual data size is from a few bytes up to 1556 bytes. The length of the encoded data depends on the number of cells in the matrix. Error correction codes are often used to increase reliability: even if one or more cells is damaged so it is unreadable, the message can still be read. A Data Matrix symbol can store up to 2,335 alphanumeric characters.

For More information see http://en.wikipedia.org/wiki/Data_Matrix

DataMatrixBarCode

Intelligent Mail Barcode

December 13, 2012 Leave a comment

A new feature added to Sunset Reports includes a barcode type Intelligent Mail.  The Intelligent Mail Barcode (IM barcode) is a 65-bar code for use on mail in the United States. This barcode is intended to provide greater information and functionality than its predecessors POSTNET and PLANET. Intelligent Mail barcode has also been referred to as One Code Solution and 4-State Customer Barcode abbreviated 4CB, 4-CB or USPS4CB.

For more information see http://en.wikipedia.org/wiki/Intelligent_Mail_barcode

IntelligentBarCode