Sunset Reports is a reporting tool, report designer, report server, report generator, report manager, cloud service, document delivery system, web page designer, data conversion tool, add-on to Microsoft Office and so much more.
Browse through the Categories to learn more. This website is updated frequently with news, helpful tips, articles, and other information from our sales and support staff.

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

Window View – The Next BIG thing in Sunset Reports

December 15, 2015 1 comment

Coming in the next version of Sunset Reports is “Window View”.   Currently you can print, export, and print preview a report.  With “Window View”, your report becomes a window for viewing on the screen only.   The features of this new view include:

  1. Display your report as a window on the screen
  2. The window can be interactive using the scripts you design in the report designer.   There are numerous possibilities here.  Drilldown reports, menus, etc.   This can be your user interface to the reports you want to give to a user.   Users don’t even have to see the functions of Sunset Reports to see the reports they want or you want to give them.  You can launch other reports in Window View or Print Preview.
  3. The window is automatically sized to the page size of the report design so you can control the window size.  Make it as small or large as you want.  Include any of the report objects.   Use a Label with a OnClick script to create a button.
  4. You can set a time for the window to refresh.  This means your report will be updated periodically automatically.  The update time can be as little as 1 second.  So now your report will update in real time showing real time data.
  5. If your report has more than one page, and if you set an window refresh time, the pages of the report will cycle to that time, and when the first page comes back up, the report will be refreshed with new data.   This feature can be used for slide shows with real time data.

The following figure shows a Window View of a report design.  This design is intended to work as a menu system.   It has a clock that is updated every second.   The five items on the right are labels with click events to perform functions.   This example is included in the sample reports file included with the product.   You can actually create your own application with this feature.

DemoMenu

BIG Advantages

April 15, 2015 Leave a comment

So a company in the construction business is using accounting software like QuickBooks or Timberline which have built in reports.   The reports can be customized to a certain extent and most of them produce the output that is needed for the standard needs of a company.    Using a product like Sunset Reports can take it to a new level with custom reports from scratch where the user has complete control over the content.   Plus, the ability to schedule reports and distribute them in a variety of ways is something almost no accounting software can do.   Two big advantages.

But there is more….  The same company is also using a project scheduling package like Microsoft Project and another package to manage contracts, subcontractors, communications, change orders, etc., and then another software program to do take-offs and estimates.   Each one is perfect for the function it performs, and each one creates reports as necessary.    But you cannot combine the information from all these software packages to produce reports that tie it all together unless you use a program like Sunset Reports.   A really BIG advantage.

Sunset Reports not only can connect to almost any software package to use as a data source, but it can combine the data sources onto one report.   A single reporting solution that will provide consistency across all applications and is fully customizable with the ability to schedule the reports as well as send them or publish them to a variety of destinations and in a variety of formats.

This scenario is not only applicable to the construction industry, but also to materials, consumer goods, financial, healthcare, manufacturing, retail, publishing, technology, utility industries, etc..

15 Things Sunset Reports can do with Microsoft Office

February 8, 2014 Leave a comment

If you are a Microsoft Office user, you will be interested to know that Sunset Reports can:

  1. connect to Microsoft Access databases
  2. replace the query designer in Access
  3. replace the report designer in Access
  4. import report designs from Access
  5. connect to Microsoft Excel worksheet ranges as a data source for reports
  6. import Excel worksheet ranges as report designs
  7. export reports to Excel
  8. import Microsoft Word documents as RTF files into a report design
  9. export reports to RTF files that can be loaded into Microsoft Word
  10. distribute any Microsoft Office file as part of a report definition utilizing the queue and delivery service.  This includes Word, Excel, Powerpoint, Visio, Project, etc.
  11. create reports from Outlook data.   If you have synchronized your Outlook with iCloud, you can create reports from iCloud data.
  12. using OneNote, link to a report file
  13. using OneNote, attach a report file
  14. using OneNote, insert a report printout
  15. integrate with InfoPath to create a custom application

So if you are working with Microsoft Office, Sunset Reports is a great add-on.

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.

Not Just Reports

December 1, 2013 Leave a comment

Yes, Sunset Reports is a great report writer, designer, etc. based on the general understanding of what a report writer is.   But the definition of a report in the software goes far beyond the general understanding.   A report can be a…

  • standard report usually based on some data source
  • document (you can do what most word processors can do)
  • presentation (create a slide presentation where each page is a slide)
  • web page (save to an HTML file and post on a website)
  • Windows form (using the new Windows View)
  • interactive interface (using the new Windows View, you can have the user interact with the window with buttons, etc., make a menu)
  • data converter (define an output format to export to based on an input data source)
  • a software program (using scripts, you can write software in VB.NET C#, JScript .net)

We will explore a couple of these in more detail in future posts.

Additional Samples

August 28, 2013 Leave a comment

With the release of 1.95, we have included a second set of samples in the Samples2 file.   These samples are more advanced and demonstrate the powerful features of Windows mode and scripts.  You can copy these reports and modify them as you want. Included are:

  • Digital Clock – This report when viewed in Window View will show the current time and update each second.
  • Current US Radar – This report will display the current US radar map.   If viewed in Window View, it will update automatically every 60 seconds by the use of the numeric parameter, WindowViewTimer.  The report can be easily modified to show a different region.
  • Disk Space – This report uses gauges and a script that reads the drive space on disk C and shows disk space used and disk space free.
  • Edit Global and User Parameters – This unique report is actually an interactive form showing how you can change data and update the global and user parameters.  Reports are not read only anymore.
  • Get IP – This report will get your current Internet IP address.   It will check it against a previous value created by this report and stored in a Global Parameter.   If the IP is different, the report runs.  If it is the same, the report will not produce any output.   This is useful if you want to email or text yourself if your IP changes.  This shows you how you can save data to the parameters.  Solves dynamic IP issues.
  • Get Web Page – This report shows you how easy it is to capture a Web Page and load the HTML into a Rich Text Control.
  • Hurricane Report – Captures an image from the internet.
  • Main Menu – The report is actually a customizable main menu for Sunset Reports.   You can use this as a starting point for your own menu.   Make sure you set the preference for the starting form to be “Main Menu Report Definition”.   If you need to get back to the regular program interface, close this menu holding down the Ctrl key.
  • Photo Album Slide Show – This report shows you how to display all the images in a folder in a report.   The script contains the code to create a file list from the parameter “Picture Folder”.  The file list is stored in a file named Index.XML.  This file is then used as the data source by using the report parameter XML Data Path.  You can change the design of the report to show one picture on a page.  Then using Window View, the pictures will cycle.