InfoPath Dev

Hi - this is qRules 4.1? What version of InfoPath? What version of SharePoint? We just saw this internally in a 4.1 form with IP 2007 / ShP 2007 - and there is a work around, but I'm wondering if you are using 4.1

Oh, I made a mistake! count (../../OptGroup_EQUIPMENT/EQUIPMENT/equipmenttype[. = "Ladder" and ../EquipInsp = 'Fail'])

What field are you setting the default value on?

I think it might be more like: count (../../OptGroup_EQUIPMENT/EQUIPMENT/equipmenttype[. = "Ladder" and EquipInsp = 'Fail']) You can attach a screenshot of your main data source under the Options tab - that can help us with the XPath if needed.

Where are you doing this? From code? Or from a rule? What field is the rule on? Or is it on a control?

Is this the error from the SharePoint logs? Is your form set as full trust before you admin approve it? If you aren't using data connections for your web service, the form will have to be full trust. Here's a StackOverflow thread on this exception - you may be able to find other that will give you ideas for tracking the issue ...

In your sample form, you also need to add a rule to QtyBox to update your TotalBox. Rules run when the field with the rule changes. You set the drop down to C, and at that point QtyBox is blank. So, it has no value to include in your calc. But if you add another rule to the QtyBox field to set the TotalBox field, you'll be find. As to your ...

Generally, your options are to create rules on all the fields used in the calculation - so if any of them change, the rules fire to update the target field - or to use default values. Usually, for a calculation, a default value (or even an expression box, if you don't need to save the value of the field) work well.

Well, you wouldn't have to write custom code to copy your repeating secondary data into your repeating main data source. You could use qRules commands for that - either Insert & SetValue if the schemas don't match, or CopyTable if they do. Here's a link to a video I did on this - it will give you an idea on how the product works. ...