Re: CF9's cfmail remove attribute not working at Crystal Tech
Thanks, Russ. Interesting. I've always ruled out using CF's temp directory for security reasons. I'm on shared hosting at CT. If I'm generating PDF invoices and account statements for customers, seems like I don't want them sitting around in the temp directory where other people on the same box could get into them. That's why I always have managed my own temp directory in my dir tree. Make sense? Or do you think there's a better way? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9's cfmail remove attribute not working at Crystal Tech
well if you are storing the attachments within your own webspace, then why not just have a schedule that cleans them up each night, then you wont have to worrk about deleting them before they been sent. On Wed, May 4, 2011 at 4:57 PM, Dave Burns cft...@burnsorama.com wrote: Thanks, Russ. Interesting. I've always ruled out using CF's temp directory for security reasons. I'm on shared hosting at CT. If I'm generating PDF invoices and account statements for customers, seems like I don't want them sitting around in the temp directory where other people on the same box could get into them. That's why I always have managed my own temp directory in my dir tree. Make sense? Or do you think there's a better way? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9's cfmail remove attribute not working at Crystal Tech
On Tue, May 3, 2011 at 7:23 PM, Dave Burns wrote: I just spent an hour working with a tech at Crystal Tech diagnosing an email problem which ended up with me realizing that the very convenient remove attribute that is new to CF9's cfmail tag will not work in their environment. The reason for this is that they don't use CF's built-in mail client, instead handing off to SmarterMail. Disable spooling alltogether with the spoolenable attribute of cfmail. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9's cfmail remove attribute not working at Crystal Tech
Uh, well, that's what I suggested in my original post. :-) I wanted to see if anyone else had experience with better ideas. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9's cfmail remove attribute not working at Crystal Tech
Jochem, that's an interesting idea and I'll give it some thought. The downside is that it will slow down page processing somewhat since sending mail would be synchronous. Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344235 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9's cfmail remove attribute not working at Crystal Tech
I just spent an hour working with a tech at Crystal Tech diagnosing an email problem which ended up with me realizing that the very convenient remove attribute that is new to CF9's cfmail tag will not work in their environment. The reason for this is that they don't use CF's built-in mail client, instead handing off to SmarterMail. So although CF believes an email has left the spooler and its attachments can be deleted, SmarterMail will still come back for them but fail when it finds the attachments are gone. What do people recommend as a viable way to deal with this (I assume everyone had to deal with this anyway before CF9)? Is the answer to set up a scheduled task that cleans out some directory of email attachments at regular intervals? db ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9's cfmail remove attribute not working at Crystal Tech
your host should actually be the ones cleaning up the temp folders not you :-) we run scheduled tasks to do things like this on all our servers 1. respool failed mail for 24 hours before deleting it 2. clean up all the coldfusion temp folders 3. delete old class files and reduce the memory usage. 4. delete old log files (not just CF) on top of these I actually review the CF logs and FusionReactor logs and inform customers of recurring problems so that they can fix them and improve the performanc eof their site. I can tell you now that not many hosts do that :-) -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 9 and Crystal Reports
Hello, I'm using ColdFusion 9 and Crystal Reports 8.5 an 9.0, runs normaly when I dont have to pass any param to RPT. But When I do, or, need to do, generate an error that I dont know how to solve This is the error http://www.rhfactor.com.br/images/error.png So, if someone knows something about! Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 and Crystal Reports v2008 or v8.5
I have the same problem here and I did all what you have done. The cfreport tag seems no working when the attribute report is specified in the tag but it works just fine while attribute template is. Don't know how to fix this problem. Any ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 and Crystal Reports v2008 or v8.5
No one? Just to add a little more info, the full install (all custom features) are done on my desktop while the CRPE32.dll is installed on the server in the System32 folder and is registered. As far as I know from searching the web and looking at Adobe's/Macromedia's technical issues articles, that dll is all that is needed on the server for this to work. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 and Crystal Reports v2008 or v8.5
Is anyone running CF8 and calling a crystal report (created with either version 8.5 or 2008) via the cfreport tag? We use Crystal Reports 8.5 with our VB6 apps but have never tried to use them with Coldfusion. I'm attempting that now (with either crystal v8.5 or with a 30-trial of the 2008 version) with no luck. My cfm page runs but I just get a blank screen. If I were doing this from scratch, what are the steps I need to take? Install Crystal 8.5 or 2008 on the server? I assume I need to install it on the server, or do I install it on my machine and then copy some of the dlls to the server and register them? Then call with the tag as follows: cfreport report = c:\inetpub\wwwroot\Database\Military_Billings\CFR_Templates\SBA.rpt/cfreport? What are the steps? And, what am I missing? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
crystal reports 11 and coldfusion 8
I have an existing reporting system in Crystal Reports 11. We are converting from vb.net to coldfusion 8. I want to be able to call these reports through coldfusion. Does anyone know if these are compatible? And if they are - what is the trick to making it work? Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: crystal reports 11 and coldfusion 8
http://asreports.riaforge.org/ And yes they are compatible. On 2/20/08, Kim Hoopingarner [EMAIL PROTECTED] wrote: I have an existing reporting system in Crystal Reports 11. We are converting from vb.net to coldfusion 8. I want to be able to call these reports through coldfusion. Does anyone know if these are compatible? And if they are - what is the trick to making it work? Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299356 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: crystal reports 11 and coldfusion 8
Thank you for your information. I am looking to understand what I need to install from the Crystal Reports 11 CD (and I assume this is done on the web server). Then can I get an example of the cfreport code that works. Here's my cfreport and all it is doing is returning back to the form. The Crystal Reports is not coming up. cfreport report=EmployeList.rpt datasource=employees username=xyz password=xyz ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: crystal reports 11 and coldfusion 8
http://asreports.riaforge.org/ And yes they are compatible. On 2/20/08, Kim Hoopingarner [EMAIL PROTECTED] wrote: I have an existing reporting system in Crystal Reports 11. We are converting from vb.net to coldfusion 8. I want to be able to call these reports through coldfusion. Does anyone know if these are compatible? And if they are - what is the trick to making it work? Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Crystal Reports 10 with stored procedures...
What is the preferred method for calling CR files from CF when the underlying rpt file calls a stored procedure that requires one or more parameters to be passed? That is, how do I pass parameters to a stored procedure from within the cfreport tag? Anybody done this before? thx, -dante ~| Create robust enterprise, web RIAs.Upgrade integrate Adobe Coldfusion MX7 with Flex 2http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Report and Crystal reports
I have been using the asp pages for years with crystal 9. Works great, but only 3 concurrent users. Several months ago I spent some time with my free support incident for my CR 11 upgrade trying to get everything working with version 11. I was successfull but it wasn't easy. Also, I never went to production because I am still upgrading a major app on a new production machine. I have some info at work. I will try and put my thoughts together and send you more info on Monday. If that is too long to wait, you may search their support site for their sample apps. They do have them, they are just extremely difficult to find. The report builder is great, but only to a point. I use it for mailing labels and such, but I cannot get it to duplicate the main report that we use for a newsletter that we publish. Just too many quirks and roadblocks. YOu just don't have the same finetooth control that you have in Crystal. I hope that changes, though. Anyone disagrees, I would be happy to send you a sample of the report to see if you can make the report builder do it. Later Dave Has anyone succeeded in getting this combination to work? We have tried many combinations and the instructions we could find to no avail. Please let me know what you did to make this work. -- Russel Madere Never Again! Rebuild New Orleans with Category 5 Protection ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Report and Crystal reports
I'm sorry, I searched for a message I expected to be posted and got the wrong one and replied to it. This is an old message. Subject is the same, but not the message I meant to reply to. I have been using the asp pages for years with crystal 9. Works great, but only 3 concurrent users. Several months ago I spent some time with my free support incident for my CR 11 upgrade trying to get everything working with version 11. I was successfull but it wasn't easy. Also, I never went to production because I am still upgrading a major app on a new production machine. I have some info at work. I will try and put my thoughts together and send you more info on Monday. If that is too long to wait, you may search their support site for their sample apps. They do have them, they are just extremely difficult to find. The report builder is great, but only to a point. I use it for mailing labels and such, but I cannot get it to duplicate the main report that we use for a newsletter that we publish. Just too many quirks and roadblocks. YOu just don't have the same finetooth control that you have in Crystal. I hope that changes, though. Anyone disagrees, I would be happy to send you a sample of the report to see if you can make the report builder do it. Later Dave ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How to create Crystal Reports 11 reports from ColdFusion?
I'm evaluating Crystal Reports XI Developer and it has a few things I'd like to use that aren't available in CF Report Builder. However, I'm not having any luck finding information about creating reports from ColdFusion (MX7). Livedocs say (only?) Crystal Reports version 9 and 10 can be called using cfreport, and version 11 hasn't t worked in my testing. Does anyone have a clue whether or not I can call CR11 reports from ColdFusion? If not, anyway to call through Java without buying a higher priced version? Thanks ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Crystal Tech or HostMySite? That's my problem!!!
That being said, my current site at HostMySite was very stable the first 6 months and now seems to go down a handful of times a day (based on my error reports and monitoring), which is probably due to some site on their that eats up CF resources but still really isn't acceptable. Bringing this up to HostMySite's support has not made much headway, and the initial improvement after the install of SeeFusion appears to have completely disappeared. I had a shared site on HMS for a few months, and from the beginning until I moved to a different host, I had daily error reports saying that CF couldn't connect to MySQL. HMS support tried to convince me the problem was that my code was sending too many requests to their shared MySQL server. I didn't like that answer, but chalked it up to using shared hosting. I have since moved to a VPS on Vivio, and have only received 3 error reports in the last few months. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Crystal Tech or HostMySite? That's my problem!!!
Hi: After a lot of researching I realized that Crystal Tech and HostMySite are two of the best for shared hosting of CF7.0 My current problem is which one has better support for CF7.0 and Flex? Which one is the first choise for all customers? This is not what I can find by searching but I can ask the experts who you are folks. Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Crystal Tech or HostMySite? That's my problem!!!
On Tuesday 28 November 2006 09:24, Ali Majdzadeh wrote: has better support for CF7.0 and Flex? Which one is the first choise for Do you need FDS or just remoting ? -- Tom Chiverton Helping to biannually brand low-risk features This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Crystal Tech or HostMySite? That's my problem!!!
I need FDS. thanks benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Crystal Tech or HostMySite? That's my problem!!!
On Tuesday 28 November 2006 09:53, Ali Majdzadeh wrote: I need FDS. AFAIK noone offers hosted FDS. -- Tom Chiverton Helping to dramatically introduce B2C networks This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Crystal Tech or HostMySite? That's my problem!!!
I've used both and personally prefer hostmysite.com. They just seem a little more responsive and quicker to do stuff. Plus they worked out a little cheaper for me. Neil On 11/28/06, Ali Majdzadeh [EMAIL PROTECTED] wrote: Hi: After a lot of researching I realized that Crystal Tech and HostMySite are two of the best for shared hosting of CF7.0 My current problem is which one has better support for CF7.0 and Flex? Which one is the first choise for all customers? This is not what I can find by searching but I can ask the experts who you are folks. Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Crystal Tech or HostMySite? That's my problem!!!
HMS. We're hosting a whole bunch with them right now, and although it looks like they're experiencing some growing pains, and take a little while to do certain configurations, all in all, we've been pretty happy with them. And we've been able to get pricing that was similar to crystaltech's, although we do have a bunch of servers with them, so it could've been a volume discount. Russ -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 4:54 AM To: CF-Talk Subject: Re: Crystal Tech or HostMySite? That's my problem!!! I need FDS. thanks benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Crystal Tech or HostMySite? That's my problem!!!
Yes, you'd need a dedicated box for that. CT has them at a pretty nice price too. Very good for starter situations and they seem solid for larger needs as well. On 11/28/06, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 28 November 2006 09:53, Ali Majdzadeh wrote: I need FDS. AFAIK noone offers hosted FDS. -- Tom Chiverton Helping to dramatically introduce B2C networks This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Losing Session Variables When Running A Crystal Report from Coldfusion 4.5
Greetings, Everyone. I have inherited an application that runs on Coldfusion 4.5 and Crystal Reports 8.5. The application has been running the Crystal Reports via an .asp interface. I have been asked to eliminate this interface and have the reports run directly from Coldfusion. I have had success with this conversion process with the exception that 'some' of the reports, after having ran and one has returned back to the application via the back button, all the session variables are gone. This only happens when running some of the reports. My question is why does this happen with only some reports and not others and how do I fix it? Regards, :)mary ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Report and Crystal reports
Has anyone succeeded in getting this combination to work? We have tried many combinations and the instructions we could find to no avail. Please let me know what you did to make this work. -- Russel Madere Never Again! Rebuild New Orleans with Category 5 Protection ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Report and Crystal reports
I have Crystal Reports working in a CF App, but not with cfreport. I am on an older version of Crystal (8.5) and plan to migrate everything to CF's Report Builder. My solution (this was several years ago) was to use some of the sample ASP pages that came with Crystal. I have a CF generated form that posts to an asp page that handles the object creation, report calling etc. Depending on how dedicated you are to Crystal, I would say give the CF Report builder a shot. There are some quirks, but also some work arounds. On 9/6/06, Russel Madere [EMAIL PROTECTED] wrote: Has anyone succeeded in getting this combination to work? We have tried many combinations and the instructions we could find to no avail. Please let me know what you did to make this work. -- Russel Madere Never Again! Rebuild New Orleans with Category 5 Protection ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfreport and Crystal Reports
about 6 years ago i create a custom tag to envoke a Crystal Report. At the time CF and CRW as is would produce an HTML CR not a real CRYSTAL REPORT to be dumped to the printer. Does the current version of CF allow you to create a real CR or is is still HTML? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Desperately Seeking Crystal Reports 8 Enterprise License (~30 Concurrent users)
Years ago my company made the (poor) decision to develop lots and lots of reports on Crystal Reports 8 Enterprise. We are now switching to new servers and have been unable to locate our old license(s). Version 8 is no longer sold, and we are moving away from Crystal to CF Reports and naturally don't want to incur the expense of an upgrade for such a short time period. Does anyone have any license(s) you would be willing to sell? Please let me know ASAP! Thanks! Rachel Maxim - - - - - - - - - - - - - - - - - - - - - - - - Creative Director Case Design/Remodeling, Inc. Case Handyman Services, LLC. :: direct 240.235.9748 :: toll free 800.426.9434 :: [EMAIL PROTECTED] CaseDesign.com - CaseHandyman.com 4701 Sangamore Road North Plaza Suite 40 Bethesda, MD 20816 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226858 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
scheduled task - Crystal Tech
I'm using Crystal Tech's scheduled task feature in their control panel - however the template I'm trying to schedule won't execute b/c the directory its in requires a login (via application.cfm) I've even tried adding code to the top of the page that is scheduled to indicate that the user is already logged in... still no luck Any help would be appreciated Tim ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224024 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: scheduled task - Crystal Tech
Move the file to a folder that is not protected by a login. The application.cfm will run b4 the file in question otherwise, and if this is where your login check is, the file will never get executed. Russ -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: 13 November 2005 12:46 To: CF-Talk Subject: scheduled task - Crystal Tech I'm using Crystal Tech's scheduled task feature in their control panel - however the template I'm trying to schedule won't execute b/c the directory its in requires a login (via application.cfm) I've even tried adding code to the top of the page that is scheduled to indicate that the user is already logged in... still no luck Any help would be appreciated Tim ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224026 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: scheduled task - Crystal Tech
Yeah... thought of that but didn't want to leave that template hanging out there unprotected... I think I may have worked it out... application file wasn't working right... we'll see when that task comes up for execution again... thanks for the suggestion tho Tim -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Sunday, November 13, 2005 8:18 AM To: CF-Talk Subject: RE: scheduled task - Crystal Tech Move the file to a folder that is not protected by a login. The application.cfm will run b4 the file in question otherwise, and if this is where your login check is, the file will never get executed. Russ -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: 13 November 2005 12:46 To: CF-Talk Subject: scheduled task - Crystal Tech I'm using Crystal Tech's scheduled task feature in their control panel - however the template I'm trying to schedule won't execute b/c the directory its in requires a login (via application.cfm) I've even tried adding code to the top of the page that is scheduled to indicate that the user is already logged in... still no luck Any help would be appreciated Tim ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224027 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Crystal Reports
Hi all, A current project we're working on requires integration with A LOT of Crystal Reports with ColdFusion MX 7. I haven't used Crystal Reports since version 3 of ColdFusion, and thus have forgotten how to do the integration, and how the Crystal Reports should be structured. This has just been dumped on my and we need an urgent solution (i.e. in next couple of days). If anyone can help with Crystal Reports and CF, please can you let me know. Drop me an email off list. Thanks. Regards Niklas ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212180 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Crystal Reports
Niklas, I've been dealing with the scourge of crystal for a long time. This is the solution I've had the most luck with. I know that this solution works with CR 8.5, but I'm not sure about newer versions. This solution also requires Crystal and .Net framework to be installed on the server. Essentially, I've got 1 asp.net page that I call using CFHTTP. I have the asp.net page write out a pdf file onto the harddrive and then I serve up the pdf via CF. HTH Marlon reportServer.aspx * %@ Page Language=VB AspCompat=true % % Server.ScriptTimeout = 360 % % dim App,Rpt,Export as object dim DllName,ServerName,DatabaseName,Login,Password,Report,SelectionFormula,DiskFileName as string dim FormatType as integer DllName = cstr(request.form(DllName)) ServerName = cstr(request.form(ServerName)) DatabaseName = cstr(request.form(DatabaseName)) Login = cstr(request.form(login)) Password = cstr(request.form(password)) Report = cstr(request.Form(report)) SelectionFormula = cstr(request.Form(SelectionFormula)) FormatType = cInt(request.Form(FormatType)) DiskFileName = cstr(request.Form(DiskFileName)) try App = Server.CreateObject(CrystalRuntime.Application) App.LogOnServer(DllName,ServerName,DatabaseName,login,Password) Rpt = App.OpenReport(Report,1) Rpt.MorePrintEngineErrorMessages = false Rpt.EnableParameterPrompting = false Rpt.DiscardSavedData Rpt.RecordSelectionFormula = SelectionFormula Export = Rpt.ExportOptions Export.DiskFileName = DiskFileName Export.FormatType = FormatType 'Always write to disk Export.DestinationType = CInt(1) Rpt.Export(False) response.Write(STATUS: OK) Catch ex As Exception response.Write(STATUS: ERRORbr/) response.Write(MESSAGE: + ex.toString() + br/) response.Write(SOURCE: + ex.source + br/) response.Write(STACK: + ex.StackTrace + br/ ) Finally Export = nothing Rpt = nothing App = nothing 'Force a garbage collection to release the object GC.Collect() End try % ** On 7/19/05, Niklas Richardson [EMAIL PROTECTED] wrote: Hi all, A current project we're working on requires integration with A LOT of Crystal Reports with ColdFusion MX 7. I haven't used Crystal Reports since version 3 of ColdFusion, and thus have forgotten how to do the integration, and how the Crystal Reports should be structured. This has just been dumped on my and we need an urgent solution (i.e. in next couple of days). If anyone can help with Crystal Reports and CF, please can you let me know. Drop me an email off list. Thanks. Regards Niklas ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212189 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Crystal Reports
Hi Marlon, Thanks for the info. But isn't there a way to use CFREPORT with Crystal? Thanks Niklas On 19/07/05, Marlon Moyer [EMAIL PROTECTED] wrote: Niklas, I've been dealing with the scourge of crystal for a long time. This is the solution I've had the most luck with. I know that this solution works with CR 8.5, but I'm not sure about newer versions. This solution also requires Crystal and .Net framework to be installed on the server. Essentially, I've got 1 asp.net page that I call using CFHTTP. I have the asp.net page write out a pdf file onto the harddrive and then I serve up the pdf via CF. HTH Marlon reportServer.aspx * %@ Page Language=VB AspCompat=true % % Server.ScriptTimeout = 360 % % dim App,Rpt,Export as object dim DllName,ServerName,DatabaseName,Login,Password,Report,SelectionFormula,DiskFileName as string dim FormatType as integer DllName = cstr(request.form(DllName)) ServerName = cstr(request.form(ServerName)) DatabaseName = cstr(request.form(DatabaseName)) Login = cstr(request.form(login)) Password = cstr(request.form(password)) Report = cstr(request.Form(report)) SelectionFormula = cstr(request.Form(SelectionFormula)) FormatType = cInt(request.Form(FormatType)) DiskFileName = cstr(request.Form(DiskFileName)) try App = Server.CreateObject(CrystalRuntime.Application) App.LogOnServer(DllName,ServerName,DatabaseName,login,Password) Rpt = App.OpenReport(Report,1) Rpt.MorePrintEngineErrorMessages = false Rpt.EnableParameterPrompting = false Rpt.DiscardSavedData Rpt.RecordSelectionFormula = SelectionFormula Export = Rpt.ExportOptions Export.DiskFileName = DiskFileName Export.FormatType = FormatType 'Always write to disk Export.DestinationType = CInt(1) Rpt.Export(False) response.Write(STATUS: OK) Catch ex As Exception response.Write(STATUS: ERRORbr/) response.Write(MESSAGE: + ex.toString() + br/) response.Write(SOURCE: + ex.source + br/) response.Write(STACK: + ex.StackTrace + br/ ) Finally Export = nothing Rpt = nothing App = nothing 'Force a garbage collection to release the object GC.Collect() End try % ** On 7/19/05, Niklas Richardson [EMAIL PROTECTED] wrote: Hi all, A current project we're working on requires integration with A LOT of Crystal Reports with ColdFusion MX 7. I haven't used Crystal Reports since version 3 of ColdFusion, and thus have forgotten how to do the integration, and how the Crystal Reports should be structured. This has just been dumped on my and we need an urgent solution (i.e. in next couple of days). If anyone can help with Crystal Reports and CF, please can you let me know. Drop me an email off list. Thanks. Regards Niklas ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212199 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Crystal Reports
Yes, you can use the CFReport tag, but I've never had good luck with it concerning formatting. Also, it produces an HTML version of the report vs. something easily printed. On 7/19/05, Niklas Richardson [EMAIL PROTECTED] wrote: Hi Marlon, Thanks for the info. But isn't there a way to use CFREPORT with Crystal? Thanks Niklas On 19/07/05, Marlon Moyer [EMAIL PROTECTED] wrote: Niklas, I've been dealing with the scourge of crystal for a long time. This is the solution I've had the most luck with. I know that this solution works with CR 8.5, but I'm not sure about newer versions. This solution also requires Crystal and .Net framework to be installed on the server. Essentially, I've got 1 asp.net page that I call using CFHTTP. I have the asp.net page write out a pdf file onto the harddrive and then I serve up the pdf via CF. HTH Marlon reportServer.aspx * %@ Page Language=VB AspCompat=true % % Server.ScriptTimeout = 360 % % dim App,Rpt,Export as object dim DllName,ServerName,DatabaseName,Login,Password,Report,SelectionFormula,DiskFileName as string dim FormatType as integer DllName = cstr(request.form(DllName)) ServerName = cstr(request.form(ServerName)) DatabaseName = cstr(request.form(DatabaseName)) Login = cstr(request.form(login)) Password = cstr(request.form(password)) Report = cstr(request.Form(report)) SelectionFormula = cstr(request.Form(SelectionFormula)) FormatType = cInt(request.Form(FormatType)) DiskFileName = cstr(request.Form(DiskFileName)) try App = Server.CreateObject(CrystalRuntime.Application) App.LogOnServer(DllName,ServerName,DatabaseName,login,Password) Rpt = App.OpenReport(Report,1) Rpt.MorePrintEngineErrorMessages = false Rpt.EnableParameterPrompting = false Rpt.DiscardSavedData Rpt.RecordSelectionFormula = SelectionFormula Export = Rpt.ExportOptions Export.DiskFileName = DiskFileName Export.FormatType = FormatType 'Always write to disk Export.DestinationType = CInt(1) Rpt.Export(False) response.Write(STATUS: OK) Catch ex As Exception response.Write(STATUS: ERRORbr/) response.Write(MESSAGE: + ex.toString() + br/) response.Write(SOURCE: + ex.source + br/) response.Write(STACK: + ex.StackTrace + br/ ) Finally Export = nothing Rpt = nothing App = nothing 'Force a garbage collection to release the object GC.Collect() End try % ** On 7/19/05, Niklas Richardson [EMAIL PROTECTED] wrote: Hi all, A current project we're working on requires integration with A LOT of Crystal Reports with ColdFusion MX 7. I haven't used Crystal Reports since version 3 of ColdFusion, and thus have forgotten how to do the integration, and how the Crystal Reports should be structured. This has just been dumped on my and we need an urgent solution (i.e. in next couple of days). If anyone can help with Crystal Reports and CF, please can you let me know. Drop me an email off list. Thanks. Regards Niklas ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212204 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Crystal Reports
We've handled the issue for clients in a slightly different way from Marlon, posting parameters for a report to the ASP template (sometimes on a separate server), then handling the redirect to the PDF through ASP. But the heart of the matter is the same: unless CFReport in CFMX7 plays much better with Crystal than previous versions, you're better off using some version of ASP scripting to work with the Crystal app. Crystal provides good examples of how to do this. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Crystal Reports is hurting my head
So my last three posts have all been about Crystal Reports. I can honestly say its been the worst experience of getting something to work with CF ever. At the moment i have Crystall 11 and CFMX 6.1 on my dev machine. Everytime i run the report i get the following message An unexpected error occurred while using the Crystal Engine. Unable to find error details file D:\My Documents\sites\cfr\ERROR.TXT, error was: Error attempting to open file to be mapped. I can only find one blog reference to this on the web/MM forums. Business Objects says that they wont help as its a CF issueaarrgg! So i just wanted to know if anyone actually has this setup working? Or what that error actually means? Many thanks, Andy J ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210476 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Crystal Reports is hurting my head
We're currently planning a move away from Crystal due to licensing costs and the nightmare in trying to hook up CF to XI. We're actually still running on V8.5 but had started to evaluate XI. However due to hair pulling and PC damage (from being thrown against walls) we're now looking elsewhere. In regards Business Objects ... well, the less said about them the better. Sorry I can't be of more help! Andy On 6/24/05, Andy Jarrett [EMAIL PROTECTED] wrote: So my last three posts have all been about Crystal Reports. I can honestly say its been the worst experience of getting something to work with CF ever. At the moment i have Crystall 11 and CFMX 6.1 on my dev machine. Everytime i run the report i get the following message An unexpected error occurred while using the Crystal Engine. Unable to find error details file D:\My Documents\sites\cfr\ERROR.TXT, error was: Error attempting to open file to be mapped. I can only find one blog reference to this on the web/MM forums. Business Objects says that they wont help as its a CF issueaarrgg! So i just wanted to know if anyone actually has this setup working? Or what that error actually means? Many thanks, Andy J ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210477 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Crystal Reports is hurting my head
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We have also moved away from Crystal Reports and currently using OpenReports which uses JasperReports to generate the Reports. OpenReports is located at http://opensourcesoft.net/index.php Andy Jarrett wrote: So my last three posts have all been about Crystal Reports. I can honestly say its been the worst experience of getting something to work with CF ever. At the moment i have Crystall 11 and CFMX 6.1 on my dev machine. Everytime i run the report i get the following message An unexpected error occurred while using the Crystal Engine. Unable to find error details file D:\My Documents\sites\cfr\ERROR.TXT, error was: Error attempting to open file to be mapped. I can only find one blog reference to this on the web/MM forums. Business Objects says that they wont help as its a CF issueaarrgg! So i just wanted to know if anyone actually has this setup working? Or what that error actually means? Many thanks, Andy J ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210478 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Crystal reports
Is anyone actually using CR XI on CFMX 6.1 or CFMX 7? Andy Hi there, I cant seem to find this anywere but is it possible to pass parameters to Crystal (11) via CFMX 6.1? The report is expecting an ID to be passed to it i.e. 200 which in turn passes to a Stored Procedure (on MSSQL) to create the query. Cheers for any help Andy J www.andyjarrrett.co. uk ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209092 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Crystal reports
Hi there, I cant seem to find this anywere but is it possible to pass parameters to Crystal (11) via CFMX 6.1? The report is expecting an ID to be passed to it i.e. 200 which in turn passes to a Stored Procedure (on MSSQL) to create the query. Cheers for any help Andy J www.andyjarrrett.co.uk ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209000 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Any use for Crystal Reports under CF7?
We still run 6.1, but have received our 7.0 upgrade, and will be installing it in a test environment soon. I still have a budget item for Crystal Reports for this year. I am trying to figure out if I still need it, or if the new reporting capability available through version 7 will suffice. At a cost of under $50 for CR, I may well still get it, but scheduling staff training might be a waste of time and money if CF7 will do the vast majority of what CR purports to be able to do. Any opinions? TIA Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206534 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Any use for Crystal Reports under CF7?
$50 for CR? On 5/12/05, Claremont, Timothy [EMAIL PROTECTED] wrote: We still run 6.1, but have received our 7.0 upgrade, and will be installing it in a test environment soon. I still have a budget item for Crystal Reports for this year. I am trying to figure out if I still need it, or if the new reporting capability available through version 7 will suffice. At a cost of under $50 for CR, I may well still get it, but scheduling staff training might be a waste of time and money if CF7 will do the vast majority of what CR purports to be able to do. Any opinions? TIA Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206535 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Any use for Crystal Reports under CF7?
CF is under fifty bucks through non-profit software distribution channels, which our organization qualifies for. $50 for CR? On 5/12/05, Claremont, Timothy [EMAIL PROTECTED] wrote: ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Any use for Crystal Reports under CF7?
Sorry, that should say CR is under $50, NOT CF... CF is under fifty bucks through non-profit software distribution channels, which our organization qualifies for. $50 for CR? On 5/12/05, Claremont, Timothy [EMAIL PROTECTED] wrote: ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any use for Crystal Reports under CF7?
Where did you go through to get that? I do work for a few non-profits that could benefit from that. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 1:10 PM To: CF-Talk Subject: Re: Any use for Crystal Reports under CF7? CF is under fifty bucks through non-profit software distribution channels, which our organization qualifies for. $50 for CR? On 5/12/05, Claremont, Timothy [EMAIL PROTECTED] wrote: ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206560 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any use for Crystal Reports under CF7?
The last time I mentioned this it was constued by many to be advertising or spamming, so feel free to email me at the address in my posts and I will be more than happy to provide you with the link to the site. Where did you go through to get that? I do work for a few non-profits that could benefit from that. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 1:10 PM To: CF-Talk Subject: Re: Any use for Crystal Reports under CF7? CF is under fifty bucks through non-profit software distribution channels, which our organization qualifies for. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Crystal Reports on CFMX 6.1/7
Hi, Do i need to install the complete Crystal Reports 10 on the server to user cfreport as i currently have only got it working after doing so (locally). Or is there just a couple of key componets (files) that need installing?? Cheers Andy J www.andyjarrett.co.uk ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205552 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Crystal Reports on CFMX 6.1/7
I believe that is the easiest way to go. Please note that the cfreport tag will not work with reports that use CR Parameters. This is a major limitation for us. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Andy Jarrett [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 10:31 AM To: CF-Talk Subject: Crystal Reports on CFMX 6.1/7 Hi, Do i need to install the complete Crystal Reports 10 on the server to user cfreport as i currently have only got it working after doing so (locally). Or is there just a couple of key componets (files) that need installing?? Cheers Andy J www.andyjarrett.co.uk ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:20 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Crystal Reports on CFMX 6.1/7
I didn't think Crystal Reports was needed on the server to use the cfreport tag in CFMX7? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Crystal Reports on CFMX 6.1/7
If you want to server up a Crystal Report with cfreport I believe you would
need CR installed. In CFMX7 cfreport can also be used for the new
ColdFusion reports created with the built in report generator.
quote
src=http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1476.htm;
Creating reports with Crystal Reports (Windows only)
When running on Windows, the cfreport tag also supports the execution of
reports created using Crystal Reports version 9 or 10.
Note: When you install Crystal Reports, you must select the Enable export to
HTML and Enable export to Disk options. These options are not enabled by
default, so you must use the Custom Install option.
To invoke a Crystal Report report definition using the cfreport tag:
1. Create a report definition in Crystal Reports.
2. Create a CFM page and add a cfreport tag that invokes the Crystal Reports
report definition. The following example shows the cfreport tag invoking a
Crystal Reports report definition and passing a filter condition:
cfreport report = '/reports/monthlysales.rpt'
{Departments.Department} = 'International'
/cfreport
3. Open a browser and display the CFM page.
Tip: ColdFusion MX uses COM to call Craxdrt9.dll for Crystal Reports version 9,
and Craxdrt.dll for Crystal Reports version 10. If you have problems with the
cfreport tag, ensure that these DLLs are registered and, if not, use regsvr32
to register them (the default location for these DLLs is C:\Program
Files\Crystal Decisions\Report Designer Component\).
For complete information on defining reports in Crystal Reports, see the
Crystal Reports documentation.
/quote
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia Dunning
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 10:46 AM
To: CF-Talk
Subject: RE: Crystal Reports on CFMX 6.1/7
I didn't think Crystal Reports was needed on the server to use the
cfreport tag in CFMX7?
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include stdjoke.h
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205559
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Crystal X1
Can anyone advise is CFREPORT will work with Crystal Report XI files. ++ Kevin Parker Web Services Consultant WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198073 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Crystal X1
Nope. -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 3:57 PM To: CF-Talk Subject: Crystal X1 Can anyone advise is CFREPORT will work with Crystal Report XI files. ++ Kevin Parker Web Services Consultant WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198122 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Crystal X1
Can anyone advise is CFREPORT will work with Crystal Report XI files. I have experience with 10, not 11, but it should be pretty much the same... whats up? -- [EMAIL PROTECTED] http://www.jehiah.com/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198127 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Crystal X1
Just want to try some stuff with CFREPORT (instead of coding it up) and I have XI - When checking this out myself it wasn't clear and I got a sense that CF only ran up to 8. ++ Kevin Parker Web Services Consultant WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ -Original Message- From: Jehiah Czebotar [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 March 2005 4:03 PM To: CF-Talk Subject: Re: Crystal X1 Can anyone advise is CFREPORT will work with Crystal Report XI files. I have experience with 10, not 11, but it should be pretty much the same... whats up? -- [EMAIL PROTECTED] http://www.jehiah.com/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198128 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMAIL and Crystal Tech webhosting?
u. the geek in me just had to visit that web site. There, I said it. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185840 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMAIL and Crystal Tech webhosting?
Hi everyone - this one has me stumped. I'm hosting a CF site on Crystal Tech, and added a simple page that allowed a visitor to send a hey look at this page email to a friend. I already had a contact us page that sent me an email via CFMAIL which worked fine. The new page only works when the destination email is in the same domain as the website. I've tried all combinations that I can think of in terms of SMTP server name, username, password in the CFMAIL tag, with no luck. I checked their knowledgebase and modeled my CFMAIL tag info after the PHP example, still no luck. I've forced the FROM address to be a legal address on my domain, still no luck. I've posted a ticket with Crystal Tech but am still waiting for a response, and was really hoping to get this simple little page up quickly! Any Idea? Thanks, -reed ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185758 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMAIL and Crystal Tech webhosting?
Can you post the code in question? I've coded what you're after and it's worked on CT servers (CF 5). - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185763 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMAIL and Crystal Tech webhosting?
I have a dozen or more cfmails set up on CT and they all work fine. The key is mainly setting your server name attribute correctly. If it doesn't match your mail server, you're screwed. Here's an example of one of mine. cfmail SUBJECT =#FORM.name# would like to tell you about Kennedy Shipyards FROM=#FORM.email# TO=#FORM.recipemail# server=#mailserver# Your friend #FORM.name# thought you might like to know about a great site they found on the web. cfif #FORM.message# NEQ Your friend included this message: #FORM.message# /cfif WHERE IT IS: www.kennedyshipyards.com WHAT IT IS: Kennedy Shipyards is your exclusive source for original, fan-produced, sci-fi, real space, and WW II blueprints and memorabilia found NOWHERE ELSE on earth! Some of these include the Babylon-5 Starfury, Star Treks U.S.S. Enterprise, the Space 1999 Hawk, Eagle, and the Gerry Anderson UFO Interceptor. We also have WW II warbirds such as the P-51 Mustang and P-38 Lightning and real space Apollo, Gemini, Mercury and Saturn-V blueprints. This is just a partial listing of what we have to offer. Many more are only a click away. Kennedy Shipyards also carries hard to find collectibles and FX quality fine scale models. Search our site for blueprints and models that interest you from the online catalog page. Don't forget to visit the KSY gallery and see tons of photos of our highly detailed, fx-quality models. See you soon! Kennedy Shipyards [EMAIL PROTECTED] /cfmail ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT - Crystal Reports Training
I am looking for Crystal Reports training.Has anyone ever taken any classes like this?What companies would you reccomend?Cost isn't really an issue.I would like something in either N.C. or S.C, but anywhere will do.Time is the most important factor here.The sooner I can find a class, the better. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT - Crystal Reports Training
We teach one, though it's not listed on ColdFusionTraining.com.We had used CR since V4 days (it's now at V10), and we needed to support some pathologists that wanted to learn the product, so it was relatively straightforward for us to develop a curriculum and teach a very nice two-day course. What level of Crystal Reports functionality are you trying to learn? Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Todd [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:09 AM Subject: SOT - Crystal Reports Training I am looking for Crystal Reports training.Has anyone ever taken any classes like this?What companies would you reccomend?Cost isn't really an issue.I would like something in either N.C. or S.C, but anywhere will do.Time is the most important factor here.The sooner I can find a class, the better. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Report Generator - Crystal Reports?
Personally I would burn the Crystal Reports box... The quality of the software is so bad, it is unbelievable. I have to come up with one developer which actually likes Crystal Reports and indeed worked with it. - invalid formattings, you need to do a lote of odd save, close, and re-open things to workaround these. - continuously dragging lines to create a simple table. - change something in the text, and you need to realign everything, and execute point 2 again. I personally prefer Oracle's solution, that one is really good (select layout, select data, press next next next next next, done!) but unfortunately very expensive. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Report Generator - Crystal Reports?
Wouldnt a output XML and add XSLT for PDF and transformations help? MD On Fri, 10 Sep 2004 08:52:18 -0400, Rick Root [EMAIL PROTECTED] wrote: Jeff Chastain wrote: I am working on an application that will need to generate a wide variety of reports and invoices, preferable with output to the web and in PDF that could then be printed or emailed.This application is going to be used by different customers, so that ability to brand the reports and invoices is very important. Keff. We use JasperReports, an open source java reporting tool, to generate a variety of reports here in University Development at Duke.It was a lot of work to implement - particularly learning how to use one of the various avaialble report designers (mostly now that I know what I'm doing, I avoid the report designer almost entirely and hand-code the XML report designs) It works nicely for generating PDFs. I do, however, look forward to the day when I can dump jasperreports in favor of Blackstone.I don't think there are many people out there using jasperreports with CF, and I was *mostly* on my own for figuring out how to get it implemented. I blogged some of the process (fairly poorly) here: http://blog.rickroot.com/blog/index.cfm?mode=entryentry=8ACD1BF0-749F-13E8-4B62D4263D19A701 - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Report Generator - Crystal Reports?
I think I might have sent this straight to David instead of to the list.If it double posts on the list, I apologize.If the attachment doesn't work on the list I will post somewhere else. This is a sample of the email I send out to those who inquire.I have had many inquiries so I have made a template of such to make sending them instruction easier and quicker. I am able to create crystal reports from from my web browser using the attached asp file.I pass variables like so: Just put show_report.asp in your form statement.Here is an example. FORM ACTION='' METHOD='post' input name=report_file type=hidden value=coverpage.rpt input name=pm_week type=hidden value=#varweek# input name=pm_year type=hidden value=2003 input name=pm_areaabbr type=hidden value=#getinfo.areaabbr# input type=submit value='Cover Page' /FORM Anything that starts with pm_ is sent to the report to match the parameters you can define in Crystal. If your report has no parameters you would really only need FORM ACTION='' METHOD='post' input name=report_file type=hidden value=coverpage.rpt input type=submit value='Cover Page' /FORM Your report needs to be in the /rptfiles directory and you need an /output directory for the pdf file.You might also need to give the output file a name(actually I think it gives a default so nevermind that).Can't remember, cause I always pass client.cfid.But it might require that. I have attached the asp file I use.This has been the only way I have been able to do what you are talking about. P.S. I hear that the upcoming blackstone release of Cold Fusion will have this built in.I hope so. - Original Message - From: David Brown [EMAIL PROTECTED] Date: Fri, 10 Sep 2004 10:38:22 -0400 Subject: Fw: Report Generator - Crystal Reports? To: [EMAIL PROTECTED] Hello, I would be interested in the asp code for the reporting and the instructions for it.We always need reporting options for web applications we create here.We have crystal reports 9 too, but we have not been able to have reporting built into the web app. Thanks a head of time David - Original Message - From: David Mineer To: CF-Talk Sent: Friday, September 10, 2004 12:14 AM Subject: Re: Report Generator - Crystal Reports? I use a fairly simple .asp page to dynamically generate pdf files. You would have to have a version of Crystal Reports installed on the server.I have 9.0 installed and that provides the necessary .dll's that the asp page interfaces with.All my stuff is in cf, I only pass the info I need to the .asp page as the last step on the way to presenting the .pdf to the user in their web browser.Be happy to provide more info if you would like.I have a copy of the .asp code and instructions I have sent to others.Let me know if you would like it. I have been excited about the posibility of the new blackstone release making this much easier.Last year at max I got the feeling we could look forward to it.I hope so.I never could make this work with CFOBJECT even though I was able to find some info on it.So, until blackstone I just use the .asp page.Someone smarter might be able to make it work with cfobject and then you wouldn't need the .asp code. - Original Message - From: Jeff Chastain [EMAIL PROTECTED] Date: Thu, 9 Sep 2004 20:31:10 -0500 Subject: Report Generator - Crystal Reports? To: CF-Talk [EMAIL PROTECTED] I am working on an application that will need to generate a wide variety of reports and invoices, preferable with output to the web and in PDF that could then be printed or emailed.This application is going to be used by different customers, so that ability to brand the reports and invoices is very important. I have never used Crystal Reports, but I have heard it mentioned quite a few times in the context of CFMX.Can anybody make any recommendations as to Crystal Reports or another method for building this kind of functionality? Thanks -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Report Generator - Crystal Reports?
Well at the rate the client keeps growing this project, it may never get finished.I had heard about some of the reporting in Blackstone, but no details.I signed up for the beta, but I guess I will have to wait. Any other solutions out there if Blackstone is not ready or suitable? Thanks -- Jeff Jeff, An alternative is to use HTMLDoc (see http://www.easysw.com) on your server and call it either via cfexecute or using the custom tag CF_Html2Pdf3. That one works very well, but you have to have HTMLDoc installed on your server. I've also used this approach with our employment application (internal only). Basically sandwich your output between CF_Html2Pdf3 tags and it automatically converts the content to a PDF. You can download CF_Html2Pdf3 at the Macromedia CF exchange: http://www.macromedia.com/cfusion/exchange/index.cfm#view=sn106viewName=Exchange%20Search%20Detailsloc=en_usauthorid=35342392page=0scrollPos=0subcatid=0snid=sn106itemnumber=0extid=1002789catid=0 >From the exchange: CF_HTML2PDF3 allows you to create PDF files from any dynamic CFM page simply by encasing whatever portion of the page you wish to display inside the opening and closing CF_HTML2PDF3 tags. usage syntax: CF_HTML2PDF3 myHTMLDOC=c:\cfusion\htmldoc.exe myOPTIONS=--landscape --fontsize 10pt TABLE CFOUTPUT QUERY=myQuery TRTD#myData#/TD/TR /CFOUTPUT/TABLE /CF_HTML2PDF3 There are some limitations, no CSS, forms or JS and HTMLDoc is limited to HTML 3.1 but otherwise it works as advertised. hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Report Generator - Crystal Reports?
I am working on an application that will need to generate a wide variety of reports and invoices, preferable with output to the web and in PDF that could then be printed or emailed.This application is going to be used by different customers, so that ability to brand the reports and invoices is very important. I have never used Crystal Reports, but I have heard it mentioned quite a few times in the context of CFMX.Can anybody make any recommendations as to Crystal Reports or another method for building this kind of functionality? Thanks -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Report Generator - Crystal Reports?
What's your time frame for delivering the app? Blackstone is supposed to have a very nice RG built-in. (I can talk about it because I am not in the beta) Seriously,MM has been pretty good about meeting delivery schedules I've heard that Blackstone will be available early next year. Dick On Sep 9, 2004, at 6:31 PM, Jeff Chastain wrote: I am working on an application that will need to generate a wide variety of reports and invoices, preferable with output to the web and in PDF that could then be printed or emailed. This application is going to be used by different customers, so that ability to brand the reports and invoices is very important. I have never used Crystal Reports, but I have heard it mentioned quite a few times in the context of CFMX. Can anybody make any recommendations as to Crystal Reports or another method for building this kind of functionality? Thanks -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Report Generator - Crystal Reports?
Well at the rate the client keeps growing this project, it may never get finished.I had heard about some of the reporting in Blackstone, but no details.I signed up for the beta, but I guess I will have to wait. Any other solutions out there if Blackstone is not ready or suitable? Thanks -- Jeff _ From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 8:43 PM To: CF-Talk Subject: Re: Report Generator - Crystal Reports? What's your time frame for delivering the app? Blackstone is supposed to have a very nice RG built-in. (I can talk about it because I am not in the beta) Seriously,MM has been pretty good about meeting delivery schedules I've heard that Blackstone will be available early next year. Dick On Sep 9, 2004, at 6:31 PM, Jeff Chastain wrote: I am working on an application that will need to generate a wide variety of reports and invoices, preferable with output to the web and in PDF that could then be printed or emailed.This application is going to be used by different customers, so that ability to brand the reports and invoices is very important. I have never used Crystal Reports, but I have heard it mentioned quite a few times in the context of CFMX.Can anybody make any recommendations as to Crystal Reports or another method for building this kind of functionality? Thanks -- Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Report Generator - Crystal Reports?
I use a fairly simple .asp page to dynamically generate pdf files. You would have to have a version of Crystal Reports installed on the server.I have 9.0 installed and that provides the necessary .dll's that the asp page interfaces with.All my stuff is in cf, I only pass the info I need to the .asp page as the last step on the way to presenting the .pdf to the user in their web browser.Be happy to provide more info if you would like.I have a copy of the .asp code and instructions I have sent to others.Let me know if you would like it. I have been excited about the posibility of the new blackstone release making this much easier.Last year at max I got the feeling we could look forward to it.I hope so.I never could make this work with CFOBJECT even though I was able to find some info on it.So, until blackstone I just use the .asp page.Someone smarter might be able to make it work with cfobject and then you wouldn't need the .asp code. - Original Message - From: Jeff Chastain [EMAIL PROTECTED] Date: Thu, 9 Sep 2004 20:31:10 -0500 Subject: Report Generator - Crystal Reports? To: CF-Talk [EMAIL PROTECTED] I am working on an application that will need to generate a wide variety of reports and invoices, preferable with output to the web and in PDF that could then be printed or emailed.This application is going to be used by different customers, so that ability to brand the reports and invoices is very important. I have never used Crystal Reports, but I have heard it mentioned quite a few times in the context of CFMX.Can anybody make any recommendations as to Crystal Reports or another method for building this kind of functionality? Thanks -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX and Crystal Reports
Having trouble with CFReport... I read and followed macromedia technote on crystal reports for version 9 as well as the technote to fix this error but its still not working Here is my code: cfreport report= #GetDirectoryFromPath(CF_TEMPLATE_PATH)#WaitListByDate.rpt datasource=waitlist username=usernamehere password=passwordhere /cfreport Error message: An unexpected error occurred while using the Crystal Engine. Error number 536 ocurred (Error in File C:\INETPUB\WWWROOT\WAITLIST.WILSONTECH.ORG\WAITLISTBYDATE.RPT: Unable to connect: incorrect log on parameters.). The error occurred in C:\Inetpub\wwwroot\WaitList.wilsontech.org\reports.cfm: line 4 2 : datasource=waitlist 3 : username=sa 4 : password=SwordFish. 5 : /cfreport Can anyone help me? Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX and Crystal Reports
Hey Kris, I've had similar problems when trying to do some heavy CF reports integration, and found that the easiest thing to do was to bite the bullet and use the ASP examples that Business Objects includes with Crystal.We pass an authentication id / token over to the ASP pages which then reauth and use the (pretty spiffy) Crystal viewers (Java or ActiveX depending on platform). Also, you may want to go change your SA password now. -joe - Original Message - From: Kristopher Pilles [EMAIL PROTECTED] Date: Wed, 4 Aug 2004 09:23:22 -0400 Subject: CFMX and Crystal Reports To: CF-Talk [EMAIL PROTECTED] Having trouble with CFReport... I read and followed macromedia technote on crystal reports for version 9 as well as the technote to fix this error but its still not working Here is my code: cfreport report= #GetDirectoryFromPath(CF_TEMPLATE_PATH)#WaitListByDate.rpt datasource=waitlist username=usernamehere password=passwordhere /cfreport Error message: An unexpected error occurred while using the Crystal Engine. Error number 536 ocurred (Error in File C:\INETPUB\WWWROOT\WAITLIST.WILSONTECH.ORG\WAITLISTBYDATE.RPT: Unable to connect: incorrect log on parameters.). The error occurred in C:\Inetpub\wwwroot\WaitList.wilsontech.org\reports.cfm: line 4 2 : datasource=waitlist 3 : username=sa 4 : password=SwordFish. 5 : /cfreport Can anyone help me? Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX and Crystal Reports
YEah oops... noticed that afterwards... already done... -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:38 AM To: CF-Talk Subject: Re: CFMX and Crystal Reports Hey Kris, I've had similar problems when trying to do some heavy CF reports integration, and found that the easiest thing to do was to bite the bullet and use the ASP examples that Business Objects includes with Crystal.We pass an authentication id / token over to the ASP pages which then reauth and use the (pretty spiffy) Crystal viewers (Java or ActiveX depending on platform). Also, you may want to go change your SA password now. -joe - Original Message - From: Kristopher Pilles [EMAIL PROTECTED] Date: Wed, 4 Aug 2004 09:23:22 -0400 Subject: CFMX and Crystal Reports To: CF-Talk [EMAIL PROTECTED] Having trouble with CFReport... I read and followed macromedia technote on crystal reports for version 9 as well as the technote to fix this error but its still not working Here is my code: cfreport report= #GetDirectoryFromPath(CF_TEMPLATE_PATH)#WaitListByDate.rpt datasource=waitlist username=usernamehere password=passwordhere /cfreport Error message: An unexpected error occurred while using the Crystal Engine. Error number 536 ocurred (Error in File C:\INETPUB\WWWROOT\WAITLIST.WILSONTECH.ORG\WAITLISTBYDATE.RPT: Unable to connect: incorrect log on parameters.). The error occurred in C:\Inetpub\wwwroot\WaitList.wilsontech.org\reports.cfm: line 4 2 : datasource=waitlist 3 : username=sa 4 : password=SwordFish. 5 : /cfreport Can anyone help me? Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX and Crystal Reports
Never used cfreport.. However we use our own components to connect to a report, the use this component to pass the parameters to the report build the report in either PDF, XLS, or .Doc files. Which you then use cfcontent to view. A bit of a pain, but it works great. The best thing is that this component not only opens and runs a crystal report, but it can also change the datasource and table information if needed. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Kristopher Pilles [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 August 2004 12:02 AM To: CF-Talk Subject: RE: CFMX and Crystal Reports YEah oops... noticed that afterwards... already done... -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:38 AM To: CF-Talk Subject: Re: CFMX and Crystal Reports Hey Kris, I've had similar problems when trying to do some heavy CF reports integration, and found that the easiest thing to do was to bite the bullet and use the ASP examples that Business Objects includes with Crystal.We pass an authentication id / token over to the ASP pages which then reauth and use the (pretty spiffy) Crystal viewers (Java or ActiveX depending on platform). Also, you may want to go change your SA password now. -joe - Original Message - From: Kristopher Pilles [EMAIL PROTECTED] Date: Wed, 4 Aug 2004 09:23:22 -0400 Subject: CFMX and Crystal Reports To: CF-Talk [EMAIL PROTECTED] Having trouble with CFReport... I read and followed macromedia technote on crystal reports for version 9 as well as the technote to fix this error but its still not working Here is my code: cfreport report= #GetDirectoryFromPath(CF_TEMPLATE_PATH)#WaitListByDate.rpt datasource=waitlist username=usernamehere password=passwordhere /cfreport Error message: An unexpected error occurred while using the Crystal Engine. Error number 536 ocurred (Error in File C:\INETPUB\WWWROOT\WAITLIST.WILSONTECH.ORG\WAITLISTBYDATE.RPT: Unable to connect: incorrect log on parameters.). The error occurred in C:\Inetpub\wwwroot\WaitList.wilsontech.org\reports.cfm: line 4 2 : datasource=waitlist 3 : username=sa 4 : password=SwordFish. 5 : /cfreport Can anyone help me? Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX and Crystal Reports
Try out the CF_CR_ACTX tag... http://www.macromedia.com/cfusion/exchange/index.cfm#view=sn106 http://www.macromedia.com/cfusion/exchange/index.cfm#view=sn106viewName=Ex change%20Search%20Detailsloc=en_usauthorid=35342172page=0scrollPos=0sub catid=0snid=sn106itemnumber=0extid=1000680catid=0 viewName=Exchange%20Search%20Detailsloc=en_usauthorid=35342172page=0scr ollPos=0subcatid=0snid=sn106itemnumber=0extid=1000680catid=0 -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 2:23 PM To: CF-Talk Subject: RE: CFMX and Crystal Reports Never used cfreport.. However we use our own components to connect to a report, the use this component to pass the parameters to the report build the report in either PDF, XLS, or .Doc files. Which you then use cfcontent to view. A bit of a pain, but it works great. The best thing is that this component not only opens and runs a crystal report, but it can also change the datasource and table information if needed. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Kristopher Pilles [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 August 2004 12:02 AM To: CF-Talk Subject: RE: CFMX and Crystal Reports YEah oops... noticed that afterwards... already done... -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:38 AM To: CF-Talk Subject: Re: CFMX and Crystal Reports Hey Kris, I've had similar problems when trying to do some heavy CF reports integration, and found that the easiest thing to do was to bite the bullet and use the ASP examples that Business Objects includes with Crystal.We pass an authentication id / token over to the ASP pages which then reauth and use the (pretty spiffy) Crystal viewers (Java or ActiveX depending on platform). Also, you may want to go change your SA password now. -joe - Original Message - From: Kristopher Pilles [EMAIL PROTECTED] Date: Wed, 4 Aug 2004 09:23:22 -0400 Subject: CFMX and Crystal Reports To: CF-Talk [EMAIL PROTECTED] Having trouble with CFReport... I read and followed macromedia technote on crystal reports for version 9 as well as the technote to fix this error but its still not working Here is my code: cfreport report= #GetDirectoryFromPath(CF_TEMPLATE_PATH)#WaitListByDate.rpt datasource=waitlist username=usernamehere password=passwordhere /cfreport Error message: An unexpected error occurred while using the Crystal Engine. Error number 536 ocurred (Error in File C:\INETPUB\WWWROOT\WAITLIST.WILSONTECH.ORG\WAITLISTBYDATE.RPT: Unable to connect: incorrect log on parameters.). The error occurred in C:\Inetpub\wwwroot\WaitList.wilsontech.org\reports.cfm: line 4 2 : datasource=waitlist 3 : username=sa 4 : password=SwordFish. 5 : /cfreport Can anyone help me? Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX and Crystal Reports
Try the CF_CR_ACTX tag... -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 2:23 PM To: CF-Talk Subject: RE: CFMX and Crystal Reports Never used cfreport.. However we use our own components to connect to a report, the use this component to pass the parameters to the report build the report in either PDF, XLS, or .Doc files. Which you then use cfcontent to view. A bit of a pain, but it works great. The best thing is that this component not only opens and runs a crystal report, but it can also change the datasource and table information if needed. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Kristopher Pilles [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 August 2004 12:02 AM To: CF-Talk Subject: RE: CFMX and Crystal Reports YEah oops... noticed that afterwards... already done... -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:38 AM To: CF-Talk Subject: Re: CFMX and Crystal Reports Hey Kris, I've had similar problems when trying to do some heavy CF reports integration, and found that the easiest thing to do was to bite the bullet and use the ASP examples that Business Objects includes with Crystal.We pass an authentication id / token over to the ASP pages which then reauth and use the (pretty spiffy) Crystal viewers (Java or ActiveX depending on platform). Also, you may want to go change your SA password now. -joe - Original Message - From: Kristopher Pilles [EMAIL PROTECTED] Date: Wed, 4 Aug 2004 09:23:22 -0400 Subject: CFMX and Crystal Reports To: CF-Talk [EMAIL PROTECTED] Having trouble with CFReport... I read and followed macromedia technote on crystal reports for version 9 as well as the technote to fix this error but its still not working Here is my code: cfreport report= #GetDirectoryFromPath(CF_TEMPLATE_PATH)#WaitListByDate.rpt datasource=waitlist username=usernamehere password=passwordhere /cfreport Error message: An unexpected error occurred while using the Crystal Engine. Error number 536 ocurred (Error in File C:\INETPUB\WWWROOT\WAITLIST.WILSONTECH.ORG\WAITLISTBYDATE.RPT: Unable to connect: incorrect log on parameters.). The error occurred in C:\Inetpub\wwwroot\WaitList.wilsontech.org\reports.cfm: line 4 2 : datasource=waitlist 3 : username=sa 4 : password=SwordFish. 5 : /cfreport Can anyone help me? Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX and Crystal Reports
Tim, Thanks but it did not suit our needs, and our component has more features than that offers. Besides I don't need this help!! Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 August 2004 7:34 AM To: CF-Talk Subject: RE: CFMX and Crystal Reports Try the CF_CR_ACTX tag... -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 2:23 PM To: CF-Talk Subject: RE: CFMX and Crystal Reports Never used cfreport.. However we use our own components to connect to a report, the use this component to pass the parameters to the report build the report in either PDF, XLS, or .Doc files. Which you then use cfcontent to view. A bit of a pain, but it works great. The best thing is that this component not only opens and runs a crystal report, but it can also change the datasource and table information if needed. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Kristopher Pilles [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 August 2004 12:02 AM To: CF-Talk Subject: RE: CFMX and Crystal Reports YEah oops... noticed that afterwards... already done... -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 9:38 AM To: CF-Talk Subject: Re: CFMX and Crystal Reports Hey Kris, I've had similar problems when trying to do some heavy CF reports integration, and found that the easiest thing to do was to bite the bullet and use the ASP examples that Business Objects includes with Crystal.We pass an authentication id / token over to the ASP pages which then reauth and use the (pretty spiffy) Crystal viewers (Java or ActiveX depending on platform). Also, you may want to go change your SA password now. -joe - Original Message - From: Kristopher Pilles [EMAIL PROTECTED] Date: Wed, 4 Aug 2004 09:23:22 -0400 Subject: CFMX and Crystal Reports To: CF-Talk [EMAIL PROTECTED] Having trouble with CFReport... I read and followed macromedia technote on crystal reports for version 9 as well as the technote to fix this error but its still not working Here is my code: cfreport report= #GetDirectoryFromPath(CF_TEMPLATE_PATH)#WaitListByDate.rpt datasource=waitlist username=usernamehere password=passwordhere /cfreport Error message: An unexpected error occurred while using the Crystal Engine. Error number 536 ocurred (Error in File C:\INETPUB\WWWROOT\WAITLIST.WILSONTECH.ORG\WAITLISTBYDATE.RPT: Unable to connect: incorrect log on parameters.). The error occurred in C:\Inetpub\wwwroot\WaitList.wilsontech.org\reports.cfm: line 4 2 : datasource=waitlist 3 : username=sa 4 : password=SwordFish. 5 : /cfreport Can anyone help me? Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Crystal Reports (WAS: Absolute positioning in word)
Ok, now trying Crystal Reports but this project seems to be destined to drive me insane, I can't believe no one before me has had these problems! Now, the question: How does crystal reports want me to call tables from mysql?If I just use tablename then I get an error saying that test.tablename does not exist. I then assumed that is wanted a user name so I tried root.tablename but this doesn't exist either, as root is the only user on this dev box the table can't belong to any one else.In desperation I have also tried mylsam.tablename and sam.tablename and dbo.tablename but I could sit here trying random strings for ever and not hit the right one. Does anyone know how to do this? -- Jay -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED] Sent: 01 July 2004 14:10 To: CF-Talk Subject: RE: Absolute positioning in word (WAS: CSS layer positioning) As I say in my presentation, not everything that can be done in Word can be recreated through HTML-Word.This appears to be one of those cases. When I create a Word doc with an absolutely positioned table and try to save it as HTML I get this error message from Word Tables with text wrapping and framed objects will become aligned with the beginning of the paragraph. Sam -- Blog:http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 5:15 AM To: CF-Talk Subject: RE: Absolute positioning in word (WAS: CSS layer positioning) Hi Samuel, Firstly I have to say your original documents on serving word were most helpful. Now back to my problem, if I position a table in an absolute position on the page in word then save it as a doc file it works fine, however it is a binary file and therefore useless as a source of information. If I save it as an HTML document as you suggest it immediately moves the table into a relative position and looses its absolute position, this is also no good :-( A text box does seem to keep it's position ok, but generates so much html code it is hard to tell which bits I need and which I don't, is there any good documentation anywhere on this? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Crystal Reports (WAS: Absolute positioning in word)
What version of Crystal Reports Developer are you using, 8, 8.5, 9 or 10? What driver are you using in Crystal Reports, a standard ODBC, or a MySQL specific? Jason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ColdFusion TechNote Notification: ColdFusion MX 6.1 (Windows onl y): Hot fix for Crystal Reports
Check out theupdated TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/crystal_hotfix.htm http://www.macromedia.com/support/coldfusion/ts/documents/crystal_hotfix.ht m The hot fix for Crystal Reports has been updated to include an additional fix for cases where cfreport fails when connecting to a data source that requires a username and password. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Crystal Report Advanced Developer 10
We are standardizing on Crystal Reports at work. Anyone have any experience with the advanced developer version and CFMX? It states on the page description that is has a Java backend. Does mean it will integrate well with CFMX? Thanks, Dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Crystal Report Advanced Developer 10
we are currently using Crystal Enterprise 9not 10, without any problem. TIA, Patrick Whittingham United Space Alliance -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 12:27 PM To: CF-Talk Subject: Crystal Report Advanced Developer 10 We are standardizing on Crystal Reports at work. Anyone have any experience with the advanced developer version and CFMX? It states on the page description that is has a Java backend. Does mean it will integrate well with CFMX? Thanks, Dave _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Crystal 8.5 with CF MX 6.1
We are trying to run a simple Crystal Report (built using version 8.5) using a CFREPORT tag in a Cold Fusion page. My understanding is that this should be relatively routine. The tag reads: CFREPORT report=D:\webroot\Reports\WD.rpt/CFREPORT It is the only significant code in the BODY of the page (to keep the test simple). When we try to run the page, we get the following error: An unexpected error occurred while using the Crystal Engine. Error number 599 ocurred (Cannot open SQL server.). We are running Windows 2000 Server with SP3, IIS, MDAC 2.6 SP 2, Crystal Reports 8.5 (loaded as recommended in cfmx_crystal85.htm on the MacroMedia site...Crystal loaded as Custom, adding Crystal SQL Designer to be loaded, checking that CRPE32.dll is in the system32 directory), and CF MX 6.1. We defined the ODBC connection to our SQL server database and it verified. We ran a simple Cold Fusion test page that accessed that database and it worked. We ran the crystal report in crystal (using that database in the report) and it worked. When we try to run the crystal report from CFREPORT in CF, it fails with the error above. Any suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Crystal 8.5 with CF MX 6.1
Security settings for the account running ColdFusion is able to run the report too - has the right permissions? -Original Message- From: Steven Haas [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 12:31 PM To: CF-Talk Subject: Crystal 8.5 with CF MX 6.1 We are trying to run a simple Crystal Report (built using version 8.5) using a CFREPORT tag in a Cold Fusion page. My understanding is that this should be relatively routine. The tag reads: CFREPORT report=D:\webroot\Reports\WD.rpt/CFREPORT It is the only significant code in the BODY of the page (to keep the test simple). When we try to run the page, we get the following error: An unexpected error occurred while using the Crystal Engine. Error number 599 ocurred (Cannot open SQL server.). We are running Windows 2000 Server with SP3, IIS, MDAC 2.6 SP 2, Crystal Reports 8.5 (loaded as recommended in cfmx_crystal85.htm on the MacroMedia site...Crystal loaded as Custom, adding Crystal SQL Designer to be loaded, checking that CRPE32.dll is in the system32 directory), and CF MX 6.1. We defined the ODBC connection to our SQL server database and it verified. We ran a simple Cold Fusion test page that accessed that database and it worked. We ran the crystal report in crystal (using that database in the report) and it worked. When we try to run the crystal report from CFREPORT in CF, it fails with the error above. Any suggestions? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Crystal Enterprise Report Application Server (RAS) 9.
Anybody out there have any experience with this product? I'm at my wit's end.We have struggled for a week trying to install Crystal Enterprise Report Application Server (RAS) 9 on our new web server.I have searched up and down Business Objects' knowledge base (the new owners of the Crystal Reports product line) and can't make any sense of this.It installed CE RAS 9 on my local development computer without trouble, but once installed on the new web server we can't run any reportsI've found several resources that apparently describe resolutions to our problems, but they ask me to create virtual directories in the website(s) linked to file system directories that don't exist in any of my installations and create application mappings in the website(s) to a wcsinsapi.dll that also does not exist anywhere on the web server, on the installation disk or even my local machine where CE RAS is actually working Any help would be most appreciated. Thank You -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Crystal Reports
Hi all, I was wondering if anyone can explain to me how exactly Crystal Reports work with CF. I have a request from my users to replace their Access based report with web based reports and I think Crystal is the best route - maybe. Does Crystal need to be installed on the CF server? What version of Crystal is needed as I have two different versions of CF running. I on set of servers that is still using CF4.5 - waiting to be upgraded and another set running MX. Is there any other report writers out there that will work with CF? I have been working with iText to make pdf's but I am not sure if this is good for what I want to do. If anyone has any ideas or knows of any other solutions, can you let me know. Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: crystal tech - access databases
Thanks Cameron... I think its probably time to look at SQL server 2000 I've had the developer edition for some time but never took the time to learn it... Is there a good mail list similar to this one for dialoging with SQL Svr 2000 users? Tim -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 7:51 PM To: CF-Talk Subject: RE: crystal tech - access databases The .ldb file problem is an access thing, and the best long term solution *is* to not use a desktop database for a web application.That's not a practically solution for everyone... The ldb file represents a connection to your database from an application (CF in your case).Even if you rid yourself of it using a bogus query or other method, it will return the second your web app gets another hit. If you have any traffic at all on your app, you might consider actually taking the app offline when you are trying to move around the database like this. I've used a short message and a cfabort at the top of the application.cfm file before to accomplish this. Also, remember that CF may cache the connection to your Access DB unless Maintain Connections is unchecked in the CFADMIN for this ODBC connection. You may want to have your ISP double check that setting if you are unsure that it's unchecked. Finally, it can be helpful to make a copy of your DB and download the copy rather than the live DB.Copying the DB is alot quicker than downloading it and the time window you need to leave open for a copy is much more manageable. -Cameron - Cameron Childress Sumo Consulting Inc --- land:858.509.3098 cell:678.637.5072 aim:cameroncf email: [EMAIL PROTECTED] -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:39 PM To: CF-Talk Subject: crystal tech - access databases Hello All... I'm having a real problem with not being able to upload or download access databases with crystal tech hosting... the .ldb file hangs around any prevents the upload or download.I've even tried the bogus query method and that doesn't work. Has anybody experienced this before with Crystal Tech?I use other hosts (es. Media 3)and never have this problem ... Crystal Tech claims its an access thing and to look at SQL server or MySQL... I will be moving some databases to SQL server but not all Any insight would be appreciated Tim Laureska 1st-String Technologies 443-496-1261 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: crystal tech - access databases
Tim, There is a SQL list at houseoffusion.com. I agree with Cameron that MS Access shouldn't be used for web apps, but in some cases it is all you have or your only option.There are a few good tricks for maintenance, use etc if access is what you have to use, but IF you have the option of using a SQL server (MS or MySQL) then I would take a good look at it. it is well worth the migration and really isn't that difficult to do.Some ISP's will give you a hand in the migration as well. Take care, Jason Egan VP Partner/Customer Relations Konnections, Inc. www.CFDynamics.com office801-337-0135 fax801-1394-1254 sales 866-CFDynamics -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Saturday, February 07, 2004 7:17 AM To: CF-Talk Subject: RE: crystal tech - access databases Thanks Cameron... I think its probably time to look at SQL server 2000 I've had the developer edition for some time but never took the time to learn it... Is there a good mail list similar to this one for dialoging with SQL Svr 2000 users? Tim -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 7:51 PM To: CF-Talk Subject: RE: crystal tech - access databases The .ldb file problem is an access thing, and the best long term solution *is* to not use a desktop database for a web application.That's not a practically solution for everyone... The ldb file represents a connection to your database from an application (CF in your case).Even if you rid yourself of it using a bogus query or other method, it will return the second your web app gets another hit. If you have any traffic at all on your app, you might consider actually taking the app offline when you are trying to move around the database like this. I've used a short message and a cfabort at the top of the application.cfm file before to accomplish this. Also, remember that CF may cache the connection to your Access DB unless Maintain Connections is unchecked in the CFADMIN for this ODBC connection. You may want to have your ISP double check that setting if you are unsure that it's unchecked. Finally, it can be helpful to make a copy of your DB and download the copy rather than the live DB.Copying the DB is alot quicker than downloading it and the time window you need to leave open for a copy is much more manageable. -Cameron - Cameron Childress Sumo Consulting Inc --- land:858.509.3098 cell:678.637.5072 aim:cameroncf email: [EMAIL PROTECTED] -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:39 PM To: CF-Talk Subject: crystal tech - access databases Hello All... I'm having a real problem with not being able to upload or download access databases with crystal tech hosting... the .ldb file hangs around any prevents the upload or download.I've even tried the bogus query method and that doesn't work. Has anybody experienced this before with Crystal Tech?I use other hosts (es. Media 3)and never have this problem ... Crystal Tech claims its an access thing and to look at SQL server or MySQL... I will be moving some databases to SQL server but not all Any insight would be appreciated Tim Laureska 1st-String Technologies 443-496-1261 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
crystal tech - access databases
Hello All... I'm having a real problem with not being able to upload or download access databases with crystal tech hosting... the .ldb file hangs around any prevents the upload or download.I've even tried the bogus query method and that doesn't work. Has anybody experienced this before with Crystal Tech?I use other hosts (es. Media 3)and never have this problem ... Crystal Tech claims its an access thing and to look at SQL server or MySQL... I will be moving some databases to SQL server but not all Any insight would be appreciated Tim Laureska 1st-String Technologies 443-496-1261 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: crystal tech - access databases
The .ldb file problem is an access thing, and the best long term solution *is* to not use a desktop database for a web application.That's not a practically solution for everyone... The ldb file represents a connection to your database from an application (CF in your case).Even if you rid yourself of it using a bogus query or other method, it will return the second your web app gets another hit.If you have any traffic at all on your app, you might consider actually taking the app offline when you are trying to move around the database like this. I've used a short message and a cfabort at the top of the application.cfm file before to accomplish this. Also, remember that CF may cache the connection to your Access DB unless Maintain Connections is unchecked in the CFADMIN for this ODBC connection. You may want to have your ISP double check that setting if you are unsure that it's unchecked. Finally, it can be helpful to make a copy of your DB and download the copy rather than the live DB.Copying the DB is alot quicker than downloading it and the time window you need to leave open for a copy is much more manageable. -Cameron - Cameron Childress Sumo Consulting Inc --- land:858.509.3098 cell:678.637.5072 aim:cameroncf email: [EMAIL PROTECTED] -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:39 PM To: CF-Talk Subject: crystal tech - access databases Hello All... I'm having a real problem with not being able to upload or download access databases with crystal tech hosting... the .ldb file hangs around any prevents the upload or download.I've even tried the bogus query method and that doesn't work. Has anybody experienced this before with Crystal Tech?I use other hosts (es. Media 3)and never have this problem ... Crystal Tech claims its an access thing and to look at SQL server or MySQL... I will be moving some databases to SQL server but not all Any insight would be appreciated Tim Laureska 1st-String Technologies 443-496-1261 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Crystal Reports
I have asp code that used sessions, but modified this to not use sessions and the asp code worked, I am stuck here when trying to save the result:-) The code below will not work and fails on the Open(), and have no idea why:-) var iFormat = arguments.fileFormat; var strFileName = arguments.fileName; var BinaryStream = CreateObject(com,ADODB.Stream); // The Export method of PrintOutputController takes an enumerated // value for the format and returns a ByteArray object var o_ByteArray = arguments.o_PrintOutputController.Export(iFormat); // WriteOutput(ToString(o_ByteArray) 'br'); // BinaryWrite the ByteArray property of the ByteArray object // Create Stream object // Specify stream type - we want To save binary data. BinaryStream.Type = 1; // Open the stream And write binary data To the object BinaryStream.Open(); BinaryStream.Write(o_ByteArray.ByteArray); // Save binary data To disk BinaryStream.SaveToFile(strFileName, 2); BinaryStream.Close(); Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 November 2003 6:00 PM To: CF-Talk Subject: Re: Crystal Reports I am looking at connecting to crystal reports 9.0 with Coldfusion MX 6.1, I am having trouble converting some ASP code across to coldfusion and would like some examples or resource info on the component use in CF MX 6.1. well i'm actually researching this now (using RAS 9.2). i've not been able to get cf to work properly with the activeX clientside, i _think_ the component is pulling stuff from asp sessions so never the twain shall meet. i haven't tried porting the asp stuff to cf yet. i have had better much luck using the java connector, rendering the reports only took a handful of lines i could control a whole big chunk of the process. can also easily move this to a CFC. the only fly in the ointment being the loss of export/print functionality in the veiwer (even though the java viewer reports these as both being on). still working thru this (fallback would be seperate export to pdf CFC)--with mx i think the java connector might be a better choice than the COM one. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Crystal Reports
Hi I am hoping someone has done this or knows where I can get good resource information. I am looking at connecting to crystal reports 9.0 with Coldfusion MX 6.1, I am having trouble converting some ASP code across to coldfusion and would like some examples or resource info on the component use in CF MX 6.1. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Crystal Reports
I am looking at connecting to crystal reports 9.0 with Coldfusion MX 6.1, I am having trouble converting some ASP code across to coldfusion and would like some examples or resource info on the component use in CF MX 6.1. well i'm actually researching this now (using RAS 9.2). i've not been able to get cf to work properly with the activeX clientside, i _think_ the component is pulling stuff from asp sessions so never the twain shall meet. i haven't tried porting the asp stuff to cf yet. i have had better much luck using the java connector, rendering the reports only took a handful of lines i could control a whole big chunk of the process. can also easily move this to a CFC. the only fly in the ointment being the loss of export/print functionality in the veiwer (even though the java viewer reports these as both being on). still working thru this (fallback would be seperate export to pdf CFC)--with mx i think the java connector might be a better choice than the COM one. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
crystal report to pdf
I need to generate crystal report on pdf files saved automatically in a server is there a solution usinf cf? thanks salva [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: crystal report to pdf
Short answer: no. Long answer: Install the ASP.net framework on the server.Call the report from a simple aspx template.The asp templates that come with Crystal are very explanatory.The one advatage to asp.net is that you have a lot better error handling, which you'll need with all the problems Crystal can have :).Call the aspx from cf using cfhttp. Marlon Salva magaz wrote: I need to generate crystal report on pdf files saved automatically in a server is there a solution usinf cf? thanks salva [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: crystal report to pdf
Oh shoot, before I get flamed.When I said asp.net has better error handling, I meant that in comparison to asp.Uh All hail CF. ...Boy, that was close Marlon Moyer wrote: Short answer: no. Long answer: Install the ASP.net framework on the server.Call the report from a simple aspx template.The asp templates that come with Crystal are very explanatory.The one advatage to asp.net is that you have a lot better error handling, which you'll need with all the problems Crystal can have :).Call the aspx from cf using cfhttp. Marlon Salva magaz wrote: I need to generate crystal report on pdf files saved automatically in a server is there a solution usinf cf? thanks salva [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re[2]: crystal report to pdf
Thanks Marlon, but I have no idea where to find this ASP.net frameworks and never used aspx :( can you tell me more about that Salva Short answer: no. Long answer: Install the ASP.net framework on the server. Call the report from a simple aspx template. The asp templates that come with Crystal are very explanatory. The one advatage to asp.net is that you have a lot better error handling, which you'll need with all the problems Crystal can have :). Call the aspx from cf using cfhttp. Marlon Salva magaz wrote: I need to generate crystal report on pdf files saved automatically in a server is there a solution usinf cf? thanks salva [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
