Drill-through report disappearing
I've created a custom drill-through report, not using a pre-defined view hierarchy. This drill-through is field>filter linked, and i have selected the option to open a pop-up window when the hyperlink (field) is clicked. I have found that this all works fine, yet every now and then the hyperlink will disappear completely and our users will not get a chance to view the drill-through report shown on the pop-up window.
When i proceed to edit the report's related content, i can see that my drill-through report has disappeared completely. As shown below:
Below is an image of how i set up the drill-through in the first place:
This hyperlinked field>filter relationship works fine for a few days and then will completely disappear, so i've been resetting it manually every now and then. It seems to disappear randomly but the max that it stays functioning is approx 2-3 days.
Both reports (parent and drill-through) use fields generated by a SAS program which updates SQL server. The parent report's database updates o/night, while the drill-through updates by the hour. I was thinking these differing refresh rates may have something to do with the drill-through disappearing. Any help greatly appreciated, cheers.