rporter45
asked on
Crystal - Export as CSV
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
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
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
ASKER
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