Conditional expressions in Matrix

Comments

• ipong

  January 2017 edited 3:45AM

  use script, i modified sample from fastreport by adding Cell9_BeforePrint event, look at attached picture.
  
  note : in matrix report, cell is printed from left to right (to understand that, uncomment 'MessageBox' from script below).
  in your case, cell 'target' is highlighted.
  

    public class ReportScript
    {
      private void Cell9_BeforePrint(object sender, EventArgs e)
      {
        if (Cell9.Value == null)
          return;
        double a = (double) ((int)Cell6.Value);
        double b = (double) ((decimal) Cell9.Value / 1000);
  
        //MessageBox.Show(a.ToString() + " < " + b.ToString());
  
        if (a < b)
          Cell9.Fill = new SolidFill(Color.Fuchsia);
      }       
    }
  

  Untitled.png 59.8K
• RJP

  January 2017 edited January 2017

  That looked like it was going to work. But it didn't work for me.
  
  I think the issue is that I'm trying to highlight the count rather than the target, and perhaps the current row/column is not getting updated for all cells at the appropriate time.
  
  As an example, try to change your script so that it is the Items Sold that is highlighted rather than the Revenue (with the same condition). In other words change the cell9.Fill = ... lines to cell6.Fill...
  
  You'll see that it just ends up highlighting cells all over the place.

  Two_Cell_Dimensions__Side_by_Side.jpg 47K
• ipong

  January 2017 edited January 2017

  as i said before, cells are printed from left to right.
  if you want to highlight first cell when you are at second cell, it wont work because first cell already printed.
  so, in your case, switch the column, target | actual