×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Export Crystal Data to CSV and include Sub-Report Data

Export Crystal Data to CSV and include Sub-Report Data

Export Crystal Data to CSV and include Sub-Report Data

(OP)
Good afternoon,

I have a Crystal Reports XI report that is pulling data from a SQL Server database. My report has about a dozen fields per record (listed on the details line) and it also has one sub-report that is pulling one field from a related table. The sub-report is populated with one record per line at most but is often blank as well. The sub-report looks just like any other field in the detail line when in preview or printed.

I'm trying to export this data to a CSV file for import into another system but it seems that Crystal is ignoring the sub-report data all together. The help file for Crystal says that it will not export sub-reports when they are in page header or page footer sections. Since my sub report is in the details line it seems that it should export. In testing, Crystal does export the sub-report data when using an export to TXT file but not to CSV. Is there a way that I can get this one piece of data to export to a CSV format?

All help is most appreciated! Thanks in advance.

RE: Export Crystal Data to CSV and include Sub-Report Data

Did you get this to work? You can try exporting to Microsoft Excel, open the file in Excel and save as type CSV. I tried this and it worked for me.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close