Archive

Posts Tagged ‘Exporting’

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.

Advertisements

PDF Export Options

May 23, 2012 Leave a comment

When you are using the print preview screen, you can choose how to export the report.   But if you want to set the report design to have the options associated with the export predefined, you will use the Report Properties window in the Report Designer to set the options.