1. 

   ajdjackson, Member

   Hi

   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?

   Cheers

   Jake
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
   
     Name,
   
     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

Reply

You must log in to post.