validation rules on fields - any solutions?

Hi Mavis, We also faced this problem - what I ended up doing is created calculated fields with the if then else logic in them returning cleanup text if there was a problem. eg: CDQ1: IF(LEN(Commentary Exec Summary)<=10,'Commentary must be longer than 10 characters','') I found it useful also to have a calculated field that showed the number of tests that failed as well so that in the report below I can quickly filter to the rows to show. And then I created a report that concatenates all the comments together using text mode so that user can go to one place (and management can see all the errors in one place) - in the below you carry on adding columns for each check you've got - not perfect by any means : column.7.displayname=DQ Condition Combined Commentary column.7.linkedname=direct column.7.namekey=CDQ1_Commentary_Length column.7.querysort=DE:CDQ1_Commentary_Length column.7.sharecol=true column.7.textmode=true column.7.valuefield=CDQ1_Commentary_Length column.7.valueformat=customDataLabelsAsString column.7.width=400 column.8.sharecol=true column.8.textmode=true column.8.value=

---

column.8.valueformat=HTML column.8.width=1 If you want to have a quick call so I can show you then just get in touch (andrew.parsons@refinitiv.com). Andrew Parsons

Thank you! I sent you an email to do a quick phone call. Mavis Moon mmoon@pivotinteriors.com