Tablix Custom Validation Script Issue

Tablix Custom Validation Script Issue

Posted by: sboyer on 5 October 2017, 7:35 am EST

• 

  sboyer

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 October 2017, 7:35 am EST

  Hello,
  
  I have Page Report with Tablix Control and i am using Custom Script(http://help.grapecity.com/activereports/webhelp/AR11/index.html#CustomCode.html) for validations. My validation script is not executing for all the cells.

  Please run the attached sample project and notice my validation call on “Expression” column.
  
  As per my sample data my validation script has to execute 9 cells, but it is executing for 7 cells.
  
  Please let me know how to fix this issue.

  =Parser.ExportValidator.Validate((SUM(Fields.Item(“Pmt Amt 99213”).Value)+SUM(Fields.Item(“Pmt Amt 99199”).Value))/SUM(Fields.Item(“Pmt Amt 93010”).Value))

  TablixCustomValidation.zip

• 

  sboyer

  • Post Options:
  • Link
    Copy

  Posted 5 October 2017, 7:43 am EST

  Add below expression to “Pmt Amt 99213” column and notice the custom script is executing only 4 times out of 9 cells.
  
  =Parser.ExportValidator.Validate(Sum(Fields.Item(“Pmt Amt 99213”).Value))

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 10 October 2017, 3:00 am EST

  Hello,

  I am able to replicate this issue with your sample application. I will update you about the solution /workaround of this soon.

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 10 October 2017, 11:00 pm EST

  Hello,

  I have reported this issue to the concerned team for further investigation. I will let you know as soon as I get any update on this.
  
  The tracking Id for this issue is 247192

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 11 October 2017, 7:51 pm EST

  Hello,

  The issue is found to be with the Parser expression.
  
  =Parser.ExportValidator.Validate((SUM(Fields.Item(“Pmt Amt 99213”).Value)+SUM(Fields.Item(“Pmt Amt 99199”).Value))/SUM(Fields.Item(“Pmt Amt 93010”).Value))

  the above expression does not work in cases when SUM(Fields.Item(“Pmt Amt 93010”).Value) returns 0, because of division by zero error. Hence Validate() method does not work for the cells where ‘SUM(Fields.Item(“Pmt Amt 93010”).Value)’ is 0.

  Thanks,
  
  Deepak Sharma

• 

  sboyer

  • Post Options:
  • Link
    Copy

  Posted 11 October 2017, 11:04 pm EST

  Hi,
  
  Thanks for the update. I do have another scenario where my expression does not contain any division and still see the issue.

  If you add below expression to “Pmt Amt 99213” column and notice the custom script is executing only 4 times out of 9 cells.

  =Parser.ExportValidator.Validate(Sum(Fields.Item(“Pmt Amt 99213”).Value))

  Notice this expression does not contain any division operator.

  Thanks,
  
  Anwar

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 17 October 2017, 1:09 am EST

  Hello,

  I have informed the developer about the same. I will let you know as soon as I hear anything on this.

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 25 October 2017, 7:54 pm EST

  Hello,

  As per the developer the: Fields.Item(“Pmt Amt 99213”).Value really returns null. So of the Validate function parameter must be reference-type.

  Please refer to the attached sample application.

  Thanks,
  
  Deepak SharmaValidationWithTablix1.zip