1. 

   spyhunter88, Member

   Hi,

   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.

   Thanks,
2. 

   myDBR Team, Key Master

   Disabling an error message might hide an error from a user. Why not just different syntax:

   if (a=0) then select 'dbr.hidecolumn'. 'Col1;' end if;
   
   if (b=0) then select 'dbr.hidecolumn'. 'Col2;' end if;

   --
   myDBR Team
3. 

   spyhunter88, Member

   Hi, I had face it and currently using it. But with several of dynamic columns, that makes the code more complex.

   :D

   Thanks,
4. 

   myDBR Team, Key Master

   The dbr.hidecolumn will now ignore parameters that are null or empty strings. Run the updater to get the latest build.

   --
   myDBR Team

Reply

You must log in to post.