If I already had Crystal, I would do everything I could to make Crystal work. I've been through the wringer making printed pages work in CF, and the only thing that really worked for me was using COM and Word, but it was a poor solution to a complex problem. I started using Crystal Reports for .NET, and it's EXACTLY the solution that I've been looking for. I can generate any report that I need, but it took a learning curve to get to the point where I can make those reports work. I've got a couple of books that really helped, along with a burning desire to make it work. I haven't use the standalone version of Crystal but I think it's more powerful than the version that I have that came with my VS.Net. If that's the case, then you have everything you need to make beautiful reports. Stick with Crystal, I don't think you would regret it once you get it going. Other solutions I've seen are Access reports via COM and a custom tag that generates PDFs on the fly. The PDFs it generates are not of high quality but they do work.
Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:35 AM To: CF-Talk Subject: RE: Generating PDFs in CF Basically, Some of the pdf are just very simple - printable versions of pages, some are more complex in that they are copies of the the form that you filled out. Even though we are trying to be paperless, people here still like to have a printable and readable copy of what they requested so to have proof in case of questions. Some of the other would be more complex, basically copies of what they current have in Access now. We generate these reports based on queries, so I never exactly know what is going to need to be produced. These would be more complex as they require a header, footers, page numbers and proper page breaks and also need to be printed in landscape format. I have tried Crystal but it just does not seem to work correctly. If you have any links to what you mentioned below that would be great so that I could start researching. Thanks again, _Mario -----Original Message----- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:00 AM To: CF-Talk Subject: Re: Generating PDFs in CF Some questions: How complex and or regular are the PDFs you are trying to create? How often are you trying to create them? Quantity? Are you building them on the fly for viewing, or generating and saving them via CF? I have had great success: Building the PS by hand in CF, and running it through Ghostscript to generate a PDF Using cocoon and XML to generate the PDF on the fly for viewing Jerry Johnson >>> [EMAIL PROTECTED] 12/17/02 09:43AM >>> Hi, I was wondering if anyone has any information on how to create a PDF on the fly in CF. I have been told to look at Active PDF, but right now there is no money to purchase that tool, so I was looking of either a custom tag or maybe an article or two on how to do this. We are currently using CF 4.5 but will be using CFMX for J2EE within the 1st quarter of 2003, so maybe even a JSP library that does this would be an option. Thanks -Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm