Becky Edwards
asked on
How to export Crystal Report to CSV file with only one header row
I am running a Crystal report inside of BOE - and having it store in a file location as a CSV file.
The report has one header row and one detail row.
However, when the file extracts, it extracts the header row once for every detail row.
I only want the header row to extract one time.
Does anyone know how to do this? I have attached samples of setup and final results.
Becky
design_VIew_Crystal_Report.JPG
Export_Format_BOE.JPG
File_Destination_BOE.JPG
Testing_01082019.xls
The report has one header row and one detail row.
However, when the file extracts, it extracts the header row once for every detail row.
I only want the header row to extract one time.
Does anyone know how to do this? I have attached samples of setup and final results.
Becky
design_VIew_Crystal_Report.JPG
Export_Format_BOE.JPG
File_Destination_BOE.JPG
Testing_01082019.xls
ASKER
That would require user intervention. I really need for the file to be ready for pickup in the pickup location as a CSV.
But thank you for the information.
But thank you for the information.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! That worked perfectly! I totally missed that little checkbox.
BEcky
BEcky
You are welcome, glad I could help you :)
Try exporting to Excel sand saving as a csv.
mlmcc