In some reports, I'd like to make the column settings more dynamic. Like: hide, title, filter .... so I decide to use if-then-else to column reference name. Example:
select 'dbr.hidecolumn', IF(a=0,'','Col1'), IF(b=0,'','Col2');
But this cause the notice "Unknown column reference:". Can I disable this for this report only because I can handle it. It'll be nice if I can disable for specify column reference name.
I'd like to use a command to disable it because I open this report directly from main menu.
Nice to see if you make it happen.