Hi guys, I'm still fighting with the Report Builder (see my progress to date at http://kay.smoljak.com/archives/?coldfusion-report-builder-sanity-saving-tips/), but this new issue seems to have something to do with the IIS vs the built-in web server, so I'm hoping someone might some ideas of things to try.
Situation is this: three of my reports, which need to go into an overview reports as subreports, have complex calculations that are wrapped up in CFC calls each. These reports work flawlessly when called standalone (with the query created externally and passed in as a cfreport tag parameter). However, as subreports need the query to be created inside the report, I have moved the CFC calls into the advanced query section of the report itself (with the required CFC parameters eg dsn hardcoded for now). If I call the report standalone, it works correctly (on all servers). On my local machine with CF's built-in web server, when called as a subreport, it also works correctly. However, on the staging server - Windows 2003 with IIS, a mirror of the production server - as a subreport it doesn't work at all - I get a blank page. I've set "when no query, show headers but no data" (or whatever that option is called, don't have it in front of me right now) but still nothing. I tried moving all files into the root directory - the cfcs in a directory under the root called cfc, so I'm referencing cfc.compname and like I said, it works when called standalone on all machines - but no change. Any ideas of what to try? An alternate way of referencing the CFCs? Another way of getting that code into the report without completely rewriting it? Thanks for any troubleshooting tips :) -- Kay Smoljak http://kay.zombiecoder.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238749 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
