Crystal Reports Tools: Improve Performance While Saving Time and Money
  Resources  
Best sellers:
cView
Report Analyzer
cViewSERVER
 ReCrystallize
 

Buy Crystal Reports

Articles:
 Administration
Advanced
Basic
 Crystal eNL
Database
Financial
Problems Solved

 Books:
CR Books
Database Books
Developer Books
 
Tools:
All CR Tools
CR Analyzers
CR Bestsellers
DataBase Tools
CR Graphics
International
CR Mail UFLs
ReCrystallizePro
CR Schedulers
CR UFLs
CR Viewers


Add'l:
About us
Contact Us
cViewSUITE Ppt
Support
CR trial
 

Crystal Reports
on Steroids

Crystal Reports Basics: Exporting Crystal Reports

This is based on the book, Crystal Reports: A Beginner’s Guide. For more detail and explanation, plus practice exercises, order the book here.

If you are exporting data from Crystal Reports, please read: Reports vs. data. The article you are now reading will help you understand the process, though engaging in it defeats the purpose of having a reporting system in the first place.

With Crystal Reports 7.0 and higher, you can export with data. If selecting this option in Crystal Reports 8.0 and higher for someone with Crystal Reports 7.0 and lower, be sure to Save As to the appropriate version of Crystal Reports.

You can save the report as a PDF. When exporting to this or other none-Crystal Reports formats, you will lose drill down, record selection, and other features.

Text file formats: Remember to remove extraneous information (headers and footers are often a problem, though headings are usually not), as it’s likely to be included in the wrong places. See Crystal Reports: A Beginner’s Guide for details on this. Here are some formats you can save to:

  • Character-Separated Values (CHR). You pick the delimiter (e.g., tab, comma, space). It does allow you to choose date and number formats.
  • Comma-Separated Variable (CSV). This is a standard format used by a wide variety of databases and spreadsheet programs. It does allow you to choose date and number formats.
  • Data Interchange Format (DIF). This standard format allows you to choose date and number formats.
  • Tab-Separated Text (TTX). Tabs are the delimiters, text and values are in quotation marks. It does not allow you to choose date and number formats.
  • Tab-Separated Values (TSV). Tabs are the delimiters, text and values are in quotation marks. It does allow you to choose date and number formats.
  • Paginated Text (TXT). Uses spaces and page breaks to try matching the report’s layout.

The book Crystal Reports: A Beginner’s Guide explains these formats, and others, in more detail. Other formats include those of various specific programs (e.g., Excel), in addition to other generic formats.

 

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.