Is there any way I can abort a report, or suppress the whole report, depending on some condition detected during processing? Preferably with a message, but that's not essential.
Several of my reports can only be run for the user launching the report, but I also want to allow 'proxies' to run the report - ie users who can run the report for one or more other users - and superusers who can run it for anyone. The reports are called from VB/NET but I have no control over the calling software except for parameters and the record selection text.
I have a simple 'proxy' table which defines both the proxies and the superusers. I can check this in a subreport but that fires after the main query, so I'm stymied. If I could abort or suppress the report at that stage, I could prevent unauthorised users accessing the report.
I could conditionally suppress all the sections, but this means putting a condition on each section, which would be a pain (these are complex reports, sometimes very complex, with subreports).
I could probably also use a SQL query but I'd rather avoid that complexity too.
I'm using CR10.
Any ideas?
Andrew