Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CSV Export

Status
Not open for further replies.

Kendel

Programmer
Apr 24, 2002
1,512
US
Hello:

I'm using Crystal 10.0.5.1177, when exporting my report to CSV file, it got a couple errors:

1. Page header repeat on every record.
2. Conditional suppress was displayed in the file

Does anyone has this kind of problem? How to fix it? Thanks.
 
Hi,

Crystal doesnt like exporting to CSV for some reason. Im not sure about your surpress problem but I know how to sort the header repeating. You will have to covert the report so that in runs on a command. Then above your command you want to put in a select statement that holds all your column names then union the statements together and surpress your page and or report headers.

eg

select
COMPANY as company,
NAME as name,
DATE as Date

union all

Select
company, name, date
from table
 
There is a fixes you can download: monthly hotfix, export driver fixes, and service packs. Go download the latest of each of these updates, and try this again.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top