I have complex reports - some with few result sets displayed on the same page, others - with multiple linked reports within one page etc.
I need to suppress export option depending on the group(s) of logged in user. However, when I have basic logic in my proc like:
IF (...) THEN
SELECT 'dbr.export.options', 'disable', 'pdf,excel,csv,sql';
it does not seem to have any effect.
In case with multiple result sets in the report, I tried to place it at the very beginning of the proc code, before each result set (SELECT statement) etc. Still, export options are visible.
In case when I have very simple single select statement (one result set) type of report - this works just fine and export icon gets suppressed.
What am I missing?