Marlon, Any chance you'd share that?
Ken -----Original Message----- From: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:55 AM To: CF-Talk Subject: Re: cfreport Rick, I've done exactly this. I created a VB com wrapper to access the Crystal Object. Right now, I use the wrapper to pass username, password, dbname, servername, and selection formula and then export the report to a PDF (other formats are available, but mostly prove unusable :) ). After the PDF is generated, I serve it to the user via CFContent. It's kind of a convoluted way of doing things, but I didn't care for the crystal reports server either. Marlon ----- Original Message ----- From: "Rick Walters" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 17, 2002 9:38 AM Subject: RE: cfreport > More specifically, Crystal now has it's own webserver. So, the best > option seems to be to set up the crystal webserver and then run it in a > frame. I'm not fond of it because it sidesteps site security. Unless > someone out there has a way to integrate it with existing security, I > don't think it's a good way to offer your intellectual property over the > web. Crystal has it's own security framework that might be sufficient, > but I haven't seen a combined framework that passes parameters in a > secure manner between CF applications and CR8. > > Oh, if anyone is successfully doing this, please tell me. I am aware > that the class can be accessed using ASP, I'm looking for a Cold Fusion > solution. Maybe someone has a COM object for it, or maybe someone has > figured out some LDAP tricks to keep within the security framework. And > if so, the next step is to move the crystal server to it's own machine > and preserve the security. Crystal's web server is a resource hog. > > Good Fortune, > Richard Walters, > Webmaster, Davita Laboratory Services > [EMAIL PROTECTED] > (800) 604-5227 x 3525 > > >>> [EMAIL PROTECTED] 05/17/02 10:25AM >>> > nevermind... found this on the crystal reports website > > Unfortunately there is currently no integration with Crystal Reports 8 > and > the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports > and > Macromedia has released patches to allow version 6 and version 7 to > work > with the CF report tag. As this time there is no fix for Crystal > Reports 8 > to work with ColdFusion. > > > that sucks. > > Ken > > -----Original Message----- > From: Ken Beard [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 17, 2002 10:03 AM > To: CF-Talk > Subject: cfreport > > > Hello all, > > I am having trouble with the cfreport tag. I'm trying to connect to > an > oracle db, and I have created a dsn using the crystal reports oracle 8 > driver, which is verified as working in the cf administrator. > > this is what the CF5 docs say: > > <cfreport report = '/reports/monthlysales.rpt'> > {Departments.Department} = 'International' > </cfreport> > > and then on the same page but different they say: > > <cfreport report = "report_path" > orderBy = "result_order" > username = "username" > password = "password" > formula = "formula"> > > </cfreport> > > when i try this: > <cfreport report="dailytimesheets.rpt" username="cf" > password="fusion"></cfreport> > it can't find the report, even though the cfm and the rpt files are in > the > same directory. > > when i do this: > <cfreport report="D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt" > username="cf" password="fusion"></cfreport> > I get the error: > Error occurred while processing CFREPORT > > > An unexpected error occurred while using the Crystal Engine. > > Error number 692 ocurred (Error in File > D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or > export format.). > > > My thinking is that the cfdocs are just plain wrong and my syntax is > right.. > but I must be missing something. > > All help is appreciated. > > Ken Beard > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
