[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crystal - Export as CSV

Posted on 2015-01-14
6
Medium Priority
?
199 Views
Last Modified: 2015-01-27
Hi there,

I have a report that I am trying to export as csv but as would be expected, all details are coming out in one line.  Does anyone know a work-around using crystal 11?

My report has two groups and the access database file I am using to create the report is also linked to an excel file.  I have tried all of the options available on export.  Right now it looks like I should export to excel, open the file and then save as csv there.

Thanks in advance for your help,
CS
0
Comment
Question by:rporter45
6 Comments
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 668 total points
ID: 40549686
What do you want the CSV to look like?

as I recall you don't have much control over the format.

mlmcc
0
 
LVL 35

Accepted Solution

by:
James0628 earned 668 total points
ID: 40550897
Yeah, that's kind of the point of CSV -- To get a record that contains a list of values.  If that's not what you want, we're going to need more info.  You want a workaround to do what, exactly?

 And is this report only going to be used to create the exported file, or will it sometimes be viewed/printed, and sometimes exported?

 James
0
 

Author Comment

by:rporter45
ID: 40553998
Hi there,

Let me get some details together for a better understanding - I don't think this can be done given all that I have tried this point but just in case,

Thank you -
CS
0
Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

 
LVL 23

Assisted Solution

by:Ido Millet
Ido Millet earned 664 total points
ID: 40555079
Alternatives to exporting to csv include options such as:
a) You could export to TEXT, but name it .csv
b) You could create or get one of the 3rd-party User Function Libraries  (UFLs) . This would allow Crystal formulas to create & write to a text file.
0
 

Author Closing Comment

by:rporter45
ID: 40572769
Hi there,

All solutions assisted - csv is not a format that allows for modification.  I couldn't export to text  because of the grouping but I realize that this avenue is essentially closed to what I want to do.

Thank you-
CS
0
 
LVL 35

Expert Comment

by:James0628
ID: 40573980
FWIW ...

 I don't know why the grouping would be an issue, but it might be possible to export to text, but use a formula to combine fields into a single string, separated by commas.  That way you could get a CSV formatted export, but with more control over the format.  That's why I asked if the report was only going to be exported, or if it could also be viewed/printed (you'd probably want the viewed/printed report to have a more "normal" format).

 James
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month20 days, 13 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question