Hide notice "Unknown column reference: " for empty column name?

(4 posts) (2 voices)


No tags yet.

  1. spyhunter88, Member


    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.


  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.



  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


You must log in to post.