Archive

Posts Tagged ‘Data Conversion Tool’

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.

Database Export Tool

May 25, 2012 Leave a comment

Sunset Reports can work as a great database export tool to retrieve data from a variety of sources and then save them to a different file format that can be used by other software.   Refer to the post on Data Sources to see all the possibilities for input.   The report design for exporting should be a simple table object.   Each column in the table will be a field that get’s exported.   The typical export types that can be used to create files that can be read by other software include:  XLS, XLSX, CSV, and Text.   The first figure shows how you would create a simple report design for defining the fields to include in the export.   You can decide which fields and in which order you want to them to appear.   By using the reports sorting and filtering options, you can define the order and what data is to be exported as well.   With the formatting property of each table cell, you can specify the format of each data element.

The next figure shows the export options you can attach to the report design.

For the CSV and Text exports you will find a property called “Encoding”.   This property has a dropdown list containing different encoding schemes.  In the list below, click on the link to learn more about each encoding scheme.

Windows-1252
US-ASCII
UTF-16
unicodeFFFE
utf-7
utf-8
utf-32

For more information about encoding, check out this MSDN article.