Archive

Posts Tagged ‘Report Queue’

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.

Advertisements

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

Report Server

June 23, 2012 Leave a comment

Sunset Reports can work as a “Report Server” similar to SQL Server Reporting Services (SSRS) and Crystal Reports.   The difference is Sunset Reports is much easier to implement and does not provide a web based interface.   No actual server software exists.   Instead a Windows Service is run on any Windows based computer including XP, Vista, 7, Server 2003, and Server 2008.   The service or “Report Processor Service” as we refer to it, runs in the background whether a user is logged on or not.   It runs off a report queue which has a list of reports to run, their scheduled time, format, destination, etc.    Reports can be added via the Windows based user interface, or from an email request.   The Report Processor Service also monitors an incoming email inbox for requests.   Reports can be saved in a variety of formats and even FTP’d to a website.

Report History

June 21, 2012 Leave a comment
Here is a helpful hint if you want to keep a report history…  When Sunset Reports creates a report file from the Queue and Report Processor, you have an option to add a date time stamp as part of the filename.   If you include the date time stamp, files will not be overwritten and you can accumulate a history of a particular report.   Without the date time stamp, the files are overwritten and this is useful if you establish a shortcut to the file and want the shortcut to work all the time. Or if you are creating files that are part of a website, you will need to maintain the same filename for links to work.

Document Management

May 8, 2012 Leave a comment

In addition to creating new documents, Sunset Reports can manage documents created from other systems as well.    Each document can be tracked or catalogued as a “Report Definition”.   For documents created by sunset reports, a report design is assigned and the document created when needed.   For documents created from other systems you link to the document from the report definition screen.

All the fields of the report definition are available to be used in this case, except you will leave the report design field blank.   Now whenever the report processor/queue is requesting the report, the filename parameter is used to use an existing report or file instead of running a report.   The filename can be of any type and can be emailed, FTP’d, etc.

 

Preferences

April 30, 2012 Leave a comment

Prior to designing reports, you should establish your preferences. Click on the Preferences block on the Navigator, or use the pull down menu Edit – Preferences.

The preferences form contains tabs which group the preferences into related areas. The form itself should have enough information about each of the preferences so you know what to enter.

This slideshow requires JavaScript.

If you would like to have the time of sunset each day be displayed on your splash screen and available for schedule of reports, you need to add the latitude and longitude of your location on the Preferences form. There are a number of ways to do this from using a GPS at your location, to going to various websites that provide that information when you enter a city or zip code. Here is a simple method. Go to Google Maps. Zoom into your location. Right mouse click on your location and select “What’s here?” On the top of the web page in the search box, is the latitude and longitude. They are even in the right format. Enter the first number as the latitude on the preferences form and the second number as the longitude.

The Email tab contains the preferences to establish the connection to the SMTP server that will be used to send emails as well as the default values for the Email messages. If you are going to send password protected PDF attachments, enter the password here.

The FTP preferences include the required items to send a report file to an FTP site. By default the files will be sent to the root folder of the FTP site, but you can have subfolders and you can specify the subfolder as the destination folder when defining the Report Queue entry. Only reports processed from the queue can be sent to an FTP site.

Sunset Reports has the ability to create a semi-dynamic web site that does not require a web server. This is ideal for creating a web site and not having the complications of a web server. Since Sunset Reports can automatically create web pages and update the web site, it is referred to as a semi-dynamic web site. The Web preference to “Create Home Page” if set to yes, will create an index.htm file in the repository so the repository can be a local static web site for reports and the home page will contain links to the files. Files indexed include PDF, HTML, HTM, and MHT. If an IndexMaster.htm file exists, it will be used as part of the Home Page. This allows you to create a custom home page with a logo. If you do not have this file, a default home page will be created. The repository may contain subfolders and these are treated as groups and will appear as a link on the parent index.htm and will open a new index.htm file created in the subfolder. This allows you to group reports and organize the static web site more. You might also use this feature to provide security on the website, using Windows security to give access to users by subfolder.

The Data preferences are optional but very useful. By establishing a common data connection, creating data sources becomes real easy. The tab contains the preferences “Primary/Preferred Data Connection” (PDC) and “Secondary Data Connection” (SDC). These are data connection strings that are very specific to the database you are connecting to.  Note that your reports are not just limited to these two data connections.  By changing this preference, all report designs with the data source type PDC or SDC will be updated to the new data source. Creating the PDC and SDC is made easy by using the Report Designer wizard or the Query Builder.

Report Queue

April 9, 2012 Leave a comment

This slideshow requires JavaScript.

Screenshots of the Report Queue

Categories: Features, Screenshots Tags: