Scheduled report with subreport that accesses oracle sp

[mh500]

Hi, Using CE10 accessing Oracle 9i. When I schedule a report(accessing an oracle view) with a subreport(accessing a stored procedure), it will not complete - stays out there with the Running status. The report runs successfuly when I click Preview. The report also runs successfully scheduled or previewed without the subreport. The subreport runs successfully both ways when saved as a report.

I appreciate any help.
Mike

 

[synapsevampire]

Does the subreport have parameters? Are you properly setting them? This sounds like you're not getting the proper parameters passed to me.

-k

 

[mh500]

Does the subreport have parameters?
Yes - 3.

Are you properly setting them?
I believe I am because I think I would have seen a problem in preview mode. It runs successfully on demand.

 

[synapsevampire]

Preview mode has nothing to do with scheduled.

If you're not sure that you're setting them, then you probably aren't.

Go into the parameters tab when scheduling the report and make sure that the subreport parameters are set.

-k

 

[mh500]

The parameters tab only shows the 2 parameters from my base report. They are set. I do not see the 3 from the subreport which are linked to 3 fields in the base report.

Thanks for the quick replies.