Just so it's in the archives.... Switching to PDF output eliminates the printing problems. To switch to PDF, we had to change the call to the VIEWRPT.CWR file like so: http://myserver/myreports/viewrpt.cwr?id=1&cmd=EXPORT&EXPORT_FMT=U2FPDF%3A0
(our Export_Fmt parameter was reading U2FHTML%3A3) Now, if I can just fix all the bugs this creates with our drill down reports.... (the original author was calling a javascript function to request the drill down report, but PDF cannot execute the javascript...) Thanks for all the help. Shawn -----Original Message----- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:32 AM To: CF-Talk Subject: RE: Printing Crystal Report from web page? Thanks to both Kevan and Frank. We ARE using the ActiveX control (well, the viewrpt.cwr file), but we can't use a native Crystal report because it includes the option to change the query parameters. In our case that would be a huge security hole. So, the reports are dumped to HTML (for now), but now we introduce problems when printing. We are digging through the documentation now to try using PDF. Thanks for the info though. Shawn -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 2:20 AM To: CF-Talk Subject: RE: Printing Crystal Report from web page? You can also get crystal to output to PDF, if like us you think the report viewers are a bit clunky. -----Original Message----- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 02:38 To: CF-Talk Subject: Re: Printing Crystal Report from web page? The best method I've found is to install Crystal Reports Developers Edition on your web server and use their ActiveX or Java viewers. This way you get perfect reports as they we designed to look and print. However there is a learning curve to integrate them with CF. All of the knowledge available to do this from the Crystal site involves ASP. In order to be as productive as possible, we purchased a product called ReCrystallize which generates the ASP pages for us. Both the input forms and the processing page to open the viewer and send in your report parameters. We basically discard the input form and create our own to suit our needs with CF. Of course we need to match the field names the generated processing page is expecting. Hope this helps, Frank Mamone ----- Original Message ----- From: "Shawn Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 4:37 PM Subject: OT: Printing Crystal Report from web page? > We have a number of crystal reports which get rendered to a web page. The > developer that set this stuff up has left us, leaving me to fix some minor > issues. For the most part, I don't have a problem working with the reports > themselves. However, using a Crystal report in a web page leaves me with a > few questions. The biggest of which is printing. > > The problem I'm seeing right now is that when we print a report (from the > web page), it will occasionally print half a line on one page, and the other > half on the next page. I modified the reports to leave some space in the > page footer, and to reserve space for the page footer, but I still see the > splitting of lines. > > Further digging shows that the print function is doing a javascript > window.print(); - so it's printing the web page, not the report itself. Any > suggestions how to deal with this issue? Thanks in advance. > > Shawn Grover > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
