Solved

Crystal - Export as CSV

Posted on 2015-01-14
6
166 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 167 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 167 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 22

Assisted Solution

by:Ido Millet
Ido Millet earned 166 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 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