Solved

Crystal - Export as CSV

Posted on 2015-01-14
6
162 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 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 34

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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 34

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now