It's been a long time since this was posted... I will post a reply just for the sake of those who may be looking for it in future.
I had the similar symptoms on CF 7.0.2 - the report contain subreports would hang, whereas they all worked fine separately. In the end I found out that CF hangs if the resulting length of the subreport is longer than the height of the containing section (Detail, in my case). Suprisingly - at least to me, who is used to MS Access - the section does not grow automatically, so it appear you have to allow enough space for all subreport data from the beginning. Regards, Silly Pinguin. >Hi, > >I posted this to the the Macromedia forums without luck so I'm trying >here. From what I've read, it seems like the following scenario is >common, and there may not be a known solution. Maybe you guys can help. > >Prior to upgrading to 7.0.1, my CF reports didn't hang like they do now >(ColdFusion 7.0.1 Cumulative Hot Fix 1 has no effect). On reports with >subreports, I get the "Loading Report..." message for an excessive >amount of time before receiving the connection timeout message. Doesn't >matter what format (PDF, Excel, FlashPaper). > >Reports with parameters passed in and no database interactivity work >fine, and it appears that reports based off queries work fine too. But >when I place that otherwise functioning query driven report into another >report (making it a subreport) and pass the parameters through, then it >hangs. I've had to reboot the server many times today on account of >this. > >Specifically, this morning, after restarting my dev server, the report >with the subreport timed out. I took the sub report out of the report, >and tried to run the report with just a few parameters passed in, and it >hung too. I then rebooted the server again, ran the report with just the >parameters (no subreport), and it pulled up this time. Brought in the >subreport - it timed out. Took out the subreport, ran the report without >it, and it worked. Ran the subreport as a standalone report, and this >time it hung with an RTF output. Changed to PDF output and it worked. >Tried to bring it into the report again and no go. > >Windows Server 2003 Standard Edition, IIS 6. Also, I'm programming via >Remote Desktop Connection, if that has any bearing. > >Bottom line is that since upgrading, our subreports are tripping up what >was once a functional report. Also, there is one unknown: the Web >Server's OS was upgraded during this time. Are there any issues with >Windows Server 2003 Standard Edition and the most current build of CFR? > >Any help you can give is very much appreciated. I want to stop relying >on Crystal, but now that doesn't seem possible. What settings should I >change? What am I missing? What log files can I examine? What can I >tweak? Thanks in advance. > > >Sincerely, > >Andrew ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:258347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
