On-Demand Subreport Requires Database Logon
I have read all the posts regarding this topic on the forums and have tried the solutions, to no avail.
I have a report with a subreport. Both are pointing to the same Oracle server temp_table and stored procedure.
As of last week, this report ran fine in BI Launchpad and Central Management Console.
Now, when the report is run with the Database Configuration setup to "Use same database logon as when report is run", even though the main report and subreport point to the same table, the subreport is empty.
When I change the option of "When viewing and scheduling report" to "Prompt the user for database logon (viewing only)", I am able to go through the process of running the report, logging on for the subreport and getting data in both main and subreport.
Again, I have set and reset the database location and verified it. The only change I've made to the report in the last week is adding a "no data found" message that looks for a field to be null, then display the message.
I am using SAP BusinessObjects BI Platform 4.1 Support Pack 5 Patch 2 (Version 18.104.22.1688).
I am using Crystal Reports 2013 Support Pack 5 Path 2 (Version 22.214.171.1248).
What am I missing?