We have a mainj report that passes a filter to a subreport, and the problem currently is that when the user clicks the refresh button, it queries the database. We don't want this. We have the Process options for scheduling set to 'refresh hit database' attribute = false. This was configured by unchecking the 'report returns current data' box, and 'clients share'. The report currently uses its Teradata connection and recordset through a command saved to the repository.
This has become a major problem, and we can't seem to find the recipe to stop the refresh button from hitting the database. Any help appreciated, and I will gladly send files and code.
Report Options: Save Data with report, unticked verify on first
Options: unticked verify on first
Schedule unticked 'returns current data' and 'clients share'.
Subreport passed parameter to conditional suppression in latest version, though we tried filtering via record selection as well.
We have not yet tried repository BV connections, though that may be a next desparate step.