Re: Integrating SQL Reporting Services with ColdFusion
Hello: I am able to call the reports from coldfusion using cfhttp.Pass the username and password since cfhttp works with Windows Basic Authentication. Need,therefore, to change the IIS virtual mapping to ReportServer to use also Basic Authentication (we use https in an intranet environment).We use ajax to maintain the report on the application. We have not been able to make rs:ShowHideToggle work. ~| 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:314235 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Integrating SQL Reporting Services with ColdFusion
Before I start trying to crack this nut I'll check-in to see if anyone else has made progress since the last posting. From what I see on the MSDN site, there may be problems in doing this from a non-ASPdotNET site while retaining all of the SSRS functionality, because the reporting controls are written in .NET. The article at http://msdn.microsoft.com/en-us/library/ms155131(SQL.90).aspx talks about being able to use the SSRS SOAP API with reduced functionality, to be able to render the report into any of the SSRS-supported output formats, but that's about it. Of course the .NET sample app they show is too simplistic to be of much use. But my goal is the same as the original posters of this thread, to be able to display SSRS reports in my CF app, hopefully without exposing the URL path to those reports. thanks! Reed ~| 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:312008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Integrating SQL Reporting Services with ColdFusion
Hmm, if someone has actually used CF to call MS SQS reporting services as a web service, please let us know. We have talked about doing this for a while, but have never tried. I would be very interested in seeing it actually demonstrated. ~Brad -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 3:51 PM To: CF-Talk Subject: Re: Integrating SQL Reporting Services with ColdFusion I never got around to pursuing this much. It is still on my todo list. I used ASP.NET 2.0 instead of ColdFusion to connect to reporting services. I am still interested in how to do this using ColdFusion. Does the web service return a rendered report, or does the web service return the instructions needed to render the report (which CF can't deal with). I did not use the Web service method to embed the reports, so I am not sure. -Mike Chabot On 1/25/07, Alice Burnes <[EMAIL PROTECTED]> wrote: > Just wondering if you made any headway. I've been trying to find ANYTHING on this topic and have gotten almost nowhere. > > Using the webservice, at the moment I can view a list of reports and view the reports using the URL accessiblity method but when I try to use the webservice to actually get the reports...splat! At the moment I'm trying the render method and getting nowhere. > > Any pointers/references would be very welcome! > > I'm actually stunned that I can't find any concrete examples of using webservices to display reports using CF MX (MX or MX7) given that Reporting Services has been around for a while now--almost feel like it is a bit of a conspiracy:) > > Alice > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http: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:267688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Integrating SQL Reporting Services with ColdFusion
I never got around to pursuing this much. It is still on my todo list. I used ASP.NET 2.0 instead of ColdFusion to connect to reporting services. I am still interested in how to do this using ColdFusion. Does the web service return a rendered report, or does the web service return the instructions needed to render the report (which CF can't deal with). I did not use the Web service method to embed the reports, so I am not sure. -Mike Chabot On 1/25/07, Alice Burnes <[EMAIL PROTECTED]> wrote: > Just wondering if you made any headway. I've been trying to find ANYTHING on > this topic and have gotten almost nowhere. > > Using the webservice, at the moment I can view a list of reports and view the > reports using the URL accessiblity method but when I try to use the > webservice to actually get the reports...splat! At the moment I'm trying the > render method and getting nowhere. > > Any pointers/references would be very welcome! > > I'm actually stunned that I can't find any concrete examples of using > webservices to display reports using CF MX (MX or MX7) given that Reporting > Services has been around for a while now--almost feel like it is a bit of a > conspiracy:) > > Alice > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http: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:267687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Integrating SQL Reporting Services with ColdFusion
Just wondering if you made any headway. I've been trying to find ANYTHING on this topic and have gotten almost nowhere. Using the webservice, at the moment I can view a list of reports and view the reports using the URL accessiblity method but when I try to use the webservice to actually get the reports...splat! At the moment I'm trying the render method and getting nowhere. Any pointers/references would be very welcome! I'm actually stunned that I can't find any concrete examples of using webservices to display reports using CF MX (MX or MX7) given that Reporting Services has been around for a while now--almost feel like it is a bit of a conspiracy:) Alice ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http: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:267677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Integrating SQL Reporting Services with ColdFusion
Also along these lines... I just picked up and starting reading the October 2006 issue of SQL Server Magazine from my DBA's desk. It has an entire article on integrating MS SQL Server Reporting Services into a web application. (Page 27) It's pretty high-level so far, but might prove helpful. ~Brad -Original Message- From: Christine Davis Sent: Wednesday, October 04, 2006 5:17 PM To: CF-Talk Subject: RE: Integrating SQL Reporting Services with ColdFusion Mike, I'm digging way back in my brain to a demo we saw last year using SSRS but I believe they expose all the SSRS functionality through a web services API. You could write your own interface using the Web Services provided... Can you keep me updated as to how your project goes, we might be moving in the same direction here :) Thanks! Christine Davis ColdFusion Lead Nations Technical Services Prairie Village, KS 913-748-8044 ext 4703 [EMAIL PROTECTED] -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 12:53 PM To: CF-Talk Subject: Integrating SQL Reporting Services with ColdFusion I am looking to embed SQL Server 2005 Reporting Services reports inside of a ColdFusion application. The options that come to mind are: 1. Run the report on the Reporting Services server (not good for security reasons) 2. Run the report in an iFrame (possible, but I am not a huge fan of iFrames) 3. Use cfhttp and strip away all the unnecessary HTML (possible, would require me to code this) Has anyone come up with a good solution to this integration problem that they are happy with? Has anyone coded a cfhttp solution already? I am mainly interested in having a reusable data grid where you can roll-up rows, sort on column headers, and calculate summary data. Maybe someone knows of a good way to do this that would bypass Reporting Services? Thank you, Mike Chabot ~| 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:255549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Integrating SQL Reporting Services with ColdFusion
Mike, I'm digging way back in my brain to a demo we saw last year using SSRS but I believe they expose all the SSRS functionality through a web services API. You could write your own interface using the Web Services provided... Can you keep me updated as to how your project goes, we might be moving in the same direction here :) Thanks! Christine Davis ColdFusion Lead Nations Technical Services Prairie Village, KS 913-748-8044 ext 4703 [EMAIL PROTECTED] -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 12:53 PM To: CF-Talk Subject: Integrating SQL Reporting Services with ColdFusion I am looking to embed SQL Server 2005 Reporting Services reports inside of a ColdFusion application. The options that come to mind are: 1. Run the report on the Reporting Services server (not good for security reasons) 2. Run the report in an iFrame (possible, but I am not a huge fan of iFrames) 3. Use cfhttp and strip away all the unnecessary HTML (possible, would require me to code this) Has anyone come up with a good solution to this integration problem that they are happy with? Has anyone coded a cfhttp solution already? I am mainly interested in having a reusable data grid where you can roll-up rows, sort on column headers, and calculate summary data. Maybe someone knows of a good way to do this that would bypass Reporting Services? Thank you, Mike Chabot ~| 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:255545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Integrating SQL Reporting Services with ColdFusion
I am looking to embed SQL Server 2005 Reporting Services reports inside of a ColdFusion application. The options that come to mind are: 1. Run the report on the Reporting Services server (not good for security reasons) 2. Run the report in an iFrame (possible, but I am not a huge fan of iFrames) 3. Use cfhttp and strip away all the unnecessary HTML (possible, would require me to code this) Has anyone come up with a good solution to this integration problem that they are happy with? Has anyone coded a cfhttp solution already? I am mainly interested in having a reusable data grid where you can roll-up rows, sort on column headers, and calculate summary data. Maybe someone knows of a good way to do this that would bypass Reporting Services? Thank you, Mike Chabot ~| 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:255479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
