Solved

Can I append to a CSV file using RDC export?

Posted on 2004-10-05
8
299 Views
Last Modified: 2008-03-10
Hello everyone,

I need to find out if using RDC export to a CSV file, if it is possible to open a current CSV file and append to it....

I have an application that creates a new crystal report for each bill it processes...then appends that report to a PDF file.

I need to create an export file/table from those crystal reports to get a complete list/table of all the bills in one table.

Sorry for the run-ons...Can someone help...thanks.
0
Comment
Question by:VirtueTech
  • 4
  • 2
  • 2
8 Comments
 
LVL 22

Accepted Solution

by:
Ido Millet earned 250 total points
ID: 12227589
Crystal can't append CSV exports.
However, your application can do the append directly...

Alternatively, let Crystal export to a unique file name and then append the content of that file to the master CSV file.

Cheers,
- Ido
0
 
LVL 42

Assisted Solution

by:frodoman
frodoman earned 250 total points
ID: 12227615
This is not possible short of creating your own export dll.  The Crystal export dll will create a new file or overwrite an existing one - there's no provision for opening and appending.

Your best option in my opinion would be to export to different CSV files and then write your own application to open all of the individual csv files and append them into a single file.  This would have to be done outside of Crystal.

frodoman
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12227618
Ido was typing faster... :-)
0
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.

 

Author Comment

by:VirtueTech
ID: 12227624
Not even using the RDC component at runtime?
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12227639
Not even then - RDC still uses the same export dll's that you use from the viewer.

As Ido said, your application can extract the same data and append to files or you can export from Crystal and then open the exported file and append it elsewhere...

frodoman
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 12227816
Another alternative is to create or use one of the 3rd-party UFLs to write to a text file.

However, appending text files is trivial.  Why is this not a good solution for you?

Cheers,
- Ido
0
 

Author Comment

by:VirtueTech
ID: 12228536
In response to IDO:
We need a CSV file to send via net to an ecommerce exchange.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12228699
Regardless of the reason that you need the file, the answer is the same.  If you want to create a single file you'll have to write code to do it - unless you can find and use a 3rd party UFL.

Once the file is created you can process it for any purpose you'd like but Crystal alone isn't going to create a single file for you.

frodoman
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

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 …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

837 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