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
