1. 

   dharkness, Member

   On the page that describes the "hidecolumn" function

   http://mydbr.com/doc/content/cmd.styles.html#dbr.hidecolumn

   the example says "hidecolumns".

   select 'dbr.hidecolumns', ColumnReference / nbr of columns from right to hide
   select 'dbr.hidecolumns', ColumnReference [, ColumnReference...]

   The second example should be "dbr.hidecolumn" without an "s".

   select 'dbr.hidecolumns', ColumnReference / nbr of columns from right to hide
   select 'dbr.hidecolumn', ColumnReference [, ColumnReference...]

   Also, does "dbr.hidecolumns" allow a ColumnReference? Which reference would you use if you wanted to hide the last two columns?
2. 

   myDBR Team, Key Master

   Hi,
   there is two commands for hiding columns.

   dbr.hidecolumns hides columns from the right by specifying either the starting column (ColumnReference) to hide from or number of columns to hide.

   dbr.hidecolumn on the other hand is intended to be used when individual columns are hidden anywhere in the query.

   Which reference would you use if you wanted to hide the last two columns?

   The recommended way is to use dbr.hidecolumns and use the ColumnReference to the penultimate column. This way even when your report adds additional columns to be hidden, you can just add them to the end of query and they will be hidden automatically.

   --
   myDBR Team
3. 

   dharkness, Member

   I understand that there are two methods of hiding columns. The problem is that the example for the second method (singular "hidecolumn") has a typo as it uses the plural form ("hidecolumns").

   select 'dbr.hidecolumns', ColumnReference [, ColumnReference...]

   should be changed to

   select 'dbr.hidecolumn', ColumnReference [, ColumnReference...]

   Note 'dbr.hidecolumn' instead of 'dbr.hidecolumns'.
4. 

   myDBR Team, Key Master

   Now fixed. Thank you for pointing that out.

   --
   myDBR Team

Reply

You must log in to post.