AnsweredAssumed Answered

On-Demand Sub Report Failing

Question asked by Halty on Sep 14, 2010
Latest reply on Sep 22, 2010 by Chris_Hackett

I'm building a report that has an on-demand subreport in it and it works fine in the dev environment. However, when I migrate it to QA, update the database credentials in the CMC, the main report works, but the sub report fails with a "Error in File /QD Reports/QD_IT_ChargeCode.rpt: Failed to retrieve data from the database. "

The subreport uses a stored procedure in Oracle and so does the main report. The reports are properly linked. I have other reports that have this arrangement and they work fine.

The funny thing is that if I change the sub report from an 'on-demand' sub report to an inline subreport, it runs fine with no errors.

Has anyone seen this? Is there a way to log events like this with lots of details? Perhaps in the CMC?

Thanks for reading,