Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Can I append to a CSV file using RDC export?

Posted on 2004-10-05
8
Medium Priority
?
305 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 750 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 750 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
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 

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

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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

604 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