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
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
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
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 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 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]
OT: Crystal Reports
I'm making my first attempt at building a crystal report for contract printing from our internal web site. I'm having a little difficulty with a couple of things, so I was wondering: A. Are there any good web/mailing list resources for crystal reports? B. Are there any good web/mailing list resources for using CFReport crystal reports? I'd appreciate any suggestions. Thanks! --- Josh Remus Network Manager ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion and Crystal Reports
I've never used Crystal from CF, so I'm forwarding the following question from a colleague: I want to use cold fusion to call a Crystal Reports template with a WHERE clause and display the report in PDF. If 500 users are requesting, who handles the requests? ColdFusion or do I need to purchase a Crystal Server? Thanks Basically, he wants to know how licensing is handled when calling Crystal from CF. Will Crystal refuse requests when the license is exceeded? If so, does it throw an error that must be trapped in the CF code? Thanks, Chris ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Crystal Reports - use CFHTTP/CFLOCATION now for CFREPORT ? How?
Can you please explain how to use CFHTTP (and I guess it's with CFLOCATION?) to actually replace the CFREPORT tag that no longer works with newer versions of Crystal Reports? Any examples would be greatly appreciated... Thanks In Advance, Ed Gordon CF'er ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Crystal Reports
Hi, Does anyone know how to call up or incorporate Crystal Reports in Cold Fusion MX and what version of Crystal Reports will work in MX? Thanks Best Regards, Amalan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Crystal Reports
This came up in the past couple weeks. As I remember the summary: The COM component (.ocx) that ships with Crystal 8.x and 9 may or may not work under CFMX. The Java-COM bridge can be problematic. But there is a Java wrapper (which I can verify that ships with CR 8.5 at least) that will let you manipulate Crystal reports as you would the COM object. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Amalan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 13, 2003 6:50 AM Subject: Crystal Reports Hi, Does anyone know how to call up or incorporate Crystal Reports in Cold Fusion MX and what version of Crystal Reports will work in MX? Thanks Best Regards, Amalan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Crystal Reports 9 / Reporting Options for CF5/MX?
I have never user Crystal, but I can tell you that Actuate Reports work well with Cold Fusion and SQL, I speak from personal experience. Here is a link to their product :http://www.actuate.com/products/designers/erdpro/overview.asp -Original Message- From: Ben Koshy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 5:52 PM To: CF-Talk Subject: Crystal Reports 9 / Reporting Options for CF5/MX? Does anyone know if CR9 is compatible with CF5 or CFMX? I'm new to Crystal Reports...basically we are looking for a good reporting solution for Cold Fusion/SQL 2000 and naturally went after the big name. I'd like to keep the budget under $500 USD unless there some must-have feature/product out there... :) Need to do the following typical reporting: Strong Graphing Capabilities and mainly used for generating Sale Advertising tracking reports. If any one has suggestions? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Crystal Reports 9 / Reporting Options for CF5/MX?
Does anyone know if CR9 is compatible with CF5 or CFMX? I'm new to Crystal Reports...basically we are looking for a good reporting solution for Cold Fusion/SQL 2000 and naturally went after the big name. I'd like to keep the budget under $500 USD unless there some must-have feature/product out there... :) Need to do the following typical reporting: Strong Graphing Capabilities and mainly used for generating Sale Advertising tracking reports. If any one has suggestions? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Crystal Reports 9 / Reporting Options for CF5/MX?
I've used the 8.0 and 8.5 COM objects under CF 5. The couple of experiments I did with CFMX didn't leave me feeling confident -- no luck at all. There are some good Java-based charting APIs -- commercial ones, that may be an option under CFMX. One option you *could* consider is to use CF to get the data from Crystal's ASP pages it comes packaged with -- using CFHTTP. Not a solution I really like. You could also just use the Crystal ASP miniapp that comes with the product as a part of your application --- no reason you can't put the appropriate links (or generate them on the fly, depending on your needs) in the CF and link back to the CF from your ASP-based Crystal pages. I'd be really interested to hear other's experience with alternative reporting tools -- Jasper reports anyone? DataVision? etc. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Ben Koshy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 5:51 PM Subject: Crystal Reports 9 / Reporting Options for CF5/MX? Does anyone know if CR9 is compatible with CF5 or CFMX? I'm new to Crystal Reports...basically we are looking for a good reporting solution for Cold Fusion/SQL 2000 and naturally went after the big name. I'd like to keep the budget under $500 USD unless there some must-have feature/product out there... :) Need to do the following typical reporting: Strong Graphing Capabilities and mainly used for generating Sale Advertising tracking reports. If any one has suggestions? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Crystal Reports Enterprise 8.5 ohhhh the pain
No I am not passing the login and pass in the url. If you leave the params blank it uses the nt auth. Heres how I ended up getting it to work. http://mybox.box.com/crystal/enterprise/viewer/viewrpt.cwr?apsauthtype=secWi ndowsNTid=204 If you have any other techniques for this please let me know. Thanks for your reply Sean -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 9:03 AM To: CF-Talk Subject: Re: Crystal Reports Enterprise 8.5 o the pain Do you really want to pass the username and password in the URL? I'm not sure how you are trying to implement your reports, but if you give some details I may be able to help as we use reporting with CF/Crystal extensively. -Frank - Original Message - From: Sean McCarthy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 11:12 PM Subject: OT: Crystal Reports Enterprise 8.5 o the pain Hi, We are attempting to use Crystal Enterprise with windows auth. Everything is configured according to the docs they have provided but unfortunately the windows auth through iis works but the user is still prompted with the login box for crystal enterprise. I can select 'nt auth' from the crystal drop down enter no credentials and hit submit and it knows who i am. I believe everything is working properly but crystal needs to create some sort of cookie?through the submit from the crystal auth screen. How can I avoid this screen and just get directly to the report with my auth information? I guess how can I create the cookie on the fly when accessing the url for the report? Can I pass generic vars on the url to get it to pass and create the cookie? This is the only link I have successfully gotten to work: http://servername/crystal/enterprise/admin/en/admin.cwr?action=logonaps=aps nameauth=secWindowsNTusr=pwd If I could do this when I call my report url that would be great. Thanks for any input you might have Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Crystal Reports Enterprise 8.5 ohhhh the pain
CR does set a cookie for each parameter, and i believe the max is 20. Passing it via url does cause cookie problems. What I do is use NT authentication for the login, Just make sure the crystal server is logged in as a user that the db has an account for. A problem that I ran across was subreports, when you use cross db joins, it will get confused with all the usernames and passwords, so I just used the same usernames and passwords. FYI, create a list and pass it in as one parameter and strip it apart in CR that way you won't run into the cookie problem. -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 9:10 AM To: CF-Talk Subject: RE: Crystal Reports Enterprise 8.5 o the pain No I am not passing the login and pass in the url. If you leave the params blank it uses the nt auth. Heres how I ended up getting it to work. http://mybox.box.com/crystal/enterprise/viewer/viewrpt.cwr?apsauthtype=secWi ndowsNTid=204 If you have any other techniques for this please let me know. Thanks for your reply Sean -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 9:03 AM To: CF-Talk Subject: Re: Crystal Reports Enterprise 8.5 o the pain Do you really want to pass the username and password in the URL? I'm not sure how you are trying to implement your reports, but if you give some details I may be able to help as we use reporting with CF/Crystal extensively. -Frank - Original Message - From: Sean McCarthy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 11:12 PM Subject: OT: Crystal Reports Enterprise 8.5 o the pain Hi, We are attempting to use Crystal Enterprise with windows auth. Everything is configured according to the docs they have provided but unfortunately the windows auth through iis works but the user is still prompted with the login box for crystal enterprise. I can select 'nt auth' from the crystal drop down enter no credentials and hit submit and it knows who i am. I believe everything is working properly but crystal needs to create some sort of cookie?through the submit from the crystal auth screen. How can I avoid this screen and just get directly to the report with my auth information? I guess how can I create the cookie on the fly when accessing the url for the report? Can I pass generic vars on the url to get it to pass and create the cookie? This is the only link I have successfully gotten to work: http://servername/crystal/enterprise/admin/en/admin.cwr?action=logonaps=aps nameauth=secWindowsNTusr=pwd If I could do this when I call my report url that would be great. Thanks for any input you might have Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Crystal Reports Enterprise 8.5 ohhhh the pain
Do you really want to pass the username and password in the URL? I'm not sure how you are trying to implement your reports, but if you give some details I may be able to help as we use reporting with CF/Crystal extensively. -Frank - Original Message - From: Sean McCarthy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 11:12 PM Subject: OT: Crystal Reports Enterprise 8.5 o the pain Hi, We are attempting to use Crystal Enterprise with windows auth. Everything is configured according to the docs they have provided but unfortunately the windows auth through iis works but the user is still prompted with the login box for crystal enterprise. I can select 'nt auth' from the crystal drop down enter no credentials and hit submit and it knows who i am. I believe everything is working properly but crystal needs to create some sort of cookie?through the submit from the crystal auth screen. How can I avoid this screen and just get directly to the report with my auth information? I guess how can I create the cookie on the fly when accessing the url for the report? Can I pass generic vars on the url to get it to pass and create the cookie? This is the only link I have successfully gotten to work: http://servername/crystal/enterprise/admin/en/admin.cwr?action=logonaps=aps nameauth=secWindowsNTusr=pwd If I could do this when I call my report url that would be great. Thanks for any input you might have Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
OT: Crystal Reports Enterprise 8.5 ohhhh the pain
Hi, We are attempting to use Crystal Enterprise with windows auth. Everything is configured according to the docs they have provided but unfortunately the windows auth through iis works but the user is still prompted with the login box for crystal enterprise. I can select 'nt auth' from the crystal drop down enter no credentials and hit submit and it knows who i am. I believe everything is working properly but crystal needs to create some sort of cookie?through the submit from the crystal auth screen. How can I avoid this screen and just get directly to the report with my auth information? I guess how can I create the cookie on the fly when accessing the url for the report? Can I pass generic vars on the url to get it to pass and create the cookie? This is the only link I have successfully gotten to work: http://servername/crystal/enterprise/admin/en/admin.cwr?action=logonaps=aps nameauth=secWindowsNTusr=pwd If I could do this when I call my report url that would be great. Thanks for any input you might have Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Crystal Reports Enterprise 8.5 victory!!!!!
ok anyone that has to do this can give this a whirl http://mybox.box.com/crystal/enterprise/viewer/viewrpt.cwr?apsauthtype=secWi ndowsNTid=204 and it will pass the nt auth information with no popup. sean -Original Message- From: Sean McCarthy Sent: Tuesday, December 17, 2002 11:13 PM To: CF-Talk Subject: OT: Crystal Reports Enterprise 8.5 o the pain Hi, We are attempting to use Crystal Enterprise with windows auth. Everything is configured according to the docs they have provided but unfortunately the windows auth through iis works but the user is still prompted with the login box for crystal enterprise. I can select 'nt auth' from the crystal drop down enter no credentials and hit submit and it knows who i am. I believe everything is working properly but crystal needs to create some sort of cookie?through the submit from the crystal auth screen. How can I avoid this screen and just get directly to the report with my auth information? I guess how can I create the cookie on the fly when accessing the url for the report? Can I pass generic vars on the url to get it to pass and create the cookie? This is the only link I have successfully gotten to work: http://servername/crystal/enterprise/admin/en/admin.cwr?action=logonaps=aps nameauth=secWindowsNTusr=pwd If I could do this when I call my report url that would be great. Thanks for any input you might have Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT: Crystal Reports (subreports)
Has anyone found a workaround for having a subreport within a subreport? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Package of Crystal Reports Required for CF?
This is interesting. My input forms are totally dynamic as well. I'll check it out. Thanks. - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 6:41 PM Subject: Re: Package of Crystal Reports Required for CF? We combine CF and ASP for processing and use Recrystallize as a productivity tool. It generates the web pages. We only use the asp processing pages. The input forms which need, in our case, to be very dynamic and based on other systems with varying security are done with CF. Note that we have alot of reports and is cost effective for us. http://www.recrystallize.com - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 8:39 PM Subject: RE: Package of Crystal Reports Required for CF? Hi, i meant the actual tag cfreport.. not crystal report itself.. i found it a bit hard to get it working.. and once i did.. i found it abit lacking in functionality you can write a module or component yourself that works alot better... just take the ASP examples that come with the software and covert it to CF... or interface CF form with an ASP page that calls the crystal report (*.RPT) file.. search the MM CF forums.. for issues ppl have come across... hth joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 10:15 To: CF-Talk Subject: Re: Package of Crystal Reports Required for CF? Really, why? I've done a lot of hand-grown reports, but for a demo for a client, I want to use the widgets that come with crystal. Thanks. - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:18 PM Subject: RE: Package of Crystal Reports Required for CF? I have used Developer version... not sure about the standard version... plus i would stay away from cfreport... IMO..:) cheers Joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 2:41 To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Package of Crystal Reports Required for CF?
We combine CF and ASP for processing and use Recrystallize as a productivity tool. It generates the web pages. We only use the asp processing pages. The input forms which need, in our case, to be very dynamic and based on other systems with varying security are done with CF. Note that we have alot of reports and is cost effective for us. http://www.recrystallize.com - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 8:39 PM Subject: RE: Package of Crystal Reports Required for CF? Hi, i meant the actual tag cfreport.. not crystal report itself.. i found it a bit hard to get it working.. and once i did.. i found it abit lacking in functionality you can write a module or component yourself that works alot better... just take the ASP examples that come with the software and covert it to CF... or interface CF form with an ASP page that calls the crystal report (*.RPT) file.. search the MM CF forums.. for issues ppl have come across... hth joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 10:15 To: CF-Talk Subject: Re: Package of Crystal Reports Required for CF? Really, why? I've done a lot of hand-grown reports, but for a demo for a client, I want to use the widgets that come with crystal. Thanks. - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:18 PM Subject: RE: Package of Crystal Reports Required for CF? I have used Developer version... not sure about the standard version... plus i would stay away from cfreport... IMO..:) cheers Joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 2:41 To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Package of Crystal Reports Required for CF?
Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Package of Crystal Reports Required for CF?
Yes. You only need to be careful on version. CF 5 - CR 8; CF 4.5 - CR 7; CFMX - CR ? There is some experimental support for CF4.5 and CR 8. There is a hidden attribute on the cfreport tag. Should be in the knowledge base still. -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:41 AM To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Package of Crystal Reports Required for CF?
Thanks, I just bought a copy of Crystal Standard 9.0. I wanted to make sure I hadn't wasted my money. I couldn't find anything specifically on the package requirements on Macromedia's site. I appreciate your help. - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 2:37 PM Subject: RE: Package of Crystal Reports Required for CF? Yes. You only need to be careful on version. CF 5 - CR 8; CF 4.5 - CR 7; CFMX - CR ? There is some experimental support for CF4.5 and CR 8. There is a hidden attribute on the cfreport tag. Should be in the knowledge base still. -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:41 AM To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Package of Crystal Reports Required for CF?
I have used Developer version... not sure about the standard version... plus i would stay away from cfreport... IMO..:) cheers Joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 2:41 To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Package of Crystal Reports Required for CF?
Really, why? I've done a lot of hand-grown reports, but for a demo for a client, I want to use the widgets that come with crystal. Thanks. - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:18 PM Subject: RE: Package of Crystal Reports Required for CF? I have used Developer version... not sure about the standard version... plus i would stay away from cfreport... IMO..:) cheers Joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 2:41 To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Package of Crystal Reports Required for CF?
Hi, i meant the actual tag cfreport.. not crystal report itself.. i found it a bit hard to get it working.. and once i did.. i found it abit lacking in functionality you can write a module or component yourself that works alot better... just take the ASP examples that come with the software and covert it to CF... or interface CF form with an ASP page that calls the crystal report (*.RPT) file.. search the MM CF forums.. for issues ppl have come across... hth joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 10:15 To: CF-Talk Subject: Re: Package of Crystal Reports Required for CF? Really, why? I've done a lot of hand-grown reports, but for a demo for a client, I want to use the widgets that come with crystal. Thanks. - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 5:18 PM Subject: RE: Package of Crystal Reports Required for CF? I have used Developer version... not sure about the standard version... plus i would stay away from cfreport... IMO..:) cheers Joel -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 September 2002 2:41 To: CF-Talk Subject: Package of Crystal Reports Required for CF? Does anyone know if Crystal Reports Standard can be used to develop a Crystal Report that can be invoked by Cold Fusion's CFReport tag, or do I need to get the Crystal Report Developer or Professional version? Thanks. JMI Associates P.O. Box 162327 Sacramento, CA 95816 916-457-3465 www.reportpros.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Active PDF and Crystal Reports
Anyone out there using the com object written by ActivePDF to create PDF's using ActivePDF and Crystal Reports rpt files? I have been using it to create files successfully from static RPT files, but want to know if there is anyway to pass a parameter or formula through the com object? Or, has anyone found an easy way to output pdf's instead of regular html using CFREPORT with RPT files? Rich Tretola Internet Applications Developer Herff Jones, Inc. http://www.herff-jones.com [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Active PDF and Crystal Reports
Don't know anything about Crystal reports. We use ActivePDF toolkit to set up fields/set doing the parameters. Don't like their documentation but the product is good and they are quick to respond to email. They also have an example CF zip file on their website. anyhow to set up the basic code: !---Set up toolkit--- CFOBJECT ACTION=Create TYPE=COM CLASS=APToolkit.Object NAME=Tkt !---Set up the name of the finished pdf--- CFOUTPUT CFSET R = Tlkt.OpenOutputFile(ExpandPath(../TempOut/Grade4#Numb2#.PDF)) /CFOUTPUT !---Set the name of the input pdf- the template that will be filled in--- CFSET R=Tlkt.OpenInputFile(ExpandPath(../PDFs/Grade4_5.PDF)) !---Then you can use a query to pull up what you want to use by cfsets--- CFSET PRINCIPAL=Tkt.SetFormFieldData(PRINCIPAL, #Query.PRINCIPAL#, 0) !---Clear out and close--- CFSET R=Tkt.CopyForm(0,0) CFSET R=Tkt.ResetFormFields() CFSET R=Tkt.CloseOutputFile() CFSET Tkt= !---Send user to finished pdf--- CFOUTPUT META HTTP-EQUIV=Refresh CONTENT=0; URL=#Request.PDFroot#TempPDFOutput/Grade4#Numb2#.PDF /CFOUTPUT Then using pdf writer you make the text boxes on the pdf and name them according to the CFSETS. ie: Text Name: PRINCIPAL Default Value: #Query.PRINCIPAL# That's it. -Original Message- From: Tretola, Rich A [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 1:43 PM To: CF-Talk Subject: Active PDF and Crystal Reports Anyone out there using the com object written by ActivePDF to create PDF's using ActivePDF and Crystal Reports rpt files? I have been using it to create files successfully from static RPT files, but want to know if there is anyway to pass a parameter or formula through the com object? Or, has anyone found an easy way to output pdf's instead of regular html using CFREPORT with RPT files? Rich Tretola Internet Applications Developer Herff Jones, Inc. http://www.herff-jones.com [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
passing date values thru URL to crystal reports
Hello all, Does anybody know how I would pass date value thru url parameters to a crystal report? This what I'm trying to do: CFSET URL=RentAdjustmentReport.rpt?sf=prompt0=1prompt1=date{01,01,2002} this is what my formula in crystal reports looks like: {Cases.CaseStatus} = {?caseStatus} and {Cases.ReceivedDate} = {?receiveddate} I'm getting prompted to enter in a date.. but then it says error in formula. Please help Thanks __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
crystal reports
I'm running cf 5.0, crystal report 8.5, on win2k I tried calling the report with cfreport tag but am getting timeout errors, I also noticed other developers having the same problem on the messsage boards. So what I'm doing is calling the report via URL. This is the url that I'm using: RentAdjustmentReporttest.rpt?sf={cases.caseStatus}+%3d+1{cases.receivedDate }+%3d+06/01/2002promptonrefresh=1 The report name is RentAdjustmentReporttest.rpt and two parameters that I want to pass thru is cases.caseStatus and cases.receivedDate. These are the formulas: {Cases.ReceivedDate} = {?receivedDate} and {Cases.CaseStatus} = {?caseStatus} Whats happening is that the first parameter caseStatus is working but the receivedDate doesn't seem to go thru. When I view the source this is what I see: Dim webSource0 Set webSource0 = CreateObject(WebReportSource.WebReportSource) webSource0.ReportSource = webBroker webSource0.URL = /RentAdjustmentReport.rpt webSource0.PromptOnRefresh = True webSource0.AddParameter sf, {cases.casestatus} = 1 am I passing the parameters in correctly? or is there another way of doing this? Please advise, Thanks __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Crystal Reports ActiveX
heres a bit of sample code that will opens the viewer: snip cfset session.cry_width=100% cfset session.cry_height=100% cfset session.cry_tree=False cfset Report_Location=http://gbvwfsmks00050/extranet/commonApps/DataCapture/Cryst alTest/isp_month_detail.rpt cfset param1=date(2002,1,1) cfset param2=73116 OBJECT ID=CRViewer CLASSID = CLSID:C4847596-972C-11D0-9567-00A0C9273C2A WIDTH=cfoutput#session.cry_width#/cfoutput HEIGHT=cfoutput#session.cry_height#/cfoutput CODEBASE=/viewer/activeXViewer/activexviewer.cab#Version=8,0,100,52 PARAM NAME='EnableDrillDown' VALUE=1 PARAM NAME='EnableAnimationControl' VALUE=1 PARAM NAME='EnableCloseButton' VALUE=1 PARAM NAME='EnableGroupTree' VALUE=cfoutput#iif(session.cry_tree is True,1,0)#/cfoutput PARAM NAME='EnableNavigationControls' VALUE=1 PARAM NAME='EnablePrintButton' VALUE=1 PARAM NAME='EnableProgressControl' VALUE=1 PARAM NAME='EnableRefreshButton' VALUE=1 PARAM NAME='EnableSearchControl' VALUE=1 PARAM NAME='EnableStopButton' VALUE=1 PARAM NAME='EnableZoomControl' VALUE=1 PARAM NAME='DisplayGroupTree' VALUE=1 PARAM NAME='DisplayToolbar' VALUE=1 PARAM NAME='EnableToolbar' VALUE=1 PARAM NAME='DisplayBorder' VALUE=1 PARAM NAME='DisplayTabs' VALUE=1 PARAM NAME='DisplayBackgroundEdge' VALUE=1 PARAM NAME='EnablePopupMenu' VALUE=1 PARAM NAME='EnableExportButton' VALUE=1 /OBJECT SCRIPT LANGUAGE=VBScript Sub window_onLoad() Page_Initialize() End Sub Sub Page_Initialize On Error Resume Next Dim webBroker Set webBroker = CreateObject(WebReportBroker.WebReportBroker) if ScriptEngineMajorVersion 2 then window.alert IE 3.02 users on NT4 need to get the latest version of VBScript or install IE 4.01 SP1. IE 3.02 users on Win95 need DCOM95 and latest version of VBScript, or install IE 4.01 SP1. These files are available at Microsofts web site. !---CRViewer.ReportName = http://999.999.999.999\cfoutput#session.cry_rpt#/cfoutput --- CRViewer.ReportName = cfoutput#Report_Location#/cfoutput else Dim webSource Set webSource = CreateObject(WebReportSource.WebReportSource) webSource.ReportSource = webBroker !--- webSource.URL = http://208.252.193.180\cfoutput#session.cry_rpt#/cfoutput --- webSource.URL = cfoutput#report_location#/cfoutput webSource.AddParameter user0, REPORTER webSource.AddParameter password0, reporter webSource.AddParameter prompt0,cfoutput#param1#/cfoutput webSource.AddParameter prompt1,cfoutput#param2#/cfoutput !--- webSource.AddParameter sf,cfoutput#replace(session.cry_query,'',',ALL)#/cfoutput --- webSource.PromptOnRefresh = false CRViewer.ReportSource = webSource end if CRViewer.ViewReport End Sub /SCRIPT end snip -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: 02 June 2002 22:00 To: CF-Talk Subject: Crystal Reports ActiveX Does anyone know how to access the Crystal Reports ActiveX Viewer with CF? If so how do I pass variables, formulas to it? I am using IIS and when i use a page with an href to a filename.rpt it activates the named report, but I sure would like to be able to massage the output like we used to be able to in CF 3 with the cfreport tag. The activeX viewer is alot more mature, but so far all I can see in their docs is references to ASP. Any and all help would be appreciated. Terry __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports ActiveX
Does anyone know how to access the Crystal Reports ActiveX Viewer with CF? If so how do I pass variables, formulas to it? I am using IIS and when i use a page with an href to a filename.rpt it activates the named report, but I sure would like to be able to massage the output like we used to be able to in CF 3 with the cfreport tag. The activeX viewer is alot more mature, but so far all I can see in their docs is references to ASP. Any and all help would be appreciated. Terry __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports?
I need to get a copy of Crystal Reports and I was wondering if the $$ difference between developer edition and professional is worth it. Is there anything I cannot do with professional in coldfusion that I can do with the developer edition? Douglas Brown Email: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
crystal reports vs... ?
Hi Listers, I'm peering into my crystal snowball and I see dozens of complex reports in my near future. These reports need to be generated from dynamic (server-side) databases whipped up to the user in an editable format (rtf/doc). I have used an open-source Perl script (now an open source kit available at http://search.cpan.org/search?dist=RTF-Writer). I need to forego the Perl solution because 1) My Perl skills (not there) more important, 2) I hope to train someone to build reports in a Win environment w/familiar interface widgets, etc. What I'm looking for is anyone with some experiences generating reports on-the-fly ... which toolkits, how much$, pitfalls, etc. The target platform is a win2k-server-based intranet with a variety of possible datasources (access 2k, sql server 7, oracle, etc.) Finally, I need to make a decision, say, today or tomorrow, buy the software and produce, say, yesterday ;) Thanks! Mike __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: crystal reports vs... ?
Good luck... I've built a report generator for us, and it's been a work in progress for the last year :) As far as I know, crystal 8.5 has its own scripting language now that *gasp* looks just like ASP. Working with 8 however, I've come up with a way of using stored procedures for my dynamic parameters. However dynamic reporting itself would require some pretty hefty programming. If dynamic reporting is necessary, I'd investigate some OLAP reporting solutions; Oracle, Cognos are the first that come to mind. It's a neat way to look at reporting. What we do here for all of the bizarre report requests is have a scheduled task in sql server that dumps a tonne of data to excel for a pivot table. It's a three dimensional way to report on data that can be quite effective if the users are trained on how to use it. However, given my experience with end users, they aren't all smart enough to think in terms of pivot tables. Given that your needs include an editable format, have you considered using MS Word and COM to report? It's not pretty, but it can be done. Either way, in a nutshell, what you want can't be answered in a day or so. I wish you the best of luck on your quest. :) -Original Message- From: Michael Vinson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 6:18 AM To: CF-Talk Subject: crystal reports vs... ? Hi Listers, I'm peering into my crystal snowball and I see dozens of complex reports in my near future. These reports need to be generated from dynamic (server-side) databases whipped up to the user in an editable format (rtf/doc). I have used an open-source Perl script (now an open source kit available at http://search.cpan.org/search?dist=RTF-Writer). I need to forego the Perl solution because 1) My Perl skills (not there) more important, 2) I hope to train someone to build reports in a Win environment w/familiar interface widgets, etc. What I'm looking for is anyone with some experiences generating reports on-the-fly ... which toolkits, how much$, pitfalls, etc. The target platform is a win2k-server-based intranet with a variety of possible datasources (access 2k, sql server 7, oracle, etc.) Finally, I need to make a decision, say, today or tomorrow, buy the software and produce, say, yesterday ;) Thanks! Mike __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports help
Hi guys and gals, Is there anyone out there who is fairly good in Crystal Reports? I am crashing ehre trying to hurry down what should be a simple report. I have three tables..tblMainEntry, tblEquipEntry and Equipment_tbl. I just add all three tables and I get the error that there are multiple starting points. I try to edit the SQL directly using Show SQL and it does not keep my SQL statement. It ignores what I put in the Select line of the SQL Statement. Namely Equipment_Tbl.Equipment_Desc. Now this is a field on the report hat I stuck in there, and of course since it is not in the select statement I keep getting errors saying field not in Select clause. I am at my wits end! Can anyone help? I'd be willing to call or perhaps even pay for some quick support somehow :) Really! -Angel Stewart __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Crystal Reports help
I haven't practiced much with Crystal but... I would start fresh using the Crystal wizard. Select all 3 tables you need and make sure you relate them. I've never seen a multiple starting points message but that sounds like you have unrelated tables. Make sure you make all tables and columns available to the report using the wizard. Also, I don't think I've ever successfully edited the SQL. If you need serious phone help you might try calling Crystal Decisions. If you have enough time you might try to pick up a manual or Crystal for dummies book. It should have examples in it. Good luck. Duncan Hays -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 2:17 PM To: CF-Talk Subject: Crystal Reports help Hi guys and gals, Is there anyone out there who is fairly good in Crystal Reports? I am crashing ehre trying to hurry down what should be a simple report. I have three tables..tblMainEntry, tblEquipEntry and Equipment_tbl. I just add all three tables and I get the error that there are multiple starting points. I try to edit the SQL directly using Show SQL and it does not keep my SQL statement. It ignores what I put in the Select line of the SQL Statement. Namely Equipment_Tbl.Equipment_Desc. Now this is a field on the report hat I stuck in there, and of course since it is not in the select statement I keep getting errors saying field not in Select clause. I am at my wits end! Can anyone help? I'd be willing to call or perhaps even pay for some quick support somehow :) Really! -Angel Stewart __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ColdFusion Crystal Reports References
Hey there, right now I'm trying to learn Crystal Reports design with ColdFusion, and I wanted to see if there was a place that had any good tutorials, samples, etc. Any ideas? Thanks! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ColdFusion/Crystal Reports question
Perhaps someone can help me with a more direct question, how do I pass a parameter variable from CFREPORT into Crystal Reports 8.5. Specifically in Crystal Reports I have parameter variables StartDate and EndDate and I'd like to pass them from CFREPORT in looking something like this StartDate = 1/20/2001 EndDate = 1/20/2002 Or something like that. Any ideas and thanks! Gregory Harris __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF/Crystal Reports Prob
Perhaps someone can help me with a more direct question, how do I pass a parameter variable from CFREPORT into Crystal Reports 8.5. Specifically in Crystal Reports I have parameter variables StartDate and EndDate and I'd like to pass them from CFREPORT in looking something like this StartDate = 1/20/2001 EndDate = 1/20/2002 Or something like that. Any ideas and thanks! Gregory Harris [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Crystal Reports Integration
That error seems typical of some sort of SQL error on the report itself. This could be due to 1) Problem with the DSN on the report 2) Security rights for the report DSN 3) Invalid parameters passed to the report by CFReport Crystal has weak error handling and tends to return meaningless error messages in its web reports piece. -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 26, 2001 9:40 PM To: CF-Talk Subject: Crystal Reports Integration Has anyone used crystal Reports in CF5? Do I have to export the reports from Crystal in some special format in order for the CFREPORT tag to read them? This is the error I am getting: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File C:\sites\xxx\reports\summarybygroup.rpt: Invalid export DLL or export format.). Crystal Library = C:\WINNT\system32\CRPE32.DLL (1/28/2000 15:16) DLL Version = 8.0, Engine Version = 8.0 Any hints or tips? I thought, naively, that it would all just work :) -Gel __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports Integration
Has anyone used crystal Reports in CF5? Do I have to export the reports from Crystal in some special format in order for the CFREPORT tag to read them? This is the error I am getting: Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 692 ocurred (Error in File C:\sites\xxx\reports\summarybygroup.rpt: Invalid export DLL or export format.). Crystal Library = C:\WINNT\system32\CRPE32.DLL (1/28/2000 15:16) DLL Version = 8.0, Engine Version = 8.0 Any hints or tips? I thought, naively, that it would all just work :) -Gel __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Crystal Reports (ver) support in CF5
I'm looking into Active Reports in order to generate editable .rtf documents on the fly... http://www.datadynamics.com/activereports/default.htm Also, I am working with CERN produced perl script to do the same. -Mike Richard Colman wrote: Does anyone know which specific version of Crystal Reports is supported by CF5? Is it ver. 8 or ver. 8.5 ?? TNX if anyone knows. Richard Colman ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crystal Reports (ver) support in CF5
Does anyone know which specific version of Crystal Reports is supported by CF5? Is it ver. 8 or ver. 8.5 ?? TNX if anyone knows. Richard Colman ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists