Solved

Crystal - Export as CSV

Posted on 2015-01-14
6
163 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
ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sporadic user accounts locking out - 2003 AD functional level 6 106
Crystal Reports - Trim Data 7 48
Crystal Reports - group header 2 44
Crystal Reports 13 5 58
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

770 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