Solved

Can I append to a CSV file using RDC export?

Posted on 2004-10-05
8
303 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
[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
  • 4
  • 2
  • 2
8 Comments
 
LVL 23

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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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 23

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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

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…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

707 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