Conditional 'dbr.editable'

(4 posts) (3 voices)
  1. ajdjackson, Member


    I have created a report in which I've made one of the columns editable.

    Everything is working as designed :)

    However I would like to only edit values in the column if, for example, the cell value is greater than zero.

    Is this possible?



  2. myDBR Team, Key Master

    A correction to the previous answer. If you add a cellclass 'no_edit' to the cell, the cell will not be editable.

    select 'dbr.cellclass', 'editable_cell', 'can_edit';
    select 'dbr.hidecolumn', 'can_edit'; select 'dbr.editable', .... select
    value as 'editable_cell',
    if (value=0, 'no_edit', '') as 'can_edit'
    from mytable;

    myDBR Team

  3. nsepetys, Member

    Is it possible to do it for a cell in a crosstab table that has values in other columns but for not all of them (ie the row is null for the crosstab column)? See cell below (0 value is actually NULL since Jan 15' doesn't have a value for projected values):

  4. myDBR Team, Key Master

    Use above query to get null values for those months that you do not have data for and do an UNION with the query that fecthed the existing data. This way you can set the 'no_edit' class for the non-existent cells.

    myDBR Team


You must log in to post.